Home » RDBMS Server » Server Utilities » How can i import database by using dump file?
How can i import database by using dump file? [message #231454] Tue, 17 April 2007 02:53 Go to next message
kaisy.lin
Messages: 12
Registered: April 2007
Junior Member
here is what i need to know:
i got one dump file ,i have no idea about how many datafiles that i need to create to import the data from dump file ?
how can i parse the dump file so that i can know the basic structure of the original database?
Re: How can i import database by using dump file? [message #231461 is a reply to message #231454] Tue, 17 April 2007 03:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
imp show=y rows=n

Regards
Michel
Re: How can i import database by using dump file? [message #231472 is a reply to message #231454] Tue, 17 April 2007 04:06 Go to previous messageGo to next message
kaisy.lin
Messages: 12
Registered: April 2007
Junior Member
thank you for your immediate reply.
i followed what you said.but after create a lots of definition of the objects , there is a line showed up in screen like this '...skip table "table_name"

could you please kindly tell me what's wrong ?
Re: How can i import database by using dump file? [message #231474 is a reply to message #231472] Tue, 17 April 2007 04:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Post a couple of lines before and after the message (and format it).

Regards
Michel
Re: How can i import database by using dump file? [message #231492 is a reply to message #231454] Tue, 17 April 2007 05:05 Go to previous messageGo to next message
kaisy.lin
Messages: 12
Registered: April 2007
Junior Member
i did some research on that file

it consist of a lots of phrase like this

-----------------------------------------------------------------------------
"GRANT DELETE ON "COMPANY_SEASON" TO "EFSNROLE""
"GRANT INSERT ON "COMPANY_SEASON" TO "EFSNROLE""
"GRANT SELECT ON "COMPANY_SEASON" TO "EFSNROLE""
"GRANT UPDATE ON "COMPANY_SEASON" TO "EFSNROLE""
"CREATE UNIQUE INDEX "XAK1COMPANY_SEASON" ON "COMPANY_SEASON" ("PARENT_COMPA"
"NY_ID" , "NAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536"
" FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "JAS1_INDX" LOGGING"
"CREATE INDEX "XIF592COMPANY_SEASON" ON "COMPANY_SEASON" ("PARENT_COMPANY_ID"
"" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 F"
"REELIST GROUPS 1) TABLESPACE "JAS1_INDX" LOGGING"
"CREATE UNIQUE INDEX "XPKCOMPANY_SEASON" ON "COMPANY_SEASON" ("COMPANY_SEASO"
"N_ID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS"
" 1 FREELIST GROUPS 1) TABLESPACE "JAS1_INDX" LOGGING"
"ALTER TABLE "COMPANY_SEASON" ADD CONSTRAINT "XAK1COMPANY_SEASON" UNIQUE (""
"PARENT_COMPANY_ID", "NAME") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 "
"STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "JAS1_INDX""
" LOGGING ENABLE "
"ALTER TABLE "COMPANY_SEASON" ADD CONSTRAINT "XPKCOMPANY_SEASON" PRIMARY KE"
"Y ("COMPANY_SEASON_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STOR"
"AGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "JAS1_INDX" LOG"
"GING ENABLE "
"CREATE TABLE "COMPANY_SEASON_ITEM" ("COMPANY_SEASON_ID" NUMBER(7, 0) NOT NU"
"LL ENABLE, "MONTH" NUMBER(2, 0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INI"
"TRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) T"
"ABLESPACE "JAS1_DATA" LOGGING NOCOMPRESS"
. . skipping table "COMPANY_SEASON_ITEM"

--------------------------------------------------------------

but for one certain table A , all program stopped , i am not sure if this issu has something with the amount of record in this table A
Re: How can i import database by using dump file? [message #231495 is a reply to message #231492] Tue, 17 April 2007 05:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
The imp SEEMS to halt but it is currently skipping the table data to get the next DDL.

Regards
Michel

[Updated on: Tue, 17 April 2007 05:20]

Report message to a moderator

Re: How can i import database by using dump file? [message #231902 is a reply to message #231472] Wed, 18 April 2007 15:33 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
...skip table "table_name"

could you please kindly tell me what's wrong ?

Nothing is wrong. This is expected behaviour of the IMP command with the ROWS parameter set to N (No) - it says that no records are to be imported into a table. At the same time, SHOW=Y lists all DDL statements (CREATE TABLE, CREATE PROCEDURE, GRANT privileges etc.).
Re: How can i import database by using dump file? [message #231929 is a reply to message #231454] Wed, 18 April 2007 20:55 Go to previous messageGo to next message
kaisy.lin
Messages: 12
Registered: April 2007
Junior Member
thank your for reply ,
i did use rows=n .
at that moment , i didn't notice that parameter.
Re: How can i import database by using dump file? [message #233667 is a reply to message #231929] Fri, 27 April 2007 02:35 Go to previous message
colly_liu
Messages: 6
Registered: April 2007
Junior Member
you can use the parameter indexfile=filename,then,find tablespace in the file.
Previous Topic: Calling SQLLDR using crontab
Next Topic: Script to recreate user before import of data
Goto Forum:
  


Current Time: Wed Dec 25 11:51:36 CST 2024