1. 在oracle 9i所在服務器上安裝oracle 10g，并建庫，創建用戶scott，不創建用戶表空間： SQL select * from v$version; BANNER —————————————————————- Oracle Database 10g Enterprise Edition Release 10.2.0.1
1. 在Oracle 9i所在服務器上安裝oracle 10g，并建庫，創建用戶scott，不創建用戶表空間：
SQL> select * from v$version;
BANNER
—————————————————————-
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Prod
PL/SQL Release 10.2.0.1.0 – Production
CORE??? 10.2.0.1.0????? Production
TNS for Linux: Version 10.2.0.1.0 – Production
NLSRTL Version 10.2.0.1.0 – Production
SQL> select tablespace_name,file_name,bytes/1024/1024 from dba_data_files;
TABLESPACE_NAME??????????????? FILE_NAME????????????????????????????????????????? BYTES/1024/1024
—————————— ————————————————– —————
SYSTEM???????????????????????? /home/db/Oracle/oradata/mbs/MBS/datafile/o1_mf_sys???????????? 410
?????????????????????????????? tem_80bnvf2j_.dbf
UNDOTBS1?????????????????????? /home/db/Oracle/oradata/mbs/MBS/datafile/o1_mf_und???????????? 305
?????????????????????????????? otbs1_80bnvm5g_.dbf
SYSAUX???????????????????????? /home/db/Oracle/oradata/mbs/MBS/datafile/o1_mf_sys???????????? 130
?????????????????????????????? aux_80bnvnr8_.dbf
SQL> create user scott identified by tiger;
User created.
SQL> grant dba to scott;
Grant succeeded.
2. 檢查9i環境，確認需要傳輸的表空間是自包含的
SQL> select * from v$version;
BANNER
—————————————————————-
Oracle9i Enterprise Edition Release 9.2.0.4.0 – Production
PL/SQL Release 9.2.0.4.0 – Production
CORE??? 9.2.0.3.0?????? Production
TNS for Linux: Version 9.2.0.4.0 – Production
NLSRTL Version 9.2.0.4.0 – Production
SQL> select tablespace_name,file_name,bytes/1024/1024 from dba_data_files;
TABLESPACE_NAME??????????????? FILE_NAME????????????????????????????????????????? BYTES/1024/1024
—————————— ————————————————– —————
SYSTEM???????????????????????? /home/db/Oracle/oradata/mbs/system01.dbf?????????????????????? 325
UNDOTBS1?????????????????????? /home/db/Oracle/oradata/mbs/undotbs01.dbf????????????????????? 200
USERS????????????????????????? /home/db/Oracle/oradata/mbs/users01.dbf??????????????????????? 100
SQL> select owner,table_name,tablespace_name from dba_tables where table_name=’TEST’;
OWNER????????????????????????? TABLE_NAME???????????????????? TABLESPACE_NAME
—————————— —————————— ——————————
SYS??????????????????????????? TEST?????????????????????????? USERS
SCOTT????????????????????????? TEST?????????????????????????? USERS
SQL> EXECUTE SYS.DBMS_TTS.TRANSPORT_SET_CHECK(‘users’,TRUE,TRUE);
PL/SQL procedure successfully completed.
SQL> SELECT * FROM SYS.TRANSPORT_SET_VIOLATIONS;
VIOLATIONS
————————————————————————————————————————————
Sys owned object? TEST in tablespace USERS not allowed in pluggable set
提示在users表空間中存在sys用戶的表test，這不能包含在需要傳輸的表空間中。
將其刪除：
SQL> drop table sys.test;
Table dropped.
SQL> EXECUTE SYS.DBMS_TTS.TRANSPORT_SET_CHECK(‘users’,TRUE,TRUE);
PL/SQL procedure successfully completed.
SQL> SELECT * FROM SYS.TRANSPORT_SET_VIOLATIONS;
no rows selected
沒有返回，代表在表空間users與其他表空間不存在依賴關系
3.導出表空間中的元數據
–首先將表空間users設為read only
SQL> alter tablespace users read only;
Tablespace altered.
–導出表空間users中表的元數據
[Oracle@rhel ~]$ exp ‘/ as sysdba’ TRANSPORT_TABLESPACE=y TABLESPACES=(users) TTS_FULL_CHECK=y
Export: Release 9.2.0.4.0 – Production on Wed Jul 18 02:15:28 2012
Copyright (c) 1982, 2002, Oracle Corporation.? All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 – Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 – Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)
Note: table data (rows) will not be exported
About to export transportable tablespace metadata…
For tablespace USERS …
. exporting cluster definitions
. exporting table definitions
. . exporting table?????????????????????????? TEST
. exporting referential integrity constraints
. exporting triggers
. end transportable tablespace metadata export
Export terminated successfully without warnings.
4. 導出數據庫中其它對象，以full=y rows=n方式導出
[Oracle@rhel ~]$ exp SYSTEM/oracle FULL=y FILE=full.dmp ROWS=n statistics=none
Export: Release 9.2.0.4.0 – Production on Wed Jul 18 02:16:22 2012
Copyright (c) 1982, 2002, Oracle Corporation.? All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 – Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 – Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)
Note: table data (rows) will not be exported
About to export the entire database …
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM’s tables via Conventional Path …
. . exporting table??????????? AQ$_INTERNET_AGENTS
. . exporting table?????? AQ$_INTERNET_AGENT_PRIVS
. . exporting table??????????????????? DEF$_AQCALL
. . exporting table?????????????????? DEF$_AQERROR
. . exporting table????????????????? DEF$_CALLDEST
. . exporting table?????????????? DEF$_DEFAULTDEST
. . exporting table?????????????? DEF$_DESTINATION
. . exporting table???????????????????? DEF$_ERROR
. . exporting table?????????????????????? DEF$_LOB
. . exporting table??????????????????? DEF$_ORIGIN
. . exporting table??????????????? DEF$_PROPAGATOR
. . exporting table?????? DEF$_PUSHED_TRANSACTIONS
. . exporting table????????????????? DEF$_TEMP$LOB
. . exporting table?????? LOGSTDBY$APPLY_MILESTONE
. . exporting table??????? LOGSTDBY$APPLY_PROGRESS
. . exporting table??????????????? LOGSTDBY$EVENTS
. . exporting table??????????? LOGSTDBY$PARAMETERS
. . exporting table???????????????? LOGSTDBY$PLSQL
. . exporting table?????????????????? LOGSTDBY$SCN
. . exporting table????????????????? LOGSTDBY$SKIP
. . exporting table????? LOGSTDBY$SKIP_TRANSACTION
. . exporting table??????? REPCAT$_AUDIT_ATTRIBUTE
. . exporting table?????????? REPCAT$_AUDIT_COLUMN
. . exporting table?????????? REPCAT$_COLUMN_GROUP
. . exporting table?????????????? REPCAT$_CONFLICT
. . exporting table??????????????????? REPCAT$_DDL
. . exporting table???????????? REPCAT$_EXCEPTIONS
. . exporting table????????????? REPCAT$_EXTENSION
. . exporting table??????????????? REPCAT$_FLAVORS
. . exporting table???????? REPCAT$_FLAVOR_OBJECTS
. . exporting table????????????? REPCAT$_GENERATED
. . exporting table???????? REPCAT$_GROUPED_COLUMN
. . exporting table????? REPCAT$_INSTANTIATION_DDL
. . exporting table??????????? REPCAT$_KEY_COLUMNS
. . exporting table?????????? REPCAT$_OBJECT_PARMS
. . exporting table?????????? REPCAT$_OBJECT_TYPES
. . exporting table?????? REPCAT$_PARAMETER_COLUMN
. . exporting table?????????????? REPCAT$_PRIORITY
. . exporting table???????? REPCAT$_PRIORITY_GROUP
. . exporting table????? REPCAT$_REFRESH_TEMPLATES
. . exporting table???????????????? REPCAT$_REPCAT
. . exporting table????????????? REPCAT$_REPCATLOG
. . exporting table????????????? REPCAT$_REPCOLUMN
. . exporting table???????? REPCAT$_REPGROUP_PRIVS
. . exporting table????????????? REPCAT$_REPOBJECT
. . exporting table??????????????? REPCAT$_REPPROP
. . exporting table????????????? REPCAT$_REPSCHEMA
. . exporting table???????????? REPCAT$_RESOLUTION
. . exporting table????? REPCAT$_RESOLUTION_METHOD
. . exporting table? REPCAT$_RESOLUTION_STATISTICS
. . exporting table??? REPCAT$_RESOL_STATS_CONTROL
. . exporting table????????? REPCAT$_RUNTIME_PARMS
. . exporting table????????????? REPCAT$_SITES_NEW
. . exporting table?????????? REPCAT$_SITE_OBJECTS
. . exporting table????????????? REPCAT$_SNAPGROUP
. . exporting table?????? REPCAT$_TEMPLATE_OBJECTS
. . exporting table???????? REPCAT$_TEMPLATE_PARMS
. . exporting table???? REPCAT$_TEMPLATE_REFGROUPS
. . exporting table???????? REPCAT$_TEMPLATE_SITES
. . exporting table??????? REPCAT$_TEMPLATE_STATUS
. . exporting table?????? REPCAT$_TEMPLATE_TARGETS
. . exporting table???????? REPCAT$_TEMPLATE_TYPES
. . exporting table??? REPCAT$_USER_AUTHORIZATIONS
. . exporting table?????? REPCAT$_USER_PARM_VALUES
. . exporting table??????? SQLPLUS_PRODUCT_PROFILE
. about to export OUTLN’s tables via Conventional Path …
. . exporting table??????????????????????????? OL$
. . exporting table?????????????????????? OL$HINTS
. . exporting table?????????????????????? OL$NODES
. about to export DBSNMP’s tables via Conventional Path …
. about to export SCOTT’s tables via Conventional Path …
. . exporting table?????????????????????????? TEST
. exporting synonyms
. exporting views
. exporting referential integrity constraints
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting triggers
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting user history table
. exporting default and system auditing options
. exporting statistics
Export terminated successfully without warnings.
5.將表空間及數據庫其它對象導入
[Oracle@rhel ~]$imp ‘/ as sysdba’ TRANSPORT_TABLESPACE=y FILE=expdat.dmp DATAFILES=(‘/home/db/oracle/oradata/mbs/users01.dbf’)
[Oracle@rhel ~]$ imp ‘/ as sysdba’ FILE=full.dmp ignore=y full=y
Import: Release 10.2.0.1.0 – Production on Wed Jul 18 02:23:19 2012
Copyright (c) 1982, 2005, Oracle.? All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V09.02.00 via conventional path
Warning: the objects were exported by SYSTEM, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses ZHS16GBK character set (possible charset conversion)
. importing SYSTEM’s objects into SYSTEM
IMP-00017: following statement failed with Oracle error 1119:
“CREATE TEMPORARY TABLESPACE “TEMPTS1″ BLOCKSIZE 8192 TEMPFILE? ‘/home/db/or”
“acle/oradata/mbs/temp01.dbf’ SIZE 20971520?????? EXTENT MANAGEMENT LOCAL? U”
“NIFORM. SIZE 1048576”
IMP-00003: Oracle error 1119 encountered
ORA-01119: error in creating database file ‘/home/db/Oracle/oradata/mbs/temp01.dbf’
ORA-27038: created file already exists
Additional information: 1
IMP-00017: following statement failed with Oracle error 959:
“ALTER USER “SYS” IDENTIFIED BY VALUES ‘8A8F025737A9097A’ TEMPORARY TABLESPA”
“CE “TEMPTS1″”
IMP-00003: Oracle error 959 encountered
ORA-00959: tablespace ‘TEMPTS1’ does not exist
IMP-00017: following statement failed with Oracle error 959:
“ALTER USER “SYSTEM” IDENTIFIED BY VALUES ‘2D594E86F93B17A1’ TEMPORARY TABLE”
“SPACE “TEMPTS1″”
IMP-00003: Oracle error 959 encountered
ORA-00959: tablespace ‘TEMPTS1’ does not exist
IMP-00061: Warning: Object type “SYSTEM”.”REPCAT$_OBJECT_NULL_VECTOR” already exists with a different identifier
“CREATE TYPE “REPCAT$_OBJECT_NULL_VECTOR” TIMESTAMP ‘2012-07-18:01:24:33’ OI”
“D ‘C509B28C83DBA46FE040007F0100762C’????????? AS OBJECT”
“(“
”? — type owner, name, hashcode for the type represented by null_vector”
”? type_owner????? VARCHAR2(30),”
”? type_name?????? VARCHAR2(30),”
”? type_hashcode?? RAW(17),”
”? — null_vector for a particular object instance”
”? — ROBJ REVISIT: should only contain the null image, and not version#”
”? null_vector???? RAW(2000)”
“)”
. importing SYS’s objects into SYS
. importing SYSTEM’s objects into SYSTEM
. importing SYS’s objects into SYS
. importing SYSTEM’s objects into SYSTEM
. importing OUTLN’s objects into OUTLN
. importing DBSNMP’s objects into DBSNMP
. importing SCOTT’s objects into SCOTT
. importing SYSTEM’s objects into SYSTEM
. importing SYS’s objects into SYS
. importing SYSTEM’s objects into SYSTEM
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_AUDIT_ATTRIBUTE” ADD CONSTRAINT “REPCAT$_AUDIT_ATTRIBU”
“TE_C1″ CHECK ((data_type_id in (2, 4, 5, 6, 7) and”
”????????????????? data_length is not null)”
”????????????? or (data_type_id not in (2, 4, 5, 6, 7) and”
”????????????????? data_length is null)”
”???????????????? ) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_CONFLICT” ADD CONSTRAINT “REPCAT$_CONFLICT_C1” CHECK (“
“conflict_type_id in (1, 2, 3)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_EXTENSION” ADD CONSTRAINT “REPCAT$_EXTENSION_CODE” CHE”
“CK (extension_code IN (0)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_EXTENSION” ADD CONSTRAINT “REPCAT$_EXTENSION_EXPORTREQ”
“” CHECK (export_required IN (‘Y’, ‘N’)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_EXTENSION” ADD CONSTRAINT “REPCAT$_EXTENSION_STATUS” C”
“HECK (extension_status IN (0, 1, 2, 3, 4)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_EXTENSION” ADD CONSTRAINT “REPCAT$_EXTENSION_PUSH_TO_M”
“DEF” CHECK (push_to_mdef IN (‘Y’, ‘N’)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_EXTENSION” ADD CONSTRAINT “REPCAT$_EXTENSION_PUSH_TO_N”
“EW” CHECK (push_to_new IN (‘Y’, ‘N’)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_FLAVORS” ADD CONSTRAINT “REPCAT$_FLAVORS_C2″ CHECK (pu”
“blished is NULL or (published in (‘Y’,’N’,’O’))) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_FLAVOR_OBJECTS” ADD CONSTRAINT “REPCAT$_FLAVOR_OBJECTS”
“_VERSION” CHECK (version# >= 0 AND version#
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_GENERATED” ADD CONSTRAINT “REPCAT$_GENERATED_OBJ” CHEC”
“K (reason IN (0, 1, 2, 3, 4, 5, 6, 7, 9, 10)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_PRIORITY_GROUP” ADD CONSTRAINT “REPCAT$_PRIORITY_GROUP”
“_C1″ CHECK (data_type_id in (1, 2, 3, 4, 5, 6, 7)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_PRIORITY_GROUP” ADD CONSTRAINT “REPCAT$_PRIORITY_GROUP”
“_C2″ CHECK ((data_type_id in (4, 7) and”
”????????????????? fixed_data_length is not null)”
”????????????? or (data_type_id in (1, 2, 3, 5, 6) and”
”????????????????? fixed_data_length is null)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_REFRESH_TEMPLATES” ADD CONSTRAINT “REFRESH_TEMPLATES_C”
“1” CHECK ((public_template in (‘Y’,’N’))”
”?? or public_template is NULL) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_REPCAT” ADD CONSTRAINT “REPCAT$_REPCAT_STATUS” CHECK (“
“status IN (0, 1, 2)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_REPCATLOG” ADD CONSTRAINT “REPCAT$_REPCATLOG_REQUEST” “
“CHECK (request IN (-1, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10,”
”?????????????????????????????????????? 11, 12, 13, 14, 15, 16, 17,”
”?????????????????????????????????????? 18, 19, 20, 21, 22, 23, 24, 25)) ENA”
“BLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_REPCATLOG” ADD CONSTRAINT “REPCAT$_REPCATLOG_TYPE” CHE”
“CK (type IN (-1, 0, 1, 2, 4, 5, 7, 8, 9, 11, 12, -3,”
”??????????????????????????????????? 13, 14, 32, 33)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_REPCATLOG” ADD CONSTRAINT “REPCAT$_REPCATLOG_STATUS” C”
“HECK (status IN (0, 1, 2, 3, 4)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_REPCOLUMN” ADD CONSTRAINT “REPCAT$_REPCOLUMN_VERSION” “
“CHECK (version# >= 0 AND version#
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_REPOBJECT” ADD CONSTRAINT “REPCAT$_REPOBJECT_TYPE” CHE”
“CK (type IN (-1, 1, 2, 4, 5, 7, 8, 9, 11, 12, -3,”
”????????????????????????????????????? -4, 13, 14, 32, 33)) ENABLE NOVALIDAT”
“E”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_REPOBJECT” ADD CONSTRAINT “REPCAT$_REPOBJECT_VERSION” “
“CHECK (version# >= 0 AND version#
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_REPOBJECT” ADD CONSTRAINT “REPCAT$_REPOBJECT_STATUS” C”
“HECK (status IN (0, 1, 2, 3, 4, 5, 6)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_REPOBJECT” ADD CONSTRAINT “REPCAT$_REPOBJECT_GENPACKAG”
“E” CHECK (genpackage IN (0, 1, 2)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_REPOBJECT” ADD CONSTRAINT “REPCAT$_REPOBJECT_GENTRIGGE”
“R” CHECK (gentrigger IN (0, 1, 2)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_REPPROP” ADD CONSTRAINT “REPCAT$_REPPROP_HOW” CHECK (h”
“ow IN (0, 1, 2, 3)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_SITES_NEW” ADD CONSTRAINT “REPCAT$_SITES_NEW_FULL_INST”
“” CHECK (full_instantiation IN (‘Y’, ‘N’)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_TEMPLATE_OBJECTS” ADD CONSTRAINT “REPCAT$_TEMPLATE_OBJ”
“ECTS_VER” CHECK (object_version# >= 0 AND object_version#
“OVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_TEMPLATE_PARMS” ADD CONSTRAINT “REPCAT$_TEMPLATE_PARMS”
“_C1″ CHECK (user_override in (‘Y’,’N’)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_TEMPLATE_SITES” ADD CONSTRAINT “REPCAT$_TEMPLATE_SITES”
“_C1″ CHECK (status in (-100,-1,0,1)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
“ALTER TABLE “REPCAT$_TEMPLATE_SITES” ADD CONSTRAINT “REPCAT$_TEMPLATE_SITES”
“_C2″ CHECK ((site_name is not null and repapi_site_id is null) or”
”?? (site_name is null and repapi_site_id is not null)) ENABLE NOVALIDATE”
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
. importing OUTLN’s objects into OUTLN
. importing SCOTT’s objects into SCOTT
. importing SYSTEM’s objects into SYSTEM
. importing SYS’s objects into SYS
. importing SYSTEM’s objects into SYSTEM
. importing SYS’s objects into SYS
. importing SYSTEM’s objects into SYSTEM
. importing SYS’s objects into SYS
. importing SYSTEM’s objects into SYSTEM
. importing SYS’s objects into SYS
. importing SYSTEM’s objects into SYSTEM
. importing SYS’s objects into SYS
. importing SYSTEM’s objects into SYSTEM
. importing SYS’s objects into SYS
. importing SYSTEM’s objects into SYSTEM
. importing SYS’s objects into SYS
. importing SYSTEM’s objects into SYSTEM
. importing OUTLN’s objects into OUTLN
. importing SYSTEM’s objects into SYSTEM
. importing OUTLN’s objects into OUTLN
. importing SYSTEM’s objects into SYSTEM
. importing OUTLN’s objects into OUTLN
. importing SYSTEM’s objects into SYSTEM
. importing SYS’s objects into SYS
. importing SYSTEM’s objects into SYSTEM
About to enable constraints…
Import terminated successfully with warnings.
6.編譯失效對象
SQL> @?/rdbms/admin/utlrp.sql
SQL> select owner,object_name,object_type,status from dba_objects where status ‘VALID’;
no rows selected
7.確認數據已經被導入到10g
SQL> select tablespace_name,file_name,bytes/1024/1024 from dba_data_files;
TABLESPACE_NAME??????????????? FILE_NAME????????????????????????????????????????? BYTES/1024/1024
—————————— ————————————————– —————
SYSTEM???????????????????????? /home/db/Oracle/oradata/mbs/MBS/datafile/o1_mf_sys???????????? 410
?????????????????????????????? tem_80bnvf2j_.dbf
UNDOTBS1?????????????????????? /home/db/Oracle/oradata/mbs/MBS/datafile/o1_mf_und???????????? 305
?????????????????????????????? otbs1_80bnvm5g_.dbf
SYSAUX???????????????????????? /home/db/Oracle/oradata/mbs/MBS/datafile/o1_mf_sys???????????? 140
?????????????????????????????? aux_80bnvnr8_.dbf
USERS????????????????????????? /home/db/Oracle/oradata/mbs/users01.dbf??????????????????????? 100
SQL> select count(*) from scott.test;
? COUNT(*)
———-
????? 5786
