Change "Owner" of a table?
I've tried searching the forums...and I'm almost embarrassed by my seemingly stupid question, compared to the very complicated questions others are asking!
I'm new to Oracle/APEX/SQL etc! I'm working throught the PL/SQL 101 book by Christopher Allen (I'm really learning a lot...but...)
I need to get a table owned by SYS to be owned by TEST!
I can't find a forum entry to do this...but my best guest would be something like:
SQL> UPDATE DBA_TABLES
SET OWNER='TEST'
WHERE TABLE_NAME='PLSQL101_PRODUCT';
But to be honest with you, I'm not sure this is the correct place to do this....as I've found from other forum entries, I can also perform:
SELECT OWNER, TABLE_NAME from ALL_TABLES
WHERE OWNER='TEST';
OR
SELECT OWNER, TABLE_NAME from DBA_TABLES
WHERE OWNER='TEST';
I don't want to totally screw up my instance....by updating the wrong table!
Any help would be greatly appreciated!
KSL.
By the way, before I "Post Message", My real problem is, I'm getting ready to do an IMP of four .dmp files...I have know idea of the tablenames/users, etc of the four dump files...
I want to assign these imported tables/indexes...etc. to my "TEST" user, so that they show up in my APEX Object View, so I can readily see the tables! I'm assuming I use the "touser=TEST" parameter in my IMP command; but wanted to know how to change the owner, just in case that didn't do what I was expecting!?!