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: tips on moving oracle to new machine

Re: tips on moving oracle to new machine

From: Dave Wotton <Dave.Wotton_at_dwotton.nospam.clara.co.uk>
Date: 2000/09/21
Message-ID: <mVmy5.1332$qT6.69228@nnrp4.clara.net>#1/1

Howard J. Rogers wrote in message <39c9dc65_at_news.iprimus.com.au <mailto:39c9dc65_at_news.iprimus.com.au>>...
>But what about triggers and procedures, Dave? That was my point. I love
>the indexfile script, but it doesn't do the entire job. That's why,
>whoever's advice he follows, some extra work is going to be involved...

I'll just repeat the relevant bit of my posting, which you quoted ...

>>Next run
>>
>> imp full=y indexes=no ignore=y ....
>>
>> to import the data into the pre-created tables, roles, triggers,grants
>> etc. but don't create the indexes.

Dave.

--
If you reply to this posting by email, remove the "nospam" from my email
address first.
Received on Thu Sep 21 2000 - 00:00:00 CDT

Original text of this message

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