Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: views/sequences
Mark D Powell tried to tell us something, and all I got was:
> "Michael L. Hostbaek" <carlos_at_pez.dk> wrote in message news:<slrnb9o2eg.1sk5.carlos_at_freebsdcluster.dk>...
>
> Select from the Oracle dictionary views on both databases and look to
> see if your objects are there. You should be able to use the same
> link you used to copy the data to query the all_ versions of the
> dictionary views.
Hmm... So all other sequences/triggers/views should be in: select * from user_objects; ?
Can I insert that into my new oracle server, with an equivelant of create table <table> as select * from <table>@link ? I know I cannot re-create USER_OBJECTS - but perhaps insert into <table> as select..... ??
Thanks.
/mich
-- Regards, Michael L. Hostbaek -= So long, and thanks for all the fish.. =-Received on Wed Apr 16 2003 - 06:29:24 CDT
![]() |
![]() |