I am doing a full export and full import to copy data from one DB to another
(different OS).



I know you are not supposed to import system schema, so why does the import
try?



These are my export parms:

userid="sys/a***l as sysdba"

buffer=1000000

file=full.dmp

log=fullexp.log

full=y

compress=y

consistent=y

recordlength=57344

statistics=none



These are my import parms:

userid="sys/a***l as sysdba"

file=full.dmp

log=fullimp.log

full=y

recordlength=57344

buffer=1000000

ignore=y

analyze=n

commit=y

compile=n

statistics=none



I get many errors like this in the import:



. importing SYSTEM's objects into SYSTEM

IMP-00017: following statement failed with ORACLE error 6553:

"BEGIN "

"SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('MANAGE_ANY','DBA',TRUE);"

"COMMIT; END;"

IMP-00003: ORACLE error 6553 encountered

ORA-06553: PLS-213: package STANDARD not accessible



Should I be excluding the system schema?

| Henry A.L. Wollman Database Administrator
|_____________________________________________________
| Moody Bible Institute 312-329-2291
| 820 N. LaSalle Blvd 312-329-8961 FAX
| Chicago, IL 60610 [Email address protected]
| www.moody.edu
|
| Consider it pure joy, my brothers, whenever you face
| trials of many kinds... James 1:2
|_____________________________________________________




Oracle LazyDBA home page