Re: REPOST: Importing user in an other tablespace

Hi,

1. Revoke the option of grant resource ...
2. Alter user .... quota unlimited to <NEW_TABLESPACE> default tablespace <NEW_TABLESPACE>

_at_+ Eddy Legrain

"Frank Demuynck" <frank.demuynck_at_entelec.be> a écrit dans le message de news: 5$--$%%%_$$$_$_$-$_at_news.noc.cabal.int...
> Hi,
>
> 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.veri o.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 Feb 07 2002 - 22:00:22 CET