August 25, 2008 at 4:17 pm
Hello,
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!
Things will work out. Get back up, change some parameters and recode.
September 12, 2008 at 6:45 am
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.Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply