What db versions are you using and what os's ?
-----Original Message-----
From: henry Wollman
[mailto:oracledba-ezmlmshield-x71412494.[Email address protected]
Sent: Friday, January 27, 2006 11:59 AM
To: LazyDBA Discussion
Subject: import of system
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
|_____________________________________________________
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page