Home » RDBMS Server » Server Administration » Checking DB and Objects Exist or Not in Oracle
Checking DB and Objects Exist or Not in Oracle [message #132119] Wed, 10 August 2005 20:37 Go to next message
mymot
Messages: 225
Registered: July 2005
Senior Member
HI,

Can it be possible for me to check whether given objects are already there or not if there is then drop and create

IF EXISTS TAB2 THEN
DROP TAB2 CASCADE CONSTRAINTS;

IF exits c1_seq THEN
drop sequence c1_seq;

drop all constraints on user tables; ???


Thanks

Report message to a moderator

Re: Checking DB and Objects Exist or Not in Oracle [message #132148 is a reply to message #132119] Thu, 11 August 2005 01:32 Go to previous message
edcas
Messages: 38
Registered: July 2005
Member
yes, u can do that by using the view all_objects to check against the existence of the objects

Report message to a moderator

Previous Topic: Housekeeping in listener.log
Next Topic: oracle replication
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 08:47:00 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.