PLS-00201:
identifier 'DBMS_PLUGTS.NEWDATAFILE' must be declared
Error :
PLS-00201: identifier 'DBMS_PLUGTS.NEWDATAFILE' must be
declared
Transport tablespace from one database to another and got
the following error during import.
myoradb10
| DREP | /export/oracle
>
imp transport_tablespace=y datafiles='/u10_DREP/oradata/REP_TEST/DREP_LOG_2011Q4/DREP_log_2011Q4_01.dbf','/u10_DREP/oradata/REP_TEST/DREP_LOG_2011Q4/DREP_log_2011Q4_02.dbf'
file=DREP_LOG_2011Q4_dumpfile_exp.dmp log=DREP_LOG_2011Q4_dumpfile_exp.log
Import:
Release 11.2.0.3.0 - Production on Fri Jul 12 14:49:59 2013
Copyright
(c) 1982, 2011, Oracle and/or its affiliates.
All rights reserved.
Username:
/as sysdba
IMP-00004:
invalid username or password
Username:
system
Password:
Connected
to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
Production
With
the Partitioning, OLAP, Data Mining and Real Application Testing options
Export
file created by EXPORT:V11.02.00 via conventional path
About
to import transportable tablespace(s) metadata...
Warning:
the objects were exported by SYS, not by you
import
done in AL32UTF8 character set and AL16UTF16 NCHAR character set
export
client uses US7ASCII character set (possible charset conversion)
IMP-00003:
ORACLE error 6550 encountered
ORA-06550:
line 1, column 7:
PLS-00201:
identifier 'DBMS_PLUGTS.NEWDATAFILE' must be declared
ORA-06550:
line 1, column 7:
PL/SQL:
Statement ignored
IMP-00000:
Import terminated unsuccessfully
Solution: Import as
“sys as sysdba”
myoradb10
| DREP | /export/oracle
>
imp transport_tablespace=y datafiles='/u10_DREP/oradata/REP_TEST/DREP_LOG_2011Q4/DREP_log_2011Q4_01.dbf','/u10_DREP/oradata/REP_TEST/DREP_LOG_2011Q4/DREP_log_2011Q4_02.dbf'
file=DREP_LOG_2011Q4_dumpfile_exp.dmp log=DREP_LOG_2011Q4_dumpfile_exp.log
Import:
Release 11.2.0.3.0 - Production on Fri Jul 12 14:53:14 2013
Copyright
(c) 1982, 2011, Oracle and/or its affiliates.
All rights reserved.
Username:
sys as sysdba
Password:
Connected
to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
Production
With
the Partitioning, OLAP, Data Mining and Real Application Testing options
Export
file created by EXPORT:V11.02.00 via conventional path
About
to import transportable tablespace(s) metadata...
import
done in AL32UTF8 character set and AL16UTF16 NCHAR character set
export
client uses US7ASCII character set (possible charset conversion)
.
importing SYS's objects into SYS
.
importing SYS's objects into SYS
.
importing REPADM's objects into REPADM
.
. importing table "ARCH_REP_LOG_2011Q4"
.
importing SYS's objects into SYS
Import
terminated successfully without warnings.
myoradb10
| DREP | /export/oracle
>
No comments:
Post a Comment