Requires Free Membership to View
If you have a full export, then the only thing you
really need to do is to create a new, empty database
and the import should work. The full import of the
full export will create all users, roles, tablespaces,
and all of the user's objects. This assumes that you
are using the same directory structure for your new
database. If not, then you'll have to precreate your
tablespaces with the new directory structure. Running
import with SHOW=Y will get you the DDL statements to
create your tablespaces. This was first published in October 2003
Join the conversationComment
Share
Comments
Results
Contribute to the conversation