By mistake a user was assigned default tablespace SYSTEM.
How we can change it to some new tablespace let's say "TBS1" ?
Because if we do export and import it will again import into that "SYSTEM"
tablespace.
Thanks,
- Harsh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Auth
Harsh Agrawal wrote:
>
> By mistake a user was assigned default tablespace SYSTEM.
> How we can change it to some new tablespace let's say "TBS1" ?
> Because if we do export and import it will again import into that "SYSTEM"
> tablespace.
alter user bob default tablespace tbs1;
then grant a quo
look at alter user command, yes break out the documentation and begin
reading.
joe
>From: Harsh Agrawal <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Moving user to a different tablespace ...
What version of Oracle? With 8i + you have the ability to mover a table to
a different tablespace.
Terry
Harsh Agrawal wrote:
> By mistake a user was assigned default tablespace SYSTEM.
> How we can change it to some new tablespace let's say "TBS1" ?
> Because if we do export and import it wil
ONE approach would be.
- export owner=username
- drop the user, AFTER making sure you have available DDL to re-create them.
- re-create the user with the correct info.
- import using fromuser touser and ignore=y
of course if the user owns no objects, just user alter user...
-Original Mess
r command, yes break out the documentation and begin
reading.
joe
>From: Harsh Agrawal <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Moving user to a different tablespace ...
>Date: Fri, 23 Mar