----- Original Message -----
From: "Jordan, Judy (Judith M)" <judy.[Email address protected]
To: "John" <[Email address protected]
Sent: Monday, January 31, 2005 5:32 PM
Subject: RE: 10g export file problem
> odd, the documentation states you can do this, next option is to create an
> alias from the 9i system to the 10g system. Using a network connect from
> 9i, use the 9i exp utility. I have done this before, and it does work, on
> Windows platforms. You then can import into a 9i database, or also 10g.
>
> -----Original Message-----
> From: John [mailto:[Email address protected]
> Sent: Monday, January 31, 2005 9:24 AM
> To: Jordan, Judy (Judith M); [Email address protected]
> Subject: Re: 10g export file problem
>
>
>
> ----- Original Message -----
> From: "Jordan Judy (Judith M) " <judy.[Email address protected]
> To: <[Email address protected]
> Sent: Monday, January 31, 2005 3:39 PM
> Subject: RE: 10g export file problem
>
>
> > **A LazyDBA.com subscriber has responded to your lazydba.com post**
> > **LazyDBA.com mail shield has forwarded you this email,
> > **and removed any attachments, and kept your email address secret
> > **from this person, and any viruses/trojans.
> > **If you reply to this email, the person will see your email address as
> normal
> > **Anything below this line is the original email text
> >
> >
> > John, you can use the old exp utility in Oracle 10g to make a 10 export
> for
> > import into 9i.
> > look in your oracle_home\bin directory for the utilities. If you export
> > with 10g expdp, it can only be imported into a 10g database.
> >
> > -----Original Message-----
> > From: John
> > [mailto:oracledba-ezmlmshield-x65439409.[Email address protected]
> > Sent: Saturday, January 29, 2005 5:58 AM
> > To: LazyDBA Discussion
> > Subject: Re: 10g export file problem
> >
> >
> >
> > ----- Original Message -----
> > From: "??IO " <oracledba-ezmlmshield-x37374520.[Email address protected]
> > To: "LazyDBA Discussion" <[Email address protected]
> > Sent: Saturday, January 29, 2005 1:56 PM
> > Subject: Re: 10g export file problem
> >
> >
> > > you must use 9i imp/exp utlitily. you can from 9i database
> > > mathchinery use follow command.
> > > exp userid/[Email Address Removed] > >
> > >
> > >
> > > >Hello all
> > > >
> > > >I am currently facing an unexpected problem.
> > > >
> > > >I have two database servers (10g, 9ir2)
> > > >
> > > >I made a full export from a 10g and i tried to import (a schema only)
> to
> > the 9ir2
> > > >
> > > >Here are the errors
> > > >
> > > >
> > > >
> > > >
> > > >Import: Release 9.2.0.1.0 - Production on OU? Ea? 29 13:35:43
2005
> > > >
> > > >Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
> > > >
> > > >
> > > >Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 -
> Production
> > > >With the Partitioning and Oracle Data Mining options
> > > >JServer Release 9.2.0.1.0 - Production
> > > >
> > > >IMP-00010: not a valid export file, header failed verification
> > > >IMP-00000: Import terminated unsuccessfully
> > > >
> > > >
> > > >--------
> > > >website: http://www.LazyDBA.com
> > > >Please don't reply to RTFM questions
> > > >Oracle documentation is here: http://tahiti.oracle.com
> > > >To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> > > >To subscribe: see http://www.lazydba.com
> > > >By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > --------
> > > website: http://www.LazyDBA.com
> > > Please don't reply to RTFM questions
> > > Oracle documentation is here: http://tahiti.oracle.com
> > > To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> > > To subscribe: see http://www.lazydba.com
> > > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
> > >
> > >
> >
> >
> > The problem is that i want to export the 10g and import to the 9ir2
> >
> >
> >
>
> The export is being done using the exp utility (in the 10g Database
server)
>
> There is also the expdp within the $ORACLE_HOME/bin directory.
>
So, you mean that the oracle client 9i can be used to export from a 1g
server?
How can be done that?
Oracle LazyDBA home page