Re: Oracle on Netware Help!!!

In article <34C7793D.88A6A783_at_ultranet.com>, Rob Feehan <rfeehan_at_ultranet.com> wrote:
>I am a DBA with 10+ years of VMS and Ingres experience but no practical
>Oracle experience or training. I was handed an Oracle database running
>on Netware 4.1 with no docs to speak of.

Get the docs. (You may have them on installation media, if you aren't installing from floppies). You'll have a hard time without the concepts manual and server administration and reference manuals, not to mention the SQL manual.

>
>I need to get up to speed on the Oracle Workgroup Server but all the
>books I bought so far (Oracle The Complete Reference, Oracle A Beginners
>Guide, and Oracle DBA Handbook) make no mention of how to do things on a
>Netware server. I have enough netware experience so that is not a
>problem.

The whole idea of Oracle is to be platform independent. Where you create a file with VMS directory syntax, just use Netware syntax instead.

>
>What I specifically want to learn is how to create a new database and
>copy the existing database into it so I can have a backup and training
>database.

One generally creates a bunch of *.SQL command files with the creation commands in them. Look around on the system. There are scripts floating about for creating these from an existing database (see if you have any support CD's from oracle, check linkages from user groups - among others, see http://ourworld.compuserve.com/homepages/joel_garry/oracleln.htm TUSC and Revealnet in particular), or there are ways to hack it. Default db installations often cannot work.

Learn to use the export/import utilities from oracle. Probably what you want to do is create an empty database (or more likely, a new user), export the existing database (or more likely, a particular schema in the database), and import into the new database (or more likely, schemata in the same database). This "database" terminology thing boils down to, what ingres calls a database, Oracle calls a schema. Oracle database is a much more global concept. I suspect you want to create schemata, not databases.

>
>If you can help I would appreciate either direct help or book names so I
>can get going on this. Thanks in advance.

Oracle 7 Administration by Ault has a pretty good "cookbook" approach, even though he never mentions Netware. He does show VMS and unix, so it might feel relatively comfortable for you. SAMS Oracle DBA Survival Guide is pretty good, too.

Oracle DBA questions are best asked in comp.databases.oracle.server.

>
>Rob
>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry_at_eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the _at_#%*& DBA!