Home » SQL & PL/SQL » SQL & PL/SQL » How to Copy drop table one schma to another schma
How to Copy drop table one schma to another schma [message #222538] Mon, 05 March 2007 05:46 Go to next message
srinivasoracle
Messages: 18
Registered: February 2007
Location: Hyderabad
Junior Member

Hi,

I have two schemas A and B.
In A schema, When I try to DROP table the automically has to copy in B schema.

How can I use the DDL_Triggers?

Thanks & Regards.
Srinivasulu Vakati
Re: How to Copy drop table one schma to another schma [message #222571 is a reply to message #222538] Mon, 05 March 2007 08:01 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
You need to be granted the ability to create objects on other schemas for this to happen.
Show us what you tried so far.
Previous Topic: If clause in cursors
Next Topic: replace function
Goto Forum:
  


Current Time: Mon Dec 05 15:00:39 CST 2016

Total time taken to generate the page: 0.07526 seconds