Hi,
I am try to import 4G dump in Oracle 11R2 version, in that we have around 9000+ Package Body which is taking huge time than other objects (about 8 to 12 hrs) and also it is expecting lots of system space (roughly about 10GB).
I have tried both parallel and non-parallel.
Please advice, how to improve speed of the package body import.
Details about the Schema & Import
No. of objects in Schema
SQL> select object_type,count(1) from user_objects GROUP BY ROLLUP( object_type);
OBJECT_TYPE COUNT(1)
------------------- ----------
FUNCTION 248
INDEX 5161
JAVA CLASS 471
JAVA RESOURCE 1
JAVA SOURCE 16
LIBRARY 1
LOB 131
MATERIALIZED VIEW 1
PACKAGE 9605
PACKAGE BODY 9526
PROCEDURE 491
OBJECT_TYPE COUNT(1)
------------------- ----------
SEQUENCE 17684
SYNONYM 15699
TABLE 5795
TABLE PARTITION 18
TRIGGER 377
TYPE 105
VIEW 2707
68037
Impdp Parameter
userid=USERID/PASSWORD
logfile=IMPORT.LOG
dumpfile = DATA_FINAL.DMP
directory=IMPORT_DUMP_DIR
job_name = IMPORT_JOB_imp
REMAP_TABLESPACE = SOURCE:DEST
remap_schema = SOURCE:DEST
EXCLUDE=GRANT,STATISTICS
Regards,
Arul.
] 
Blog
Search
Help
Members
Register
Login
Home
