Path: utzoo!attcan!uunet!cs.utexas.edu!uwm.edu!ogicse!emory!mephisto!prism!scott From: scott@prism.gatech.EDU (Scott Holt) Newsgroups: comp.databases Subject: Re: table ownership under Oracle Message-ID: <10446@hydra.gatech.EDU> Date: 13 Jun 90 19:04:47 GMT References: <10426@hydra.gatech.EDU> Organization: Georgia Institute of Technology Lines: 23 In article dsimson@oracle.com (David Simson) writes: > > >Since you're doing a v5 to v6 upgrade you'll be exporting each user. >Instead of doing a full database export that preserves user names, >export and import each user individually. That way, when you import >the tables they'll be owned by the new OPS$ user. > We had considered this a last resort - the particular database in question is used for instructional support. Each student (we have 12,000+) is granted an account in the database. Of course, only a few ever do database course work or pursue independent study with databases, but there are still 200-300 users with tables in the database. The above method can get tedious, but I'm sure it too could be automated to some degree. - Scott -- This is my signature. There are many like it, but this one is mine. Scott Holt, Systems Analyst Internet: scott@prism.gatech.edu Georgia Tech BITNET: CCUSESH@GITNVE2 Office of Computing Services 404-894-6168