Import Data and store them in a # tablespace

Giganews Newsgroups
Subject: Import Data and store them in a # tablespace
Posted by:  M Bouloussa (…@asterop.com)
Date: 22 Apr 2004

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

Replies