Hi everyone,

I have the problem of migrating an Oracle database to a remote machine and I came across the exp and imp utilities in Oracle and I think that it is the best solution for my problems.

I have a few general questions and I am hoping that someone who has had more experience with these tools can give me some pointers:

- I have Oracle 9i installed and I have created 3 databases. However, when I use the export utility it does not ask me which database instance I want to export. If I do a full export would it dump all the three databases in the export dump file?

- Similarly, when using the imp tool on a remote machine, will it create a new database instance automatically based on the schema of the exported database? Will I have to create an empty database forst and import the contents?

Thanks,

Sincerely,

Pankaj

Are you sure that you have created three database instances rather than three schemas? Oracle schemas are roughly comperable to SQL Server databases.

When you invoke the export utility, you specify the database instance to connect to (i.e. scott/tiger@instance). If you don't specify an instance, the default instance will be chosen.

The import utility will not create a new database instance. It will import the data into an existing database.

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC