Re: Full Database import

You can override this by precreating the tablespaces in a different path and then using the DESTROY parameter (I forget offhand if it should be set to Y or N -- but it is in the manual). Otherwise, yes if you create a "barebones" database and then do a full database import it will recreate the tablespaces in the same location. If you want to get around this, consider using symbolic links or logical names for the pathnames of the datafiles -- then you can redefine the link and the datafile will be created in the new location without having to manually move it.

Rachel

Robert Prendin wrote:

> Yes it re-creates the tablespaces except system, and yes it uses the
> same path. I recommend you do a full export and have a look at the
> file..
>
> Regards, Robert Prendin
> "Ian" <Ian.Lewis_at_synectics-solutions.com> wrote:
>
> >Does a full database import, create the tablespaces itself - and if so does
> >it create them in the same path as the export?
> >
> >Thanks
> >
> >Ian
Received on Fri Feb 20 1998 - 00:00:00 CST