Basic Oracle Tutorial: objects under sys cannot be exported in expdp.
Basic Oracle Tutorial: objects under sys cannot be exported in expdp.
Objects in sys users cannot be exported.
SQL> select owner, segment_name, tablespace_name from dba_segments where tablespac
E_name = 'users ';
OWNER SEGMENT_NAME TABLESPACE_NAME
------------------------------------------------------------
SYS REPAIR_TABLE USERS
SYS TT USERS
TEST1 TT USERS
SYS T1 USERS
TEST T USERS
TEST TT USERS
You have selected 6 rows.
SQL>
C:> expdp 'sys/system @ test as sysdba 'DIRECTORY = temp_dir dumpfile = users. dmp tabl
Espaces = users
Export: Release 10.2.0.1.0-Production on Monday, 01 August 1, 2009 9:47:44
Copyright (c) 2003,200 5, Oracle. All rights reserved.
Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options
Start "SYS". "SYS_EXPORT_TABLESPACE_01": 'sys/******** @ test as sysdba 'DIRECTORY =
Temp_dir dumpfile = users. dmp tablespaces = users
Using the BLOCKS Method for estimation...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
The total Estimation Using the BLOCKS method: 192 KB
Processing object type TABLE_EXPORT/TABLE
.. Exported "TEST". "T" 4.921 KB 1 line
.. Exported "TEST". "TT" 5.242 KB 4 rows
.. Exported "TEST1". "TT" 5.242 KB 2 rows
The master table "SYS". "SYS_EXPORT_TABLESPACE_01" is successfully loaded/uninstalled"
**************************************** **************************************
The dump file set of SYS. SYS_EXPORT_TABLESPACE_01 is:
C: TEMPUSERS. DMP
The job "SYS". "SYS_EXPORT_TABLESPACE_01" was successfully completed at 09:48:09.
C:>
C:> expdp 'sys/system @ test as sysdba 'DIRECTORY = temp_dir dumpfile = sys. dmp schema
S = sys
Export: Release 10.2.0.1.0-Production on Monday, 01 August 1, 2009 9:52:59
Copyright (c) 2003,200 5, Oracle. All rights reserved.
Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options
Start "SYS". "SYS_EXPORT_SCHEMA_01": 'sys/******** @ test as sysdba 'DIRECTORY = temp
_ Dir dumpfile = sys. dmp schemas = sys
Using the BLOCKS Method for estimation...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using the BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/ROLE_GRANT
The master table "SYS". "SYS_EXPORT_SCHEMA_01" is successfully loaded/uninstalled"
**************************************** **************************************
The dump file set of SYS. SYS_EXPORT_SCHEMA_01 is:
C: TEMPSYS. DMP
The job "SYS". "SYS_EXPORT_SCHEMA_01" was successfully completed at 09:53:30.
C:>
,