Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: IMP P08 TO PO7
This is normal.
If you wish to import into a v7 database and your data is in a v8 db then use
v7 exp un/pw_at_SID8 pointing to your v8 database
followed by imp un/pw into your v7 database
I do have another alternative of course.
This would be to extract your data independent of any version of Oracle,
infact even independent of Oracle.
You could use a reasonably priced tool that we have to offer. Downloads into
8bit full NLS,compacted ASCII.
You can then load or pipe this into a version 7 or version 8 database with SQL
Loader.
I have recently downloaded and inserted 60MB in eight minutes.
The tool PDQOUT => Pretty Damn Quick OUT available for demo at
www.oriolecorp.com
Cheers
Peter Lomax - WWW.ORIOLECORP.COM
Alan C. Fusco, Ph.D. wrote:
> Is it possible to use an exp file from a PO8 database and import it into a
> PO7 database? Everytime I try, I get an invalid header error.
>
> Alan
Received on Thu Sep 24 1998 - 15:34:43 CDT