Home » RDBMS Server » Server Administration » How to know constraints (oracle 9i , 10g)
How to know constraints [message #311971] Mon, 07 April 2008 10:32 Go to next message
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.
Re: How to know constraints [message #311974 is a reply to message #311971] Mon, 07 April 2008 10:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
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 Go to previous messageGo to next message
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
Re: How to know constraints [message #312254 is a reply to message #312245] Tue, 08 April 2008 05:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
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
Re: How to know constraints [message #312256 is a reply to message #312245] Tue, 08 April 2008 05:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
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
Re: How to know constraints [message #312272 is a reply to message #312254] Tue, 08 April 2008 06:19 Go to previous messageGo to next message
Haler
Messages: 71
Registered: October 2004
Member
with sys or other schema the result is the same.
Re: How to know constraints [message #312274 is a reply to message #312256] Tue, 08 April 2008 06:24 Go to previous messageGo to next message
Haler
Messages: 71
Registered: October 2004
Member
I agree with you but
I forgot to specify constraints for the script.
My apologies for this
Re: How to know constraints [message #312283 is a reply to message #312274] Tue, 08 April 2008 07:24 Go to previous message
Michel Cadot
Messages: 64132
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
Previous Topic: Adding a Datafile to an existing Index Tablspace on a Live Busy System
Next Topic: Create Database
Goto Forum:
  


Current Time: Wed Dec 07 16:26:56 CST 2016

Total time taken to generate the page: 0.10834 seconds