Re: Change objects ownership ? Can I do it ?

Try creating your table as T_tablename in TEMPORARY tablespace. Then drop the original tables and recreate them as the new user in an appropriate tablespace.

CONNECT original_user/password

CREATE TABLE T_name
TABLESPACE TEMPORARY AS
SELECT * FROM THE original_table;

GRANT SELECT ON T_name to newuser;

DROP TABLE original_table;

CONNECT newuser/password;

CREATE TABLE orginal_table
TABLESPACE tablespace_name AS
SELECT * FROM original_user.T_name;

You might want to do an ANALYZE ... COMPUTE STATISTICS on the T_name table and then add a STORAGE(INITIAL ??? NEXT ??? PCTINCREASE 0) between the TABLESPACE tablespace_name AS and SELECT ...

CREATE TABLE ...
TABLESPACE ...
STORAGE ... AS
SELECT ... Received on Sat Nov 04 1995 - 00:00:00 CET