Home » RDBMS Server » Server Administration » move tables including longs to another tablespace
move tables including longs to another tablespace [message #60587] Tue, 17 February 2004 23:51 Go to next message
F.
Messages: 6
Registered: February 2004
Junior Member
Hi,

we've problems changing the tablespace of recent tables wrongly imported into the systems tablespace. We want to transfer these tables in the user-ts. I tried alter table move... but this doesn't work for those tables including long-datatype columns.

Are there any other options to have this change done? Could this be done with an export/import-job.

system-configuration: ORA 8.1.5 on W2k

Any hint would be appreciated.

TIA,

F.

Report message to a moderator

Re: move tables including longs to another tablespace [message #60589 is a reply to message #60587] Wed, 18 February 2004 03:21 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
try export and import.
take the export.
drop the objects.
reset the default tablespace of the USER as USER_TS.
grant unlimited quota on tablespace USER_TS to user USER.
revoke RESOURCE privelege from USER if granted.
do the import

Report message to a moderator

Previous Topic: Parallel Query option
Next Topic: alter table table_name MOVE TABLESPACE tbs_name
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:50:46 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.