Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Create database link from inside a stored procedure
Jeremy wrote:
>
I guess it depends on your release procedures. In my opinion, a production system should be built by running the various object creation scripts against the database. Letting the application add database objects will ruin your audit trail. What if you need to build an exact copy of the database for, say, testing purposes or DR? Because your database isn't adequately documented (ie. you don't have the scripts required to recreate it), you cannot build a new environment but merely copy the existing database. This may be acceptable to your business; I assume you're a Windows site? Received on Wed Mar 29 2006 - 06:34:48 CST
![]() |
![]() |