Xref: alice comp.databases.oracle.server:26508 Path: alice!news-feed.fnsi.net!news.idt.net!woodstock.news.demon.net!demon!news.demon.nl!demon!sybrandb.demon.nl!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: Exporting / Importing Database Users Date: Sat, 08 Aug 1998 12:00:32 +0200 Message-ID: <35CC21BF.7070F24A@sybrandb.demon.nl> References: <6qdchh$9n3$1@flint.sentex.net> <6qetae$okf$1@nnrp1.dejanews.com> X-Trace: news.demon.nl 902570539 rover:12951 NO-IDENT sybrandb.demon.nl:212.238.21.78 X-Complaints-To: abuse@demon.net X-Mailer: Mozilla 4.05 [en] (Win95; I) MIME-Version: 1.0 To: jtesta@my-dejanews.com CC: "Dennis R. Leon" Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 65 Having done it myself several times, it is relatively simple as long as you avoid a few pitfalls: 1 Make a full database export of the old database 2 Create the new database 3 Create a second rollback segment in the SYSTEM tablespace. (Why that's not included in the default install I don' know. I assume no one is using a one tablespace database. I allways forget to do it initially) 4 Create all tablespaces in the new database. Tablespace name shouldn't change, filenames of datafiles MUST change. If you don't have a script that will generate a create tablespace script for you, look on the support notes cd, or reply to this e-mail and I will send one to you. Don't have it with me currently. 5 perform a full database import with ignore=y and log=. Ignore is necessary as they are create tablespace statements in the import, and the tablespaces are already. Hth Sybrand Bakker (postbus@sybrandb.demon.nl) jtesta@my-dejanews.com wrote: > You just want to export the users, how about using sql to build sql instead. > > like this: > select 'create user '||username|| > ' identified by values '||''''||password||''''|| > ' default tablespace '||default_tablespace|| > ' temporary tablespace '|| temporary_tablespace||';' from > sys.dba_users; > > This does NOT do grants, quotas, etc, but its a starting point for you to > build on. > > you do a spool on BEFORE running this and a spool off AFTER. > > then all u have to do is @spoolfilename > > hth, joe > http://www.oracle-dba.com > > In article <6qdchh$9n3$1@flint.sentex.net>, > "Dennis R. Leon" wrote: > > I'm trying to export all the users from one database and then importing them > > to a brand new database. > > > > Everything I tried failed!!! > > > > Does anybody know how this can be done? (I'm new at this!) > > > > Your help would be greatly appreciated. > > > > ~~~~~~~~~~~~~~~~~~~ > > Dennis R. Leon > > dleon@rim.net > > > > Research In Motion Ltd. > > http://www.rim.net/ > > > > > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum