REPOST: export/import data integrity question

I need to get 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

• WAS CANCELLED BY =======: From: arainx_at_yahoo.com (Al) Control: cancel <c275a676.0201251505.55e0619e_at_posting.google.com> Subject: cmsg cancel <c275a676.0201251505.55e0619e_at_posting.google.com> Date: Mon, 28 Jan 2002 02:30:44 GMT Message-ID: <cancel.c275a676.0201251505.55e0619e_at_posting.google.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!news.fh-hannover.de!unlisys!news.snafu.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40721535

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 17:05:32 CST