Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: moving 8i (again)
On 25 Apr 2003 10:24:29 GMT, "Michael L. Hostbaek" <carlos_at_pez.dk>
wrote:
>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
>
Basically you are using methods which should be considered screwing up the datadictionary. Evidently they are not endorsed and not supported.
Good Luck!!!
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Fri Apr 25 2003 - 12:47:20 CDT