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 -> Re: Full Database import

Re: Full Database import

From: TurkBear <johng_at_mm.com>
Date: 1998/02/20
Message-ID: <34eda28e.162125113@news2.mm.com>#1/1

Import will use the tablespace of the exported table if the tablespace exists in the new location - if not, it will use the default tablespace of the user( the table owner ). If the user has quota restrictions on that tablespace and the table will not fit, the table is not imported. note: This is a method used to reorganize tables - before importing, change the user's default tablespace to a different one and the tables will be imported into that one ( provided the original one is gone or the user's priveleges to it are revoked).

Hope this helps,
John Greco
Oracle DBA
Email to john.greco_at_dot.state.mn.us

"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

Original text of this message

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