Import Data and store them in a # tablespace

From: M Bouloussa <mb_at_asterop.com>
Date: 22 Apr 2004 09:40:28 -0700
Message-ID: <ab03d38.0404220840.104427ab@posting.google.com>

Please, I need some help

Scenari

1)
Create tablespace MY_TABLESPACE_1
datafile 'MY_TABLESPACE_1.dbf'
size 1M autoextend
on next 1M maxsize unlimited
2)
create user SOMEUSER identified by SOMEPWD default tablespace MY_TABLESPACE_1
temporary tablespace temp
quota unlimited on MY_TABLESPACE_1
3)
grant connect to SOMEUSER

Then I connect as user SOMEUSER/SOMEPWD and I create some tables These tables are stored in the default tablespace (MY_TABLESPACE_1)

Now I have an oracle dump and I want to import all the data of this dump to my user SOMEUSER but not in the default tablespace (MY_TABLESPACE_1): I want to store these "new" data in the tablespace MY_TABLESPACE_2 How can I do that ?

Thank you for the help

MB Received on Thu Apr 22 2004 - 11:40:28 CDT