Solved

Move Oracle 9 Oradata to Oracle 10 XE

Posted on 2008-10-22
6
694 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
ID: 22780691

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
ID: 22814119
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
ID: 22814772
Mike,
After my last comment I realized that it will not be possible. Thanks anyway.
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 22824802

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
case statement in where clause 5 48
How do I get sql developer to give me valuable exception information? 2 50
exp/imp 25 74
Field name with special character (Ñ) in Oracle 11 50
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

777 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