Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> help with export/backup please

help with export/backup please

From: Al <arainx_at_yahoo.com>
Date: 26 Jan 2002 17:39:49 -0800
Message-ID: <c275a676.0201261739.1c17991b@posting.google.com>


I need some advice on getting a database exported from an oracle server (8.16) on solaris and then be able to mine it on an NT machine where i have an
8.15 installed, or import it into mysql on linux maybe. The size is around 10gb with 100 tables and I dont have the schema available to me.

The 8.16 database on unix is backed up daily onto a tape using veritas backup, but i dont have either sun hardware or veritas to restore the backup which could be given to me. I will have access to the database for a day or two and thats when i need to get the data in such a format so I can use on my NT or Linux server.

First of all is this possible? What would i need to do once i have access to the database? What command should I use to get the data and the schema so I can recreate the db on NT/Linux? Do I need to check the quality of the data before I take it? How do i check if the data in the tables is corrupted or not in oracle? I dont want to end up with data i cant use.

Thank you Received on Sat Jan 26 2002 - 19:39:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US