TIPS IT Consulting
Note: TIPS IT Consulting acquired TIPS BF Consulting on Jan. 6, 2011
Variables CSDB - is the database schema
testDB -- is the
database oracle user id that owns the database tables
Tasks: Export/Import all database tables owned by testDB
Export/Import database table(s) named transfer2.saved_links
Login in as Oracle
--- Source the environment setting
Enter -- export ORACLE_SID=CSDB
transfer_exp.par (save the file below as transfer_exp.par -- Note export/import all database table owned by testDB)
userid=system/testSystem
file=transfer_6.0.dmp
owner=testDB
statistics=none
log=transfer.log
transferB_exp.par (save file below as transferB_exp.par Note - export/import database table named transfer2.saved_links)
userid=system/testSystem
file=transferB_6.0.dmp
Tables=transfer2.saved_links
log=transfer.log
Enter -- exp parfile=transfer_exp.par
Enter -- exp parfile=transferB_exp.par
Move the dump files to the destination server and import the files.
At the destination server, the testDB and testDB2 accounts should be dropped/created
Drop and Create Oracle accounts
su - oracle
. csdb
sqlplus system
enter the password when prompted
at the sql prompt type the following sql commands
drop user testDB cascade;
create user testDB identified by testDB default tablespace testDBmeta temporary
tablespace temp quota unlimited on testDBmeta
grant create session, resource, dba to testDB
quit;
drop user testDB2 cascade;
create user testDB2 identified by testDB2 default tablespace testDB2
temporary tablespace temp quota unlimited on testDB2
grant connect, dba to testDB2
quit;
-- source the environment setting
export ORACLE_SID=CSDB
transfer_imp.par (save file below as transfer_imp.par)
userid=system/testSystem
file=transfer_6.0.dmp
Full=y
log=testDB_imp.log
transferB_imp.par (save file below as transferB_imp.par)
userid=system/testSystem
file=transferB_6.0.dmp
Fromuser=testDB2
Touser=testDB2
log=testDB2_imp.log
Type -- imp parfile=transfer_imp.par
Inspect the log for errors
Type -- imp parfile=transferB_imp.par
Insepect the log for errors