Re: Import into other tablespace

Create the table in the target tablespace required before doing the import. Use IGNORE=Y, to skip over the error you will generate when it tries to create the table again in the old tablespace. The import will then go on to load data in your created table in the new tablespace.

hth
NeilC.

Stefan Misch wrote in message <81o9u8$10k$1_at_newsread.do.de.uu.net>...
>Hi Oracle-Experts !
>
>I want to import the data of a specific user from a full export DMP-file
>which was created using exp80 on an Oracle 8.0.4. NT-Server into another
>tablespace. This user's data is in USER_DATA on the source NT-Server.
>
>I created an extra tablespace on another Oracle8 NT server (target server).
>I created the user with the new tablespace as the default tablespace. The
>user has DBA authority. So after granting DBA to the user, I also granted
>unlimited tablespace on the new tablespace to the user and gave him a quota
>of 0 on USER_DATA. Then I run the import.
>
>But this seems not to work.
>Any idea how I can import the data into another tablespace ?
>
>TIA,
>Stefan
>
>
>
Received on Mon Nov 29 1999 - 07:49:01 CST