Introduction to importing oracle 9i backup files to oracle 8i

Incorrect practice:

To port the data in the oracle 9i database to a lower version of oracle 8i, first use the exp command to export the command line in oracle 9i ):

Exp username/password @ Global SID file = export database file name owner = user

Copy the exported database file name to the oracle 9i computer and use the imp command in oracle 8i to import the command line ):

Imp username/password @ Global SID file = owner of the database file to be imported = user ignore = y full = y

However, you will find that the Import fails.

Cause:The database backup file *. dmp of a later version cannot be directly imported into a later version of the database. However, for earlier versions, you can import only adjacent versions of later versions, such as 7i, 8i, and 9i ).

Solution:

Use the oracle 8i client to connect to the oracle 9i server, use the exp command to export data on the 8i server, and then use the imp command to import data.

Specific implementation:

In 8i, Net Configuration Assistant> Local Network Service name Configuration> Add> oracle 8i or later database> enter the global SID of 9i> TCP> host name, port number> test connection.

If the test is successful, the connection is connected and a name is given for the connection.

Start the command line of the computer where 8i is located and enter the BIN directory:

Imp username/password @ connection name file = owner of the database file to be imported = user ignore = y full = y

Now our task is complete.

1. Troubleshooting of common Oracle Database Problems
2. Can Oracle continue to lead the database market?
3. Analysis of Oracle listener installation and configuration
4. Popularity of Sybase SQL Server logs