it tries to put it in the same tablespace as what is in the import file, if
it cant (i.e not there, no permissions) then it will go into the default
tablespace of the user you are importing into.
Just make sure that user has a quota of 0 on users and doesnt have
unlimited tablespace privelege.
Some things like queue tables must go into the same tablespace or it fails
On 10/18/05, John Dunn <jdunn_at_sefas.com> wrote:
>
> When doing a user import, how does the import command what tablespace is
> used to store the imported database objects?.
>
> Is it determined by the contents of the export file or will it use the
> default tablespace for the user into which I am importing?
>
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 18 2005 - 05:04:36 CDT
