OraFAQ Forum: Server Administration » How to know constraints

Home » RDBMS Server » Server Administration » How to know constraints (oracle 9i , 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to know constraints [message #311971]

Mon, 07 April 2008 10:32

Haler
Messages: 71
Registered: October 2004

Member

Hello.

How to script for display all dependants and dependances of a table up to the root and until the end?
Thanks for help.

Report message to a moderator

Re: How to know constraints [message #311974 is a reply to message #311971]

Mon, 07 April 2008 10:39

Michel Cadot
Messages: 68676
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

http://www.dba-village.com/village/dvp_scripts.ScriptDetails?ScriptIdA=1237
http://www.dba-village.com/village/dvp_scripts.ScriptDetails?ScriptIdA=1236

Regards
Michel

[Updated on: Mon, 07 April 2008 10:39]

Report message to a moderator

Re: How to know constraints [message #312245 is a reply to message #311974]

Tue, 08 April 2008 05:07

Haler
Messages: 71
Registered: October 2004

Member

Hello,
I entered owner=LILLE,name of table=CCOMPTES and type=TABLE
(with Define THEOWNER = &THEOWNER
Define THEOBJECT = &THEOBJECT
Define THETYPE = &THETYPE
)
and
the procedure makes me nothing (logging with sys).
What is the problem?

furthemore, I do not see constraints in the script.
What is my error?

here's the results
ancien 39 : where name = upper('&THEOWNER'))
nouveau 39 : where name = upper('LILLE'))
ancien 40 : and name = upper('&THEOBJECT')
nouveau 40 : and name = upper('CCOMPTES')
ancien 41 : and type# = decode(upper('&THETYPE'), 'NEXT OBJECT', 0,
nouveau 41 : and type# = decode(upper('TABLE'), 'NEXT OBJECT', 0,

aucune ligne s�lectionn�e

Report message to a moderator

Re: How to know constraints [message #312254 is a reply to message #312245]

Tue, 08 April 2008 05:18

Michel Cadot
Messages: 68676
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I don't know I don't have your schema.

In addition:
- Never ever use SYS but for maintenance purpose (startup, shutdown, backup, recover)
- SYS is special
- SYS is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS" and you'll see the immediate answer)
- SYS does not act like any other user
- When you use SYS Oracle deactivates some code path and activates others
- Whatever you do with SYS will neither validate nor invalidate the same thing with any other user.

NEVER EVER use SYS for anything that can be done by another user.
Use SYS ONLY for something that can't be done by someone else.

Regards
Michel

Report message to a moderator

Re: How to know constraints [message #312256 is a reply to message #312245]

Tue, 08 April 2008 05:20

Michel Cadot
Messages: 68676
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

furthemore, I do not see constraints in the script.

Constraints are not dependent object in Oracle terminology. They are table properties.

Regards
Michel

Report message to a moderator

Re: How to know constraints [message #312272 is a reply to message #312254]

Tue, 08 April 2008 06:19

Haler
Messages: 71
Registered: October 2004

Member

with sys or other schema the result is the same.

Report message to a moderator

Re: How to know constraints [message #312274 is a reply to message #312256]

Tue, 08 April 2008 06:24

Haler
Messages: 71
Registered: October 2004

Member

I agree with you but
I forgot to specify constraints for the script.
My apologies for this

Report message to a moderator

Re: How to know constraints [message #312283 is a reply to message #312274]

Tue, 08 April 2008 07:24

Michel Cadot
Messages: 68676
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If your request is for dependance in constraint way, you should search on this forum the question was already asked.

Regards
Michel

Report message to a moderator

Previous Topic:	Adding a Datafile to an existing Index Tablspace on a Live Busy System
Next Topic:	Create Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 09 18:52:12 CDT 2024