i dont know why it appears to try to run system.
dorsnt seem to blow it up for me so far.
anyway this might be your problem.
1. cd to $ORACLE_HOME/rdbms/admin
2. Connect as user SYS or do CONNECT INTERNAL
3. to check if catalog.sql has been run issue
select * from v$controlfile;
If this fails then catalog.sql has not been run.
4. to check if catproc.sql has been run issue
desc STANDARD
If this fails then catproc has not been run.
5. Depending on 3 or 4 above, run
6. Rerun the Export job.
So i would re run catalog and catproc regardless to be sure they are
in there and valid etc.
-----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