Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Export Your Own Schema
How To Export Your Own Schema? - Oracle DBA FAQ - Loading and Exporting Data
✍: FYIcenter.com
If 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 \oraclexe\hr_dump >cd \oraclexe\app\oracle\product\10.2.0\server\BIN >sqlplus /nolog SQL> connect SYSTEM/fyicenter SQL> CREATE DIRECTORY hr_dump AS '\oraclexe\hr_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/fyicenter SCHEMAS=hr DIRECTORY=hr_dump DUMPFILE=schema.dmp LOGFILE=schema.log 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 ...... . . 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 ...... Master table "HR"."SYS_EXPORT_SCHEMA_01" loaded/unloaded ********************************************************* Dump file set for HR.SYS_EXPORT_SCHEMA_01 is: C:\ORACLEXE\HR_DUMP\SCHEMA.DMP Job "HR"."SYS_EXPORT_SCHEMA_01" successfully completed
2007-05-01, 4936👍, 0💬
Popular Posts:
How To Merge Cells in a Column? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells If you ...
How To Merge Cells in a Row? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells If you wan...
How do we enable SQL Cache Dependency in ASP.NET 2.0? Below are the broader steps to enable a SQL Ca...
How do you handle change request? Normally change request are handled by preparing an Impact analysi...
How can a servlet refresh automatically if some new data has entered the database? You can use a cli...