Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change "Owner" of a table?

leonhardtkApr 20 2009 — edited Apr 21 2009
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!?!
This post has been answered by SomeoneElse on Apr 20 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 19 2009
Added on Apr 20 2009
10 comments
12,853 views