Changing tablespace of an user

From: Martin Renner <M.Renner_at_tiscon.de>
Date: Thu, 20 May 1999 10:24:59 GMT
Message-ID: <7i0ntq$lhj$1@nnrp1.deja.com>

Hello.

I created an Oracle-user and assigned him to a wrong standard- and temporary-tablespace. Unfortunately, this user already created some tables (about 15) and filled them with some MB of data.

Is there an easy way to assign this user to a different (and correct) tablespace without losing his data? Do I have to make an export of this data, change the tablespace and then import everything in the new table???

Thanks in advance,
Martin

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Thu May 20 1999 - 05:24:59 CDT