Oracle: How to Export / Import Database Schema

1. EXPORT:
exp system@test owner=test123 file=d:oracleuser.dmp log=d:oracleuserdump.log
rows=y statistics=none feedback=100 indexes=y consistent=y compress=n;
(for individual tables=table1,table2,.....)

2. IMPORT:
imp system@test fromuser=test123 touser=test123 file=d:oracleuser.dmp log=d:oracleuser11.log
ignore=y rows=y indexes=y feedback=100;

Leave a Reply

Your email address will not be published. Required fields are marked *

CAPTCHA * Time limit is exhausted. Please reload the CAPTCHA.

This site uses Akismet to reduce spam. Learn how your comment data is processed.