Path: utzoo!utgpu!watserv1!watmath!att!occrsh!uokmax!apple!portal!fernwood!oracle!news From: kbittner@oracle.uucp (Kurt Bittner) Newsgroups: comp.databases Subject: Re: table ownership under Oracle Message-ID: <1990Jul5.202154.7797@oracle.com> Date: 5 Jul 90 20:21:54 GMT References: <10426@hydra.gatech.EDU> Reply-To: kbittner@oracle.UUCP (Kurt Bittner) Organization: Oracle Corporation, Belmont, CA Lines: 17 In article dsimson@oracle.com (David Simson) writes: > >> Does anyone know of a quick way to change the ownership of an >> Oracle table in release 6.0.30? I had considered simply changing >> the appropriate fields in the sys.obj$ table, but I am not >> very comfortable with this since I don't know all the ramifications. > >I don't know all the ramifications either, but I'd never do it! I wouldn't do it either. If you don't want to do the export/import scenario, grant access to the table to the new user, CREATE tablename as select * from old_user.tablename, and then drop the old user's table. This is safer, and takes less time than export/import (unless you do the import during the upgrade). Kurt Bittner@oracle.com "The only way to re-can a can of worms is to use a larger can."