Re: Question on Full import

<sambavan_at_motown.cc.utexas.edu> wrote in message news:Pine.GSO.4.21.0007111416540.3145-100000_at_war.cc.utexas.edu...
>
> I have done a full export on one of my database instances on V7.3.2 and
> now would like to import it into the V8.1.6. I have the basic instance
> setted up and was wondering if I were to do a full import, would it go and
> create the tablespaces that were not already there on my new basic setup
> instance. In this case, do I have to run any extra imp/exp scripts to
> accomodate the V7 into V8. By the way the V7 is running on Dec Alpha and
> V8.1.6 is on Solaris.
>
> Could some one give me an idea/clue on this.
>
> Thanx,
> Sam
>
> -----------------------------------------------
>
> Experience is not what happens to a man, it's
> what a man does with what happens to him.
> -- ALDOUS HUXLEY
>
> ------------------------------------------------
>

It would try to create tablespaces and probably fail because you are running NT and the file syntax is different.
It would be wise to precreate those tablespaces You can easily extract them by running
imp ... show=y full=y log=fullimp.sql
and edit fullimp.sql for the create tablespace commands.

Hth,
Sybrand Bakker, Oracle DBA Received on Tue Jul 11 2000 - 00:00:00 CDT