Re: Exporting error

Dave,

I assume you are on some type of UNIX platform. This may solve your problem.

1. go to ORACLE_HOME/rdbms/admin,
2. login as sys or connect internal,
3. Run the script titled (catexp.sql). This will take a few minutes and it will not distroy any existing objects.

Next, try your export.

If you any questions, email me at madhoun_at_gate.net

Alan Bozof <g596101_at_lg3vm.lasc.lockheed.com> wrote:

>This is a multi-part message in MIME format.
 

>---------------------------------17834956218967
>Content-Transfer-Encoding: 7bit
>Content-Type: text/plain; charset=us-ascii
 

>When I do an export from a 7.0.16 database it shows the tables that it is
>exporting and then the number of rows that were exported.
>It seems that you could at least determine which table is failing. Which
>would at least be a starting point.
 

>Just a suggestion there might be a better way.
 

>Scott Downey
>Lockheed-Martin
 

>---------------------------------17834956218967
>Content-Transfer-Encoding: 7bit
>Content-Type: Text/Plain
 

>I am trying to do a full export of an oracle 7.0 database.
>I get an error say invalid column name and the export stops.
>I have looked at the dmp file and the last thing that i can see is
>the users information. Is there anyway I can tell which column is
>making the export stop?
>thanx
>Dave Blocher
>dblocher_at_postoffice.ptd.net

>---------------------------------17834956218967--
Received on Fri Dec 22 1995 - 00:00:00 CET