Home » RDBMS Server » Server Utilities » Collective Export and Import (ORACLE 9i)
Collective Export and Import [message #418136] Thu, 13 August 2009 02:24 Go to next message
Saikirupa
Messages: 10
Registered: August 2009
Junior Member
Hi All,

I have a query regarding Collective import. We have a crontab job which will take a dump of 7 schemas daily. ( All 7 schemas in a single dump file)

When i try to import the 7th schema in the list, its taking nearly 30 - 40 minutes to initiate the import process. Is it because its the last schema in the list?? Coz I am getting this problem only when i try to import the last schema.
Re: Collective Export and Import [message #418139 is a reply to message #418136] Thu, 13 August 2009 02:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Most likely, yes.

Regards
Michel
Re: Collective Export and Import [message #418146 is a reply to message #418136] Thu, 13 August 2009 03:09 Go to previous messageGo to next message
Saikirupa
Messages: 10
Registered: August 2009
Junior Member
Any solution to overcome this??
Re: Collective Export and Import [message #418149 is a reply to message #418146] Thu, 13 August 2009 03:26 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Buy faster disks.
Oracle has to read the entire file to get where the one you're searching for starts.

Regards
Michel
Previous Topic: Error in loading chinese characters
Next Topic: Loading from xml file to staging table in Oracle
Goto Forum:
  


Current Time: Mon Dec 23 20:17:08 CST 2024