Monitoring and Tuning for Specific Platforms › Oracle › Database Defragmentation › Steps for an Export/Import-Oracle UNIX

Steps for an Export/Import-Oracle UNIX

Follow these steps:

1. Run the export facility:

   setenv ORACLE_SID DBCSE
   exp <userid> <password>
   

2. Export the user tables with the defaults. An SID of DBCSE is a default substitute for the ENCY database name. Dropping the user tables from the CSE will smooth the import process. To drop the user tables, change to the directory where CSE Oracle SQL is installed ($IEFCSGEN/../cse_oracle) and create the file composed of only DROP statements.

   grep “DROP TABLE” dbcse.ora > drop.dbcse
   

3. Using sqlplus, run drop.dbcse.
4. If you installed PIVIEWS, drop these. To drop the PIVIEWS defined in the database, change to the directory where CSE Oracle SQL installed ($IEFCSGEN/../cse_oracle) and create the drop.view file:

   find "CREATE OR REPLACE VIEW" piviews.sql > drop.views
   

   Using a text editor, edit the drop.views file as follows:

   1. Replace CREATE OR REPLACE VIEW with DROP VIEW.
   2. Append a semicolon (;) to the end of every line that starts with DROP.
   3. Save the file and exit from the editor.
5. Using sqlplus, run drop.view.
6. If your database is fairly large, add a 100 MB file to the temporary tablespace:

   sqlplus /nolog
   connect sys as sysdba
   alter table iefency_temp add datafile
   '/usr/iefcse/dbs/dbcsetemp.dat'
   size 100M ;
   

7. Run the import facility:

   imp <userid> <password>