Re: Export/Import

Yaroslav Perventsev wrote:
> AFAIK...
> import use default user tablespace(if tablespace from which exported doesn't
> exist) .

Sorry, import uses the tablespace that the table was originally in when the export was done.

But you can force the tables to be in a certain tablespace by first creating all the empty tables in the wanted tablespace. On import, the table-create will fail, but that can be ignored. After that the data will be loaded into the table.

        Erwin

> Zeyad S <sweidanz_at_yahoo.com> ñîîáùèë â íîâîñòÿõ
> ñëåäóþùåå:3B5D2A27.9DAF7B1C_at_yahoo.com...
> > Does anyone know how to change the tablespace when you import a
> > table(s)? I have looked at the manuals and nothing is mentioned in this
> > matter. When exporting a table, Oracle specifies the tablespace name in
> > the create table statement. When importing the table, I would like to
> > change that tablespace or leave it to the default of the user importing
> > that table.
Received on Tue Jul 24 2001 - 03:38:13 CDT