Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> moving 8i (again)
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
![]() |
![]() |