Thursday, February 14, 2013

How to create Database structure same as another Database using Export Dump


If you want to create a Database Skeleton (All tables (without Data), indexes and other objects) same as another database

Then You just need the full export dump (apx1213.dmp) of source database

Source database A: apx1213
Target Database B: apx1314


1)     Create database using Database Configuration Assistant (DBCA)
2)     And import dump (without data) using following command

imp ldbo@apx1314srv FILE=D:\apx1213.dmp ROWS=N FULL=Y CONSTRAINTS=Y GRANTS=Y INDEXES=Y STATISTICS=NONE

No comments:

Post a Comment

Followers