--------------------------------------------------------------------------------------------------------------------------
-- Exports

-- Full 
setenv ORACLE_SID DBSTAR
exp system/pwd full=y rows=y file=/db01/app/oracle/admin/DBSTAR/exp/exportfulltrunc.dmp log=/db01/app/oracle/admin/DBSTAR/exp/exportfulltrunc.log

-- Full in windows:
set ORACLE_SID=DBSTAR
exp '/ as sysdba ' full=y file=f:\Oracle_Backup\export\full_exp_mig.dmp log=f:\Oracle_Backup\log\full_exp_mig.log compress=Y 


-- User
-- user level export csh script
#!/bin/csh
date
exp system/pwd@dbstar buffer=1000000 owner=admin consistent=y file=/backup/DBSTAR/expkeep/admin.dmp log=/db01/app/oracle/admin/DBSTAR/exp/expadmin.log constraints=n grants=n indexes=n rows=y
date

-- user level export in Windows for user dbadmin
set nls_lang=.AL32UTF8 
set ORACLE_SID=DBSTAR
exp '/ as sysdba ' owner=dbadmin file=f:\oracle_backup\keep\dbadmin_archive.dmp log=f:\oracle_backup\keep\dbadmin_archive.log 


-- Table



--------------------------------------------------------------------------------------------------------------------------
-- Imports

-- import table data
imp system/pwd@dbstar file=/db09/backup/DBSTAR/exp/ORCL_full.dmp  
log=/db01/app/oracle/admin/DBSTAR/imp/import_ORCL_full.log GRANTS=N IGNORE=Y INDEXES=N FROMUSER="(admin)" TABLES="(TABLE_A,TABLE_B)"

imp system/pwd@dbstar file=/db14/backup/DBSTAR/exp_compressed_DBSTAR.dmp000314 log/db01/app/oracle/admin/DBSTAR/imp/adminTables.log IGNORE=Y destroy=n fromuser=admin touser=admin tables="(address_ext)" indexes=n grants=n

-- Example in NT
set oracle_sid=DBSTAR
d:\orant\bin\exp73 system/pwd@dbstar owner=admin consistent=y file=d:\backup\ORCL\export\expadmin_dbstar.dmp log=d:\backup\DBSTAR\export\expadmin_dbstar.log 



-- What makes an import fast?