Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Getting data out of Oracle 8i?!! Expand / Collapse
Posted Monday, August 25, 2008 4:17 PM

SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, December 2, 2016 12:19 PM
Points: 289, Visits: 898

I am working for a company that is going to a new application. The previous application was written by a software vendor that no longer supports the application. It was written in Oracle 8i.

The boss has said that he needs the data out of the old system to create reports for historical purposes.

I don't know Oracle. I have gotten on the internet enough to:

1) find out the sid
2) find the services
3) change the password file so that I can use internal as sysdba
4) select to find tables in SQL Plus.

However, I need data.

How can I see the tables and the data?
How can I get the data out and import into SQL Server 2005 Express or SQL Server 2000 enterprise?

Thanks in advance. This is crazy!

Post #558525
Posted Friday, September 12, 2008 6:45 AM

Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
First thing first... be very carefull!!! you are login into that database like "sa" in the SQL Server world.

Objects in Oracle have a composite name schema_name.object_name

Find out the schema_name that owns the tables you need to target then do...

select table_name
from dba_tables
where table_owner = 'schema_name';

That would gave you a list of the tables.

if tables are not very large you may want to create a query to write the data out as svc... plenty of examples on the net.

Good luck.

Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #568435
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse