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 -> Re: views/sequences

Re: views/sequences

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


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

Original text of this message

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