Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: I need your help PLEASE

Re: I need your help PLEASE

From: dave_n <daven_20191NOdaSPAM_at_yahoo.com.invalid>
Date: Wed, 08 Dec 1999 10:22:35 -0800
Message-ID: <06bf275e.2a42e9b6@usw-ex0109-070.remarq.com>


You should be able to run an export from the mac(preferably as the super user for this sytem), then import to the NT. The first step is that you need to create the database on nt to include the services. You will then need to set up sql*net tnsnames.ora and listener.ora. After connectivity is established, you need to log in to sqlplus as system/manager and create a user that like the one who did the export from the mac. After the user is created, run the orant\dbs\pupbld.sql script to set up the product user profile for that user. After that script runs, grant dba to the user you created. Then you can run the import. Please be aware of the rb0 and rb1 roolback segements. i suggest that you set the initial and next extents to 100k with unlimited number of extents. By importing, you will create all of the objects that weere exported. Good luck. Dave N.

Received on Wed Dec 08 1999 - 12:22:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US