Re: Very new to Oracle

On Tue, 28 Dec 1999 07:35:10 -0500, "John Chiu" <johnymc_at_netscape.net> wrote:

>Setting up new database in machine B from machine A:
>For machine A:
> alter database backup control file to trace
> edit the trace file and put in all necessary information about the
>database name, directory of the database files etc.
> full database export. This is the database creation script for machine B
> copy the export binary file and the edited trace file to machine B.
>For Machine B:
> run the database creation script.
> full database import with ignore=y.

Always when importing a full database, remember to check the import log (log outpt to a file and then examinate it).

I have always had the problem that execute permissions to dbms_alert for users never survived a full export/import, while everything else did.

/Bent

>HTH
>
>John Chiu
>
>
><pfhncp0_at_my-deja.com> wrote in message news:848lv3$nrk$1_at_nnrp1.deja.com...
>> I'm fairly new to oracle and I need to learn how to move a database
>> from one unix machine (HP-UX) to another unix machine (HP-UX). Where do
>> I start on looking for information on how to do this? Is it an easy
>> task or a difficult one? Thanks in advance.
>>
>> Neil
>>
>>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.
>
Received on Tue Dec 28 1999 - 14:03:22 CST