Rabu, 05 Desember 2012

Oracle Linux

Cara export & import database oracle linux dg memakai exp/imp command
* export with exp
[root@oracle ~]#exp username/password TABLES=test FILE=test.dmp
atau
[root@oracle ~]#exp username/password@namalistener FULL=Y FILE=/derektoritujuan namadatabase.dmp

*import with imp
[root@oracle ~]#imp username/password FILE=test.dmp fromuser=username touser=username FILE=/derektoritujuan namadatabase.dmp
atau
[root@oracle ~]#imp username/password@namalistener FULL=Y FILE=/derektoritujuan namadatabase.dmp