| IMP/EXP [message #64266] |
Thu, 06 January 2005 22:51  |
Vivek Vijai
Messages: 67
Registered: April 2004
|
Member |
|
|
Hi,
I took the export of my Production Db (user level)
Oracle 9i. To test the authenticity of the dump
i tried to restore 1-2 tables in seperate schema.
Though the tables got imported by the process of import was extremely slow. I have sufficient space on my hard disk and the dump file was also kept in the same hard disk(ie no network access) and RAM is 1G.
Can anyone throw some light on the same.
Thanks in advance.
Vivek
|
|
|
|
| Re: IMP/EXP [message #64267 is a reply to message #64266] |
Fri, 07 January 2005 00:55  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
import is a very serial process.
So it is naturally slow.
1. Do not import indexes.
first just import the table and data
$ imp dba/user fromuser=x touser=y file=myFile.dmp indexes=n
after data is created recreate the indexes seperately.
YOU can get the ddl of index from myFile.dmp itself using indexfile option. edit the DDL and create index in parallel using sqlplus or any tool.
2. increase your sort_area_size.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
