import - export [message #51292] |
Tue, 14 May 2002 00:35 |
hnetscape
Messages: 30 Registered: December 2001 Location: India
|
Member |
|
|
Hello sir,
I have win nt with oracle 7.3x. I have taken export backup as a .dmp file. I have another system with win nt and same oracle installed freshly. Now I want to import the data to the new system, if I use imp command at command prompt that is importing files but it is taking 10-12 hours to complete the job. Is there any other method by which I can do import the data to the new machine in 1 or 2 hours time. Backup file size is 560MB. If I copy the d:orantdatabase folder of old machine to new machine, the new machine will work fine without importing the dmp file. Please give me step by step processes for importing.
Regards,
Raju.
|
|
|
Re: import - export [message #51294 is a reply to message #51292] |
Tue, 14 May 2002 05:32 |
oraboyy
Messages: 2 Registered: May 2002
|
Junior Member |
|
|
Hey Raju,
10-12 hrs for import is too long a time, that too for 560M, if your intention is to have the replica of the database in another system, then better take the cold backup of the prod database andcopy the files to another system and make it up.
Hope that helps,
Oraboyy
|
|
|
Re: import - export [message #51296 is a reply to message #51292] |
Tue, 14 May 2002 06:15 |
Sanjay Bajracharya
Messages: 279 Registered: October 2001 Location: Florida
|
Senior Member |
|
|
To improve the import, set the 'buffer' param while importing.
imp ...... buffer=524288
this should make a lot of difference. Plus 10-12 hours for a 560MB is REALLY a lot.
Good luck.
|
|
|
Re: import - export [message #51309 is a reply to message #51292] |
Wed, 15 May 2002 04:36 |
sharma
Messages: 10 Registered: February 2002
|
Junior Member |
|
|
hi,
import with buffer=500000 commit=y option and indexes=N options it will centainly take less time
letter you can create the indexes later
hope it'll help you
h. b. sharma
|
|
|
Re: import - export [message #51321 is a reply to message #51292] |
Wed, 15 May 2002 09:43 |
Grant
Messages: 578 Registered: January 2002
|
Senior Member |
|
|
Along with BUFFER, COMMIT=Y and INDEXES=N I would add:
ANALYZE=N
You can do analyze later.
Be careful with BUFFER. Oracle recommends using:
buffer = rows in array * recordlength
This will avoid:
ORA-4030: out of process memory when trying to allocate %s bytes (%s,%s)
IMP-44: unable to allocate enough memory for statement ""
IMP-3: ORACLE error %lu encountered
I have always used 64K for BUFFER and never had a problem. Test it. You might want to read up on BUFFER and export/import in MetaLink.
|
|
|