Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export/Import
Hello!
AFAIK...
import use default user tablespace(if tablespace from which exported doesn't
exist) .
Import/export in one database? If different, have another database same tablepace?
Yaroslav.
Zeyad S <sweidanz_at_yahoo.com> ñîîáùèë â íîâîñòÿõ
ñëåäóþùåå:3B5D2A27.9DAF7B1C_at_yahoo.com...
> Hi all,
> 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.
>
> Any hint will be appreciated.
>
> Thanks,
> ZS
>
Received on Tue Jul 24 2001 - 03:29:35 CDT
![]() |
![]() |