Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 700
  • Last Modified:

Move Oracle 9 Oradata to Oracle 10 XE

I uninstalled oracle 9 and installed Oracle 10g Express Edition. Now I want to use an old database(schema?)  from 9 version in the XE database. I have the old Oradata folder with the  CTL,DBF,RED**. How can I use them on the Oracle XE? Thanks
0
novreis
Asked:
novreis
  • 2
  • 2
1 Solution
 
MikeOM_DBACommented:

You can't.
You would have needed to export the data (schema) from 9i and imported into 10g.

Otherwise you have to re-install 9i software and re-start the 9i database and do the export/import.
0
 
novreisAuthor Commented:
Hi Mike,
I have the Schema ( DDL ) generated by Toad  ( without data ) so I can generate on Oracle 10G the database structure. The problem now is if with the old folder Oradata I can have the Data visible on the 10G Database.
Thanks
0
 
novreisAuthor Commented:
Mike,
After my last comment I realized that it will not be possible. Thanks anyway.
0
 
MikeOM_DBACommented:

No problem, good luck!
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now