Import from multiple files

All posts relating to Oracle database administration.

Moderator: Tim...

Import from multiple files

Postby Guest » Mon Nov 01, 2004 6:09 pm

Hello Tim,

I have export dump that spans across multiple files (about 20)

Is there a way to import all these dump files using a single "imp" command ?
If yes, what to specify in the "file" parameter of "imp" command ?

Or do I need to execute 20 "imp" commands ?


Thanks
Guest
 

RE:Import from multiple files

Postby Guest » Mon Nov 01, 2004 6:09 pm

Got from OTN docs that we can use -

imp scott/tiger IGNORE=y FILE = dat1.dmp, dat2.dmp, dat3.dmp FILESIZE=2048

BTW, which is the recommeded way ?
Guest
 

RE:Import from multiple files

Postby Guest » Mon Nov 01, 2004 6:09 pm

Secondly, please give some tips to import this huge data

I know few like -
compile=n, index=n (and then creating index from the index file created using indexfile) etc

But your kind advice will be of great help

Thanks
Guest
 

RE:Import from multiple files

Postby Tim... » Mon Nov 01, 2004 6:09 pm

Hi.

You seem to have it pretty well covered.

You need to import them all in one go if they were generated from a single export. If speed is your number 1 issue then I would avoid having indexes and foreign keys on any preexisting tables that are being imported into. If non of the tables exist the it doesn't matter as the tables are created, loaded then the indexes are built by the import. Only at the end of the import are the constraints enabled, so the whole process can't really get much faster by doing it manually.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

RE:Import from multiple files

Postby Guest » Mon Nov 01, 2004 6:09 pm

Thanks Tim.
Just curious to know why we need to import them all in one go if they were generated from a single export ?
Guest
 

RE:Import from multiple files

Postby Tim... » Mon Nov 01, 2004 6:09 pm

Hi.

Each file is only a portion of the whole export and I don't believe they are self contained, such that you may have half of a table in one file and half in another etc. The file split is based on the size you specified on the export, not on a convenient break point.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 8 guests

cron