Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Export/Import

Export/Import

From: Zeyad S <sweidanz_at_yahoo.com>
Date: Tue, 24 Jul 2001 17:56:24 +1000
Message-ID: <3B5D2A27.9DAF7B1C@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 - 02:56:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US