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