Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Import database in 8i from 9i
- Thread starter mrkamran
- Start date
SantaMufasa
Technical User
MrKamran,
Although you can easily and successfully export data from and earlier Oracle version to a later Oracle version (example: 8i -> 9i), moving data backward from 9i -> 8i takes a bit more care and planning.
You can move data from Oracle 9i to 8i by your using this technique:
1) Invoke the Oracle 8i "exp" utility to export data from the Oracle 9i database. One way to make this happen is to
a) Log into the machine with the Oracle 8i database,
b) Ensure that your %ORACLE_HOME% and %ORACLE_SID% system variables point to values for the Oracle 8i instance,
c) Invoke the Oracle "exp" utility, but assign the "exp" parameter "USERID=<username>/<password>@<Oracle9i source-instance TNS alias>"
(The resulting dump file will be Oracle 8i compatible, which your current dump file is not.)
2) Invoke the Oracle 8i "imp" utility as you normally would to import the Oracle 9i dump file.
Please advise of you results, or followup with questions if you have any.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
Although you can easily and successfully export data from and earlier Oracle version to a later Oracle version (example: 8i -> 9i), moving data backward from 9i -> 8i takes a bit more care and planning.
You can move data from Oracle 9i to 8i by your using this technique:
1) Invoke the Oracle 8i "exp" utility to export data from the Oracle 9i database. One way to make this happen is to
a) Log into the machine with the Oracle 8i database,
b) Ensure that your %ORACLE_HOME% and %ORACLE_SID% system variables point to values for the Oracle 8i instance,
c) Invoke the Oracle "exp" utility, but assign the "exp" parameter "USERID=<username>/<password>@<Oracle9i source-instance TNS alias>"
(The resulting dump file will be Oracle 8i compatible, which your current dump file is not.)
2) Invoke the Oracle 8i "imp" utility as you normally would to import the Oracle 9i dump file.
Please advise of you results, or followup with questions if you have any.
Mufasa(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
- Status
