Re: import 8.1.7 dump file to 8.1.6 database
Date: 8 Jun 2001 06:22:43 -0700
Message-ID: <9f767483.0106080522.7452f1c9_at_posting.google.com>
man <cmkuok_at_c5solutions.com> wrote in message news:<3B209446.649E434F_at_c5solutions.com>...
> Hi,
>
> Is there any way to import a 8.1.7 export file to 8.1.6 database?
>
> Thanks in advance.
> Man
One of the simplest ways is to use 8.1.6 export utility to export 8.1.7 database and then use 8.1.6 import utility to import into 8.1.6 database. The following steps explain IMPORTING INTO 8.0.X database from 8.1.X export.
- Add an entry for the 8i(8.1.7 in yr case) database service in the tnsnames.ora file of the 8.0.x (8.1.6. in yr case) host.
- Check connectivity from 8.0.x (8.1.6) host to the 8i( 8.1.7) database using any database interface utility, such as sqlplus.
Example: sqlplus <8i database username>/<password>_at_<8i database service name>
3. Export the 8i database schemas into a file using 8.0.x (8.1.6) export utility, from the 8.0.x(8.1.6) database host machine.
Example: exp <8i database username>/<password>_at_<8i database service name> file=exp8i.dmp log=exp8i.log owner=<the user schema to copy from> ... and the other parameters of your interests.
4. Import the 8i (8.1.7) export dump file into the 8.0.x (8.1.6) database now.
Example: imp <8.0.x database username>/<password> file=exp8i.dmp log=imp80.log touser=<user schema to copy to>
With these simple steps, you will be successful with your export from 8i (8.1.7) into importing to 8.0.x.(8.1.6) Received on Fri Jun 08 2001 - 15:22:43 CEST