Oracle: How to Export / Import Database Schema

1. EXPORT:
exp system@test owner=test123 file=d:\oracle\user.dmp log=d:\oracle\userdump.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:\oracle\user.dmp log=d:\oracle\user11.log
ignore=y rows=y indexes=y feedback=100;

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

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

*


nine − = 5

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>