Re: adding to source coutrol

It's certainly possible to retrieve all the data from the database (except the PL/SQL source code which has been "wrapped", of course). But there is no magical command which will give everything to you at once. Here are some pointers to get you started:

• For stored procedures/functions source code: "select text from all_source order by owner, name, line".
• For triggers source code: "select trigger_body from all_triggers".
• For views definition: "select text from all_views".
• For tables, indices and many other object types, use the new supplied procedure DBMS_METADATA.GET_DDL to get the statements which would re-create them. Use all_objects if you only need to see what they are.

Daniel

> I am in the process of moving all my stored procedures, views, table
> scripts etc into source control. Is there any way where I could generate
> the scripts for all the objects from the Oracle database. I am using
> Oracle 9i. Any help would be highly appreciated. Thanks in advance.
>
> Hari
Received on Wed Jul 16 2003 - 22:35:39 CEST