Table and Procedure scritps from SQL (merged) [message #376805] |
Thu, 18 December 2008 10:37  |
satishk
Messages: 26 Registered: October 2008 Location: HYD
|
Junior Member |
|
|
Hi,
I need to take backup of latest updated Database objects ( scripts/definitions for Tables, procedures, packages, triggers ........
Is there any short cut to get all the latest updated database objects ....
ex:
like in( 'obj1', 'obj2','obj3'....objects ) under Scema 'Test' ....
Thanks,
Pavan . K
|
|
|
|
|
|
|
|
|
|
Re: Table and Procedure scritps from SQL [message #377030 is a reply to message #376805] |
Fri, 19 December 2008 09:16   |
satishk
Messages: 26 Registered: October 2008 Location: HYD
|
Junior Member |
|
|
Hi All,
Thanks for your suggetions..but unfortunalty the command DBMS_METADATA.GET_DDL not working at" Oracle7 Server Release 7.3.4.4.1 - Production".
Can you please let me know ( its a very basic qustion) how can we get the one table script at a time at old above version ( what is the source..)
and let me know if any other suggetions...
Exp : we havn't privilage to do the same....
Thanks All,
Pavan K
|
|
|
|
|