Re: Export problem

Could be the export views are wrong: try rerunning CATEXP, connected internal, or as SYS (you ARE a DBA now, whether you like it or not).

Besides, Oracle 8 and 7.3 export views can co-exist, as they have different names.

On an Oracle8 instance, run CATEXP7, and you will be able to export, using exp73 as well.

"James A. Johnson" wrote:

> Make sure the table in question is not using Oracle 8 tables...
>
> Wayne McKinney wrote:
>
> > I'm a newbie to database operations because I'm a developer - not a DBA, but
> > I have a DBA type question.
> >
> > I'm trying to use the 'exp73' command line utility to export from an Oracle
> > 7.3.2 database running on a Sun Sparc clone. I start out the export by
> > typing 'exp73' on the command line and then fill in all of the parameters
> > that it requests. I tell it to export the entire database.
> >
> > It goes through the first few portions of the export then it gets a problem:
> > namely 'EXP-00008: ORACLE error 1003 encountered'; then 'ORA-01003: no
> > statement parsed'. These same two messages are shown for each table - even
> > though it does give me statistics on how many rows are exported for each
> > table.
> >
> > Then, at the end of the export, I get the messages:
> > EXP-00008: ORACLE error 904 encountered
> > ORA-00904: invalid column name
> > EXP-00000: Export terminated unsuccessfully.
> >
> > What am I doing wrong to get these messages? What statements aren't getting
> > parsed and how can I find out what the invalid column name is? I looked in
> > TOAD to find any invalid (meaning X'd out) views, procedures, or functions,
> > and there are none.
> >
> > Any help or guidance would be appreciated!
Received on Mon Dec 28 1998 - 12:03:28 CET