Home » SQL & PL/SQL » SQL & PL/SQL » Trigger problem
Trigger problem [message #358817] Wed, 12 November 2008 10:09 Go to next message
shrad2001
Messages: 20
Registered: September 2008
Location: faridabad
Junior Member
Hiiii

i want to take back up of my trigger name user_save
as we are taking backup of table usng command
create table s as select * from table1;
In same manner i want to take backup of trigger

it urgent

thanks
smily
Re: Trigger problem [message #358819 is a reply to message #358817] Wed, 12 November 2008 10:15 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
How urgent is this request ?

Regards

Raj
Re: Trigger problem [message #358823 is a reply to message #358817] Wed, 12 November 2008 10:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no same manner.
There are different manners.

Regards
Michel
Re: Trigger problem [message #358824 is a reply to message #358817] Wed, 12 November 2008 10:19 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Do you not have backups of the database?
Do you not have copies of your source code stored in some form of version control software?

Have a look at DBMS_METADATA.
Previous Topic: Different rows result between SELECT and UPDATE statments
Next Topic: stored package
Goto Forum:
  


Current Time: Sat Dec 10 20:26:13 CST 2016

Total time taken to generate the page: 0.11960 seconds