Re: Specifying tablespacename during import of schema

From: Chris Rodrigues <cr148_at_yahoo.com>
Date: 12 Sep 2001 16:41:30 -0700
Message-ID: <e1fa2ab9.0109121541.3261ea62_at_posting.google.com>


arunbhat01_at_yahoo.com (Arun) wrote in message news:<127e8357.0109120815.68c33b01_at_posting.google.com>...
> I export a schema and import it using the foll.commands:
>
> exp uname/pwd owner=o_name file=abc.dmp grants=yes constraints=yes
> indexes=yes triggers=yes log=steve.log rows=yes compress=no
>
> imp another_uname/pwd file=abc.dmp log=steve2.log fromuser=uname
> touser=another_uname
>
> ***
> Is it possible to specify the tablespace name to which i want to
> import this schema in the imp?
> Any other way of doing this?
>
> I'm using Oracle 8i
>
>
>
> -Thanx
> -arun

change the default tablespace of another_uname before you begin import. This will cause import to create the object in the defined tablespace. Received on Thu Sep 13 2001 - 01:41:30 CEST

Original text of this message