Hi,
on 11.2.03 on AIX
I have :
SQL> SELECT owner,tablespace_name
FROM dba_tables
WHERE table_name='AUD$';
OWNER TABLESPACE_NAME
------------------------------ ------------------------------
SYSTEM SYSAUX
How can I change owner and tablespace to have :
SQL> SELECT owner,tablespace_name
FROM dba_tables
WHERE table_name='AUD$';
OWNER TABLESPACE_NAME
------------------------------ ------------------------------
SYS SYSTEM
For tablespace :
alter table ... move tablespace
but for owner , what should be done ?
Thank you.