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

Home -> Community -> Usenet -> c.d.o.misc -> moving 8i (again)

moving 8i (again)

From: Michael L. Hostbaek <carlos_at_pez.dk>
Date: 25 Apr 2003 10:24:29 GMT
Message-ID: <slrnbai36s.1sk5.carlos@freebsdcluster.dk>


I have moved all data and such from one 8i server, to another (using db link). It worked like a charm ;)

I still have to copy all triggers/views/sequnces from the old server to the new one - Is it possible to do so with db link as well ? If yes, how ?

I have found all the data in user_objects, but I am not sure how to copy the info to the newserver.

Would something like this be possible:

on the new server:
insert into user_objects values as select * from user_objects_at_old_server where object_type = "VIEW" ???

Or maybe,

create trigger [name] as select * from user_objects_at_old_server where object_type="TRIGGER"

Any advise, pointer would be greatly appriciated..

I have looked on tahiti.oracle.com, but I cannot seem to find any docs that can shed some light over these issues..

/mich

-- 
Regards,
Michael L. Hostbaek
-= So long, and thanks for all the fish.. =-
Received on Fri Apr 25 2003 - 05:24:29 CDT

Original text of this message

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