OraFAQ Forum: Server Utilities » How can i import database by using dump file?

Home » RDBMS Server » Server Utilities » How can i import database by using dump file?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can i import database by using dump file? [message #231454]

Tue, 17 April 2007 02:53

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?

Report message to a moderator

Re: How can i import database by using dump file? [message #231461 is a reply to message #231454]

Tue, 17 April 2007 03:10

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

imp show=y rows=n

Regards
Michel

Report message to a moderator

Re: How can i import database by using dump file? [message #231472 is a reply to message #231454]

Tue, 17 April 2007 04:06

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 ?

Report message to a moderator

Re: How can i import database by using dump file? [message #231474 is a reply to message #231472]

Tue, 17 April 2007 04:09

Michel Cadot
Messages: 68770
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

Report message to a moderator

Re: How can i import database by using dump file? [message #231492 is a reply to message #231454]

Tue, 17 April 2007 05:05

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

Report message to a moderator

Re: How can i import database by using dump file? [message #231495 is a reply to message #231492]

Tue, 17 April 2007 05:18

Michel Cadot
Messages: 68770
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

Littlefoot
Messages: 21826
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.).

Report message to a moderator