Re: Change objects ownership ? Can I do it ?
Date: 1995/11/04
Message-ID: <47gu0m$s77_at_ddi2.digital.net>#1/1
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