Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: exp sun & imp win
On 26 May 2003 17:10:36 -0700, depifster_at_yahoo.com (Jack Silvey)
wrote:
>Also, make sure your Oracle versions are the same - sometimes
>exporting from one version and importing to another is tricky. If you
>start getting errors along the lines of "table or view does not exist"
>when you import this is probably your problem. Export and import rely
>on data dictionary views and sometimes they change between versions.
This is just hogwash.
You should be capable to import any version import in to any *higher*
version database, while the other way around (importing into *lower*
version database, so 9i export in 8i database) invariably doesn't
work, and that has always been published.
"Table or view does not exist" errors have everything to do with not
running the appropiate catexp*.sql script, as instructed in the
manual.
And BTW: the exp version number is incremented with *every* new
release, to prevent importing the other way around not just
*'sometimes'*
Get your *facts* straight please, rather than spreading *myths* and
*confusion*
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Mon May 26 2003 - 23:39:43 CDT