In this post it is shown if we specify schemas=sys option while data pump export then what it actually does. Of course no tables, indexes, constraint, procedures, packages, triggers are exported. Only role grant are exported.
SQL> host expdp userid=\"/ as sysdba\" dumpfile=sys_test_dump.dmp schemas=sys
Export: Release 11.1.0.6.0 - Production on Saturday, 11 July, 2009 18:17:04
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_SCHEMA_01": userid="/******** AS SYSDBA" dumpfile=sys_test_dump.dmp schemas=sys
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
D:\APP\ARJU\ADMIN\ARJU\DPDUMP\SYS_TEST_DUMP.DMP
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 18:17:23
Let's see the contents inside dumpfile.
SQL> host impdp userid=\"/ as sysdba\" dumpfile=sys_test_dump.dmp sqlfile=inside_dump.txt
Import: Release 11.1.0.6.0 - Production on Saturday, 11 July, 2009 18:18:29
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_SQL_FILE_FULL_01": userid="/******** AS SYSDBA" dumpfile=sys_test_dump.dmp sqlfile=inside_dump.txt
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Job "SYS"."SYS_SQL_FILE_FULL_01" successfully completed at 18:18:33
The contents inside_dump.txt is as follows.
-- CONNECT SYSRelated Documents
ALTER SESSION SET EDITION = "ORA$BASE";
-- new object type path: SCHEMA_EXPORT/ROLE_GRANT
-- CONNECT SYSTEM
ALTER SESSION SET EDITION = "ORA$BASE";
GRANT "CONNECT" TO "SYS" WITH ADMIN OPTION;
GRANT "DBA" TO "SYS" WITH ADMIN OPTION;
GRANT "SELECT_CATALOG_ROLE" TO "SYS" WITH ADMIN OPTION;
GRANT "EXECUTE_CATALOG_ROLE" TO "SYS" WITH ADMIN OPTION;
GRANT "DELETE_CATALOG_ROLE" TO "SYS" WITH ADMIN OPTION;
GRANT "EXP_FULL_DATABASE" TO "SYS" WITH ADMIN OPTION;
GRANT "IMP_FULL_DATABASE" TO "SYS" WITH ADMIN OPTION;
GRANT "LOGSTDBY_ADMINISTRATOR" TO "SYS" WITH ADMIN OPTION;
GRANT "AQ_ADMINISTRATOR_ROLE" TO "SYS" WITH ADMIN OPTION;
GRANT "AQ_USER_ROLE" TO "SYS" WITH ADMIN OPTION;
GRANT "DATAPUMP_EXP_FULL_DATABASE" TO "SYS" WITH ADMIN OPTION;
GRANT "DATAPUMP_IMP_FULL_DATABASE" TO "SYS" WITH ADMIN OPTION;
GRANT "GATHER_SYSTEM_STATISTICS" TO "SYS" WITH ADMIN OPTION;
GRANT "RECOVERY_CATALOG_OWNER" TO "SYS" WITH ADMIN OPTION;
GRANT "SCHEDULER_ADMIN" TO "SYS" WITH ADMIN OPTION;
GRANT "HS_ADMIN_ROLE" TO "SYS" WITH ADMIN OPTION;
GRANT "OEM_ADVISOR" TO "SYS" WITH ADMIN OPTION;
GRANT "OEM_MONITOR" TO "SYS" WITH ADMIN OPTION;
GRANT "JAVAUSERPRIV" TO "SYS" WITH ADMIN OPTION;
GRANT "JAVAIDPRIV" TO "SYS" WITH ADMIN OPTION;
GRANT "JAVASYSPRIV" TO "SYS" WITH ADMIN OPTION;
GRANT "JAVADEBUGPRIV" TO "SYS" WITH ADMIN OPTION;
GRANT "EJBCLIENT" TO "SYS" WITH ADMIN OPTION;
GRANT "JMXSERVER" TO "SYS" WITH ADMIN OPTION;
GRANT "JAVA_ADMIN" TO "SYS" WITH ADMIN OPTION;
GRANT "JAVA_DEPLOY" TO "SYS" WITH ADMIN OPTION;
GRANT "CTXAPP" TO "SYS" WITH ADMIN OPTION;
GRANT "XDBADMIN" TO "SYS" WITH ADMIN OPTION;
GRANT "XDB_SET_INVOKER" TO "SYS" WITH ADMIN OPTION;
GRANT "AUTHENTICATEDUSER" TO "SYS" WITH ADMIN OPTION;
GRANT "XDB_WEBSERVICES" TO "SYS" WITH ADMIN OPTION;
GRANT "XDB_WEBSERVICES_WITH_PUBLIC" TO "SYS" WITH ADMIN OPTION;
GRANT "XDB_WEBSERVICES_OVER_HTTP" TO "SYS" WITH ADMIN OPTION;
GRANT "ORDADMIN" TO "SYS" WITH ADMIN OPTION;
GRANT "OLAPI_TRACE_USER" TO "SYS" WITH ADMIN OPTION;
GRANT "OLAP_XS_ADMIN" TO "SYS" WITH ADMIN OPTION;
GRANT "OLAP_DBA" TO "SYS" WITH ADMIN OPTION;
GRANT "CWM_USER" TO "SYS" WITH ADMIN OPTION;
GRANT "OLAP_USER" TO "SYS" WITH ADMIN OPTION;
GRANT "SPATIAL_WFS_ADMIN" TO "SYS" WITH ADMIN OPTION;
GRANT "WFS_USR_ROLE" TO "SYS" WITH ADMIN OPTION;
GRANT "SPATIAL_CSW_ADMIN" TO "SYS" WITH ADMIN OPTION;
GRANT "CSW_USR_ROLE" TO "SYS" WITH ADMIN OPTION;
GRANT "WKUSER" TO "SYS" WITH ADMIN OPTION;
GRANT "MGMT_USER" TO "SYS" WITH ADMIN OPTION;
GRANT "OWB$CLIENT" TO "SYS" WITH ADMIN OPTION;
GRANT "OWB_DESIGNCENTER_VIEW" TO "SYS" WITH ADMIN OPTION;
GRANT "OWB_USER" TO "SYS" WITH ADMIN OPTION;
No comments:
Post a Comment