How To Export Your Own Schema?
Submitted by: AdministratorIf you have a non-system user account and you want to export all data objects in the schema associated with your account, you can use the "expdp" command with the SCHEMAS parameter. Running "expdp" command with a non-system user account requires a directory object granted to this user account. The following tutorial exercise shows you how to define a directory object and export a schema:
>mkdir oraclexehr_dump
>cd oraclexeapporacleproduct10.2.0serverBIN
>sqlplus /nolog
SQL> connect SYSTEM/globalguideline
SQL> CREATE DIRECTORY hr_dump AS 'oraclexehr_dump';
Directory created.
SQL> GRANT READ ON DIRECTORY hr_dump TO hr;
Grant succeeded.
SQL> GRANT WRITE ON DIRECTORY hr_dump TO hr;
Grant succeeded.
SQL> quit
>expdp hr/globalguideline SCHEMAS=hr
DIRECTORY=hr_dump DUMPFILE=schema.dmp LOGFILE=schema.log
Submitted by: Administrator
>mkdir oraclexehr_dump
>cd oraclexeapporacleproduct10.2.0serverBIN
>sqlplus /nolog
SQL> connect SYSTEM/globalguideline
SQL> CREATE DIRECTORY hr_dump AS 'oraclexehr_dump';
Directory created.
SQL> GRANT READ ON DIRECTORY hr_dump TO hr;
Grant succeeded.
SQL> GRANT WRITE ON DIRECTORY hr_dump TO hr;
Grant succeeded.
SQL> quit
>expdp hr/globalguideline SCHEMAS=hr
DIRECTORY=hr_dump DUMPFILE=schema.dmp LOGFILE=schema.log
Submitted by: Administrator
Starting "HR"."SYS_EXPORT_SCHEMA_01":
hr/******** SCHEMAS=hr DIRECTORY=hr_dump
DUMPFILE=schema.dmp
LOGFILE=schema.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 960 KB
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCH
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
<pre>......
. . exported "HR"."COUNTRIES" 6.085 KB 25 rows
. . exported "HR"."DEPARTMENTS" 6.632 KB 27 rows
. . exported "HR"."EMPLOYEES" 15.76 KB 107 rows
. . exported "HR"."EMPLOYEES_TEMP" 15.86 KB 107 rows
......</pre>
Master table "HR"."SYS_EXPORT_SCHEMA_01" loaded/unloaded
*********************************************************
Dump file set for HR.SYS_EXPORT_SCHEMA_01 is:
C:ORACLEXEHR_DUMPSCHEMA.DMP
Job "HR"."SYS_EXPORT_SCHEMA_01" successfully completed
Submitted by: Administrator
hr/******** SCHEMAS=hr DIRECTORY=hr_dump
DUMPFILE=schema.dmp
LOGFILE=schema.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 960 KB
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCH
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
<pre>......
. . exported "HR"."COUNTRIES" 6.085 KB 25 rows
. . exported "HR"."DEPARTMENTS" 6.632 KB 27 rows
. . exported "HR"."EMPLOYEES" 15.76 KB 107 rows
. . exported "HR"."EMPLOYEES_TEMP" 15.86 KB 107 rows
......</pre>
Master table "HR"."SYS_EXPORT_SCHEMA_01" loaded/unloaded
*********************************************************
Dump file set for HR.SYS_EXPORT_SCHEMA_01 is:
C:ORACLEXEHR_DUMPSCHEMA.DMP
Job "HR"."SYS_EXPORT_SCHEMA_01" successfully completed
Submitted by: Administrator
Read Online Oracle Database Job Interview Questions And Answers
Top Oracle Database Questions
☺ | How To Run SQL*Plus Commands in SQL Developer? |
☺ | How To Use "OUT" Parameter Properly? |
☺ | How To Shutdown Your 10g XE Server? |
☺ | What Is an Oracle User Account? |
☺ | How To Retrieve Data from an Explicit Cursor? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |