Home » SQL & PL/SQL » SQL & PL/SQL » Table and Procedure scritps from SQL (merged)
Table and Procedure scritps from SQL (merged) [message #376805] Thu, 18 December 2008 10:37 Go to next message
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 #376810 is a reply to message #376805] Thu, 18 December 2008 11:36 Go to previous messageGo to next message
knicely87
Messages: 25
Registered: December 2008
Location: Pittsburgh, PA
Junior Member
There is only one version of every object. So it's always the latest update.

[Updated on: Thu, 18 December 2008 11:36]

Report message to a moderator

Re: Table and Procedure scritps from SQL [message #376811 is a reply to message #376810] Thu, 18 December 2008 11:48 Go to previous messageGo to next message
satishk
Messages: 26
Registered: October 2008
Location: HYD
Junior Member
HI knicely,

Thanks for the reply..
My qustion is i want to get the scripts for all the objects.....

is there any scirpt/suggestin to get multiple objects scripts/code at a time.


Thanks,
pavan K
Re: Table and Procedure scritps from SQL [message #376813 is a reply to message #376811] Thu, 18 December 2008 12:06 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Look at DBMS_METADATA.GET_DDL
Re: Table and Procedure scritps from SQL [message #376853 is a reply to message #376805] Thu, 18 December 2008 22:17 Go to previous messageGo to next message
ttparavindh
Messages: 22
Registered: December 2006
Location: Bangalore,India
Junior Member

i trust below link will help you

http://www.orafaq.com/node/57

Regards.
Re: Table and Procedure scritps from SQL [message #376884 is a reply to message #376805] Fri, 19 December 2008 00:58 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
i hope exp will be useful to achieve your purpose
Re: Table and Procedure scritps from SQL [message #376894 is a reply to message #376884] Fri, 19 December 2008 01:09 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
dr.s.raghunathan wrote on Fri, 19 December 2008 07:58
i hope exp will be useful to achieve your purpose

Since the original request was for scripts, exp by itself is not sufficient.
Re: Table and Procedure scritps from SQL [message #376895 is a reply to message #376894] Fri, 19 December 2008 01:11 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
mmm.... sorry
Re: Table and Procedure scritps from SQL [message #377030 is a reply to message #376805] Fri, 19 December 2008 09:16 Go to previous messageGo to next message
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
How to get table script oracle 7.3.4.4.1 version [message #377031 is a reply to message #376805] Fri, 19 December 2008 09:18 Go to previous messageGo to next message
satishk
Messages: 26
Registered: October 2008
Location: HYD
Junior Member
Hi,

How can we get the table script for a Table from oracle old version se 7.3.4.4.1.

I need to get the same from SQL*plus only....


Thanks,
Satish
Re: How to get table script oracle 7.3.4.4.1 version [message #377034 is a reply to message #377031] Fri, 19 December 2008 09:31 Go to previous message
Frank Naude
Messages: 4590
Registered: April 1998
Senior Member
This may help - http://www.orafaq.com/scripts/sql/mktable.txt
Previous Topic: Pass partition name as parameter from procedure to the cusrsor in pl/sql
Next Topic: How oracle locks child table with foreign keys?
Goto Forum:
  


Current Time: Thu Feb 06 20:45:40 CST 2025