----- 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.



Oracle LazyDBA home page