Solved

Move Oracle 9 Oradata to Oracle 10 XE

Posted on 2008-10-22
6
692 Views
Last Modified: 2013-12-18
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
Comment
Question by:novreis
  • 2
  • 2
6 Comments
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 125 total points
Comment Utility

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
 

Author Comment

by:novreis
Comment Utility
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
 

Author Comment

by:novreis
Comment Utility
Mike,
After my last comment I realized that it will not be possible. Thanks anyway.
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
Comment Utility

No problem, good luck!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now