|DESY HOME||IT HOME||Print Preview||Print Window|
Export, Import are complementary utilities which allow you to write data in an ORACLE-binary format from the database into operating system files and to read data back from those operating system files. EXPORT, IMPORT are used for the following tasks:
Exporting of ORACLE database objects is controlled by parameters. To get familiar with EXPORT parameters type:
You will get a short description and the default settings will be shown.
The EXPORT utility may be used in three ways:
About to export specified tables ... . exporting table EMP 14 rows exported . exporting table DEPT 4 rows exported Export terminated successfully without warnings.\
Like EXPORT the IMPORT utility is controlled by parameters. To get familiar with these parameters type:
You will get a short description of usage and default settings of parameters.
To start IMPORT simply type imp. You will be prompted for your ORACLE userid, password. The next prompts depend on what you answer. In most cases you may answer the prompts by pressing the return key. But the following prompts you have to answer carefully.
Import file: expdat.dmp >If your data was exported to file expdat.dmp press return, otherwise enter the filename where the exported data resides.
Ignore create error due to object existence (yes/no): yes >This is a flag to indicate how object creation errors should be handeld. If you import into an existing table and you set IGNORE=Y, rows could be duplicated if they where already present in the table.
Import entire export file (yes/no): yes > no Username:If your exportfile consists of more objects than you want to import, enter no. In this case you will be prompted for the Username (this is normally your ORACLE account).
Enter table names. Null list means all tables for user Enter table name or . if done:After entering the username you will be prompted for table names until you press the return key without entering a table name. Than IMPORT will be started.
importing SCOTT's objects into SCOTT . importing table "DEPT" 4 rows imported . importing table "EMP" 14 rows imported Import terminated successfully without warnings.
|Imprint||© 2013||Last update: 17. Jul. firstname.lastname@example.org|