REPOST: Importing user in an other tablespace

I want to move a user who is created in the tablespace users to an other tablespace on an other server.

I created several users on the first server with the following script

BREAK ON &getuser;

CREATE USER &&getuser

   IDENTIFIED BY entelec
   DEFAULT TABLESPACE USERS
   TEMPORARY TABLESPACE TEMP
   PROFILE DEFAULT; GRANT CONNECT TO &&getuser;

GRANT RESOURCE TO &&getuser;

In those users we created our tables, sequences, ...

We installed oracle on a new server. There I created seperated tablespaces (I want for each user a different tablespace). I placed also the tablespace "users" ofline.

I did an export from a user of the first sever.

I created the same user on the new server (DEFAULT TABLESPACE ts_entelec) with the folowing script

BREAK ON &getuser;

CREATE USER &&getuser

   IDENTIFIED BY entelec
   DEFAULT TABLESPACE ts_enelec
   TEMPORARY TABLESPACE TEMP
   PROFILE DEFAULT; GRANT CONNECT TO &&getuser;

GRANT RESOURCE TO &&getuser;

The import on the new server failed. I've got the following errors;

IMP-00003: Oracle message code num encountered Cause: Import encountered the referenced Oracle error. Action: Look up the Oracle message in the ORA message chapters of this manual, and take appropriate action.

ORA-01542 tablespace 'string' is offline, cannot allocate space in it Cause: An attempt was made to allocate space in an offline tablespace. Action: Bring the tablespace online or create the object in other tablespace.

IMP-00017: following statement failed with Oracle message num: str Cause: Import failed to execute the statement from the export file because of an Oracle error.
Action: Look up the accompanying Oracle message in the ORA message chapters of this manual and take appropriate action.

So the import want to create the table in the tablespace users who is offline
But I want that the import create the tables in the new tablespace

Frank Demuynck
frank.demuynck_at_entelelec.be
frank_at_entelec-control.com

• WAS CANCELLED BY =======: From: "Frank Demuynck" <frank.demuynck_at_entelec.be> Control: cancel <3c4feeae$0$33510$ba620e4c_at_news.skynet.be> Subject: cmsg cancel <3c4feeae$0$33510$ba620e4c_at_news.skynet.be> Date: Mon, 28 Jan 2002 00:16:56 GMT Message-ID: <cancel.3c4feeae$0$33510$ba620e4c_at_news.skynet.be> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.tools NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!news.fh-hannover.de!fu-berlin.de!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40719267

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Thu Jan 24 2002 - 12:17:15 CET