Re: recreate constraints script - URGENT

a script to generate constraints for a single table but I need a script to generate constraints for a schema owner . Can anyone send me a copy? Many thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking

recreate constraints script - URGENT

Dear all, I have a script to generate constraints for a single table but I need a script to generate constraints for a schema owner . Can anyone send me a copy? Many thanks, _ Free email with personality! Over 200 domains! http

RE: recreate constraints script - URGENT

personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, December 30, 2003 2:24 PM To: Multiple recipients of list ORACLE-L Dear all, I have a script to generate constraints for a single table but I need a script to generate constraints

Re: recreate constraints script - URGENT

dba_constraint will inform you of the tables that have constraints and what type of constraint they are. Further digging into the dba_ tables will provide the information you desire. Keep the scripts as part of the database documentation and update when needed. Third party software can provide

Re:Re: recreate constraints script - URGENT

Thanks Ron, I got this recreate constraints script from our list but lost it.It was really good script and it can re-generate all the constraints under a schema owner. -- Original Message Date: Tue, 30 Dec 2003 12:14:26 -0800 dba_constraint

Re:RE: recreate constraints script - URGENT

Thanks Rajendra, Good idea but I have 1200 tables :(I got a good script from our list long time ago but lost it.That script can capiture constraints for the schema owner. -- Original Message Date: Tue, 30 Dec 2003 11:39:26 -0800 run

Re: recreate constraints script - URGENT

If you have one to generate the constraints for a table, just modify it slightly to include a whole schema. Just checked, I don't have such a beastie. Check orafaq.com, likely there is one there. Jared system manager [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/30/2003 11:24 AM

Re: recreate constraints script - URGENT

For 9i DBs, DBMS_METADATA will (re)create DDL for every (at least most) object in the DB. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--

Re: Re:Re: recreate constraints script - URGENT

There are probably such scripts in internet, or you can write your own in few minutes, but if you need it only once, then one easy way would be just to use TOAD (free/shareware ver) or similar tools to extract scripts of your constraints from database. Tanel. - Original Message

Re: recreate constraints script - URGENT

Yep, that's a good call, although there was some bug with paritioned tables I think... Also, metalink note 1016836.6 has a script for capturing constraints. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 30, 2003 11:49 PM

Questions about constraints

Hallo, I get this errormessage while inserting to this table. How can I check this constraint problem? Any wrong with the table definition 9.03.2003 09:46:38 Db_Transfil.AVSTEM - ORA-2: db_filtype_ik.AVS TEM: - ORA-2: db_filtype_ik:OVERFOR_TIL_KUN:

RE: Questions about constraints

You are trying to insert a row that contains values that already exist in the table, and there is a constraint on the table that says the values for the row(s) must be unique. Now about that column BONGID ... What are you smoking? -Original Message- Hallo, I get this

RE: Questions about constraints

This message is telling you that your insert violates the primary key constraint for the table. This means that the primary key, KUNHOD_TMP1_ID, value in your inserted record already exists in the table. HTH, Peter Schauss -Original Message- Sent: Wednesday, March 19, 2003 4:16 AM To:

constraints and optimizer

Hello, Env: Oracle 9.2.0.2.0 on Solaris 9 I suspect this is a foolish question, but I will ask anyway: (It's Friday; my brain stops working after Wednesday) How much does the presence of constraints influence the optimizer, if the indexes are present? We are developing a method

Re: constraints and optimizer

All recent versions of Oracle have used unique, pk and not-null constraints to help optimise queries - but I don't suppose you were thinking of those in particular. In general Oracle did not make use of check constraints except for partition views, but Oracle 9 can now make very good use

Disable / enable constraints

I need to truncate and import data into several schemas. The tables have lots of constraints. I can produce a script to disable and enable the contriants but I would like to know more about the constraint_type field in dba_constraints and what are all the SYS_ contraints? Should I disable all

RE: Disable / enable constraints

- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Smith, Ron L. Sent: Tuesday, March 11, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: Disable / enable constraints I need to truncate and import data into several schemas. The tables have lots of constraints. I

RE: Disable / enable constraints

Ron, SYS_ constraints are NOT NULL constraints. They are also those constraints placed on tables by you that you have not named. This is why we should always name our constraints! The Constraint_Type field is decoded as follows: C = Check Constraint P = Primary Key R = Relational (Foreign Key

RE: Primary Key Constraints

Hi Mike, I presume you want to disregard System tables, so here goes select owner, table_name from dba_tables where owner not in ('SYS','SYSTEM','OUTLN','DBSNMP') minus select owner, table_name from dba_constraints where constraint_type = 'P'; -Original Message- Sent: Tuesday,

Primary Key Constraints

Is there an easy query to get a list of tables that don't have any primary key? I've tried a couple of different ones, but none of them work quite right. Seems like this should be easy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Sardin INET: [EMAIL

RE: Primary Key Constraints

Mike, How about: select table_name from user_tables a where not exists(select 1 from user_constraints b where a.table_name = b.table_name and b.constraint_type = 'P'); Constraint_type values are: P = Primary Key C = Check Constraint R =

Re: Primary Key Constraints

select owner, table_name from dba_tables where (owner, table_name) not in (select owner, table_name from dba_constraints where constraint_type = 'P'); Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday,

RE: Primary Key Constraints

SQL select table_name 2 from dba_tables 3 minus 4 select table_name 5 from dba_constraints 6 where constraint_type = 'R'; This should work (does in my 8.1.7 test db). What methods have you tried? and what was not working? -Original Message- Sent: Tuesday, November 26,

Re: Primary Key Constraints

select owner, table_name from dba_tables where not exists (select 'a' from dba_constraints where constraint_type = 'P' and owner = dba_tables.owner and table_name = dba_tables.table_name) order by owner, table_name; Mike Sardina wrote: Is there an easy query to get a list of tables that don't

RE: Primary Key Constraints

Title: RE: Primary Key Constraints SELECT owner, table_name FROM DBA_TABLES t WHERE NOT EXISTS (SELECT 'X' FROM DBA_CONSTRAINTS c WHERE c.owner = t.owner AND c.table_name = t.table_name AND c.constraint_type = 'P') ORDER BY 1,2 Take off the ORDER BY to speed things up

RE: Primary Key Constraints

:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 6:25 AM To: Multiple recipients of list ORACLE-L Subject:Primary Key Constraints Is there an easy query to get a list of tables that don't have any primary key? I've tried a couple of different ones, but none of them work quite right

Re: Primary Key Constraints

how about select table_name from user_tables where table_name not in (select table_name from user_constraints where constraint_type = 'P'); [EMAIL PROTECTED] 11/26/02 01:25PM Is there an easy query to get a list of tables that don't have any primarykey? I've tried a couple of different ones,

RE: Primary Key Constraints

try this: select table_name from user_tables minus select table_name from user_constraints where constraint_type = 'P'; -Original Message- Sent: Tuesday, November 26, 2002 2:25 PM To: Multiple recipients of list ORACLE-L Is there an easy query to get a list of tables that don't have

Re: Primary Key Constraints

it's sure easy enough SELECT (OWNER, TABLE_NAME) FROM DBA_TABLES WHERE (OWNER, TABLE_NAME) NOT IN (SELECT OWNER, TABLE_NAME FROM DBA_CONSTRAINTS WHERE CONSTRAINT_TYPE = 'P') HTH Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday,

RE: Primary Key Constraints

Another way : select t.owner, t.table_name from dba_tables t minus select c.owner, c.table_name from dba_constraints c where c.constraint_type='P' ; --- Mercadante, Thomas F [EMAIL PROTECTED] a écrit : Mike, How about: select table_name from user_tables a where not exists(select

Re: Primary Key Constraints

select table_name from user_tables minus select table_name from user_constraints where constraint_type='P'; HTH, Krishna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 11:25 AM Is there an easy query to get a list of

RE: Constraints problem

Title: RE: Constraints problem You can simply export, then import the tables...making sure you use fromuser/touser,ignore=y,rows=n Since the table is already there and rows=n, the table will not be rebuilt and the constraints will be added, but you have to make sure that ignore=y

Re: Constraints problem

Hi I had to copy a set of tables with data from one schema into another. I did this by using create table table_name as select * from master_schema.table_name; But the constraints ( primary key, foreign key etc) are not created in the test schema. Is there any way to implement all

Constraints

Hallo, I am trying to run this script, ALTER TABLE PBK.K1 ADD CONSTRAINT idx_rollson PRIMARY KEY (BUTIKS_NR) but gets the erormessage ORA-02437: cannot validate (PBK.IDX_ROLLSON) - primary key violated what can I do to solve this? Please help me. Wouldnt it be enough to have unique values

RE: Constraints

Likely that your data in the table violates the constraint. Export the table, truncate table, add constraint and try importing to it -watch for violation of constraint during import. Ciao 'n best of luck. --- CSW -Original Message- Sent: Wednesday, April 24, 2002 3:09 PM To: Multiple

RE: Constraints

you must ensure uniquness and not null of each value in cells of column BUTIKS_NR -Original Message- [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 5:39 PM To: Multiple recipients of list ORACLE-L Hallo, I am trying to run this script, ALTER TABLE PBK.K1 ADD CONSTRAINT

Re: Constraints

hi roland ... it seems your table already had a data redundant data ...for a BUTIKS_NR column and when you try to add a new constraints it produced an error message try to remove redundant data ... or empty your table first... then add a constraint ... regards kang bedjo I'd

RE: Constraints

it should not contain any null values too other than being unique. Kranti -Original Message- Sent: Wednesday, April 24, 2002 5:39 PM To: Multiple recipients of list ORACLE-L Hallo, I am trying to run this script, ALTER TABLE PBK.K1 ADD CONSTRAINT idx_rollson PRIMARY KEY

Re: Constraints

what can I do to solve this? RTFM about primary keys. They need to be unique and not null. [EMAIL PROTECTED] wrote: Hallo, I am trying to run this script, ALTER TABLE PBK.K1 ADD CONSTRAINT idx_rollson PRIMARY KEY (BUTIKS_NR) but gets the erormessage ORA-02437: cannot

Re: Constraints

: Constraints

RE: Constraints

Roland have you tried a select butiks_nr, count(*) from pbk.k1 group by butiks_nr having count(*) 1 to check there really are no duplicates -Original Message- Sent: Wednesday, April 24, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Hallo, I am trying to run this script,

RE: Constraints Lookup

This will give all the tables whose constraints reference a given table /* All the tables that reference a given table in their constraints. */ SELECT a1.table_name Target Table ,a1.constraint_name Target Constraint ,d1.column_name Target Column ,b1.table_name Referencing Table ,b1

Constraints Lookup

Yes, this should be easy I need to find all the tables that referance a given table in their constraints. Can somebody help, it's been a long day TIA, John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City

RE: Constraints Lookup

.table_name =TAB AND a1.owner=OWNER ORDER BY 1,7 -Original Message- Sent: Tuesday, April 23, 2002 5:53 PM To: Multiple recipients of list ORACLE-L Yes, this should be easy I need to find all the tables that referance a given table in their constraints. Can somebody help, it's been

deferred constraints

? The justification for this would be the flexibility of altering the constraint state, should the need ever arise. How do most of you create your constraints, as deferred or not deferred? Thanks to any responders. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Becker INET

Re: script to rename constraints

I don't have one, but would love to have one. ( hint, hint ) Jared On Tuesday 19 February 2002 03:28, John Dunn wrote: Anyone got a script that will drop table constraints which have system generated names and recreate them with names based upon the table name? John -- Please see

Import Behaviour on constraints

Title: Import Behaviour on constraints Hi list, Here is a quick question which often bothers me I have a schema A, B and C All three have integrity constraints referring to each other like, Schema A has some child tables whose parent tables are in schema B Schema B has some child tables

Constraints

Tell me if I have this right .. There are not supposed to be any Duplicate Constraint names in your Database, right ?? Right now I have a database that has 48 constraints that are duplicated in name. They are constraints that have a system generated name. Its on Oracle 8.0.5. Anyone

Re: Constraints

that has 48 constraints that are duplicated in name. They are constraints that have a system generated name. Its on Oracle 8.0.5. Anyone know of any known bug that would allow this ? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange

RE: Constraints

Database, right ?? Right now I have a database that has 48 constraints that are duplicated in name. They are constraints that have a system generated name. Its on Oracle 8.0.5. Anyone know of any known bug that would allow this ? Thanks Kevin -- Please see the official ORACLE-L FAQ: http

RE: Constraints

constraints that are duplicated in name. They are constraints that have a system generated name. Its on Oracle 8.0.5. Anyone know of any known bug that would allow this ? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat

RE: Constraints

Title: RE: Constraints -Original Message- From: Kevin Lange [mailto:[EMAIL PROTECTED]] There are not supposed to be any Duplicate Constraint names in your Database, right ?? Right now I have a database that has 48 constraints that are duplicated in name

Re: Constraints

who is the owner of the duplicated constraints? if the owner names are different, could you have created one set by import from the other user? just like any other object, the name can be the same if the owners are different --- Kevin Lange [EMAIL PROTECTED] wrote: Tell me if I have this right

RE: Constraints

that has 48 constraints that are duplicated in name. They are constraints that have a system generated name. Its on Oracle 8.0.5. Anyone know of any known bug that would allow this ? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET

Re: Disabling Constraints

') and owner='SCHEMA'; HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 26, 2001 5:31 PM I need to disable some constraints to load table data for my DB conversion. I cannot find the syntax to do this. I think it should

RE: Disabling Constraints

Ruth: Thanks, I found this to work also. ALTER TABLE 'TABLE_NAME DISABLE CONSTRAINGT CONSTRAINT_NAME; Ken -Original Message- Sent: Tuesday, November 27, 2001 7:00 AM To: Multiple recipients of list ORACLE-L Subject:Re: Disabling Constraints Here is a script which

RE: Disabling Constraints

PM Para: Multiple recipients of list ORACLE-L Asunto: Disabling Constraints I need to disable some constraints to load table data for my DB conversion. I cannot find the syntax to do this. I think it should be ALTER TABLE something. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient

Disabling Constraints

I need to disable some constraints to load table data for my DB conversion. I cannot find the syntax to do this. I think it should be ALTER TABLE something. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ

Re: Disabling Constraints

At 02:31 PM 11/26/01 -0800, you wrote: I need to disable some constraints to load table data for my DB conversion. I cannot find the syntax to do this. I think it should be ALTER TABLE something. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN

renaming Constraints

Title: renaming Constraints Hi list, is there any easiar way to rename a constraint other then dropping and then recreating it, cuz in our environment, developers mess up the constraints with naming them using system assigned names and then after finilizing the tables and relations, i have

RE: renaming Constraints

-- HTH Mark -Original Message- Sent: 19 November 2001 11:11 To: Multiple recipients of list ORACLE-L Hi list, is there any easiar way to rename a constraint other then dropping and then recreating it, cuz in our environment, developers mess up the constraints

enabling foreign key constraints

Hi, When we do alter table table_name disable primary key cascade;..it also disable all the foreign key constraints but when we after do alter table table_name enable primary key..it does not enable foreign keys is there any syntax that we can enable all th foreign keys

ENABLING FOREIGN KEY CONSTRAINTS

Hi, When we do alter table table_name disable primary key cascade;..it also disable all the foreign key constraints but when we after do alter table table_name enable primary key..it does not enable foreign keys is there any syntax that we can enable all th foreign keys

RE: ENABLING FOREIGN KEY CONSTRAINTS

To: Multiple recipients of list ORACLE-L Hi, When we do alter table table_name disable primary key cascade;..it also disable all the foreign key constraints but when we after do alter table table_name enable primary key..it does not enable foreign keys is there any syntax that we can

RE: ENABLING FOREIGN KEY CONSTRAINTS

Title: RE: ENABLING FOREIGN KEY CONSTRAINTS -Original Message- From: Harvinder Singh [mailto:[EMAIL PROTECTED]] When we do alter table table_name disable primary key cascade;..it also disable all the foreign key constraints but when we after do alter table table_name

RE: constraints in create table..

ist ORACLE-LSubject: constraints in create table.. hi all, do anybody explain me what is happening when i'm creating a table with the following constraints.. CREATE TABLE TAB1( ENUM NUMBER PRIMARY KEY CHECK(ENUM IS NULL), ENAME VARCHAR2(10) ); why i'm

constraints in create table..

hi all, do anybody explain me what is happening when i'm creating a table with the following constraints.. CREATE TABLE TAB1( ENUM NUMBER PRIMARY KEY CHECK(ENUM IS NULL), ENAME VARCHAR2(10) ); why i'm being able to create table with such contradicting constraints. both can't be true

dyn sql(get the constraints script)

for those of you with metalstink, its Doc ID: Note:1016836.6 for those of you who dont(and want it, email me). have a good weekend everyone(for those of you already into the weekend in Australia and NZ, what does the weekend look like, good? joe

foreign key constraints

Let's say I had two tables: CREATE TABLE t1 ( col1 NUMBER PRIMARY KEY); CREATE TABLE t2 ( col2 REFERENCES t1(col1), col3 VARCHAR2(40)); Then I ran the query: select a.table_name, b.table_name, b.column_name from user_constraints a, user_cons_columns b where

RE: foreign key constraints

='R'; :0) g -Original Message- From: Guy Hammond Sent: Tuesday, August 21, 2001 2:44 PM To: '[EMAIL PROTECTED]' Subject: foreign key constraints Let's say I had two tables: CREATE TABLE t1 ( col1 NUMBER PRIMARY KEY); CREATE TABLE t2 ( col2

Deferred constraints (?)

Do we have the concept of deferred CHECK constraints? For a constraint of this nature, I don't Oracle to check the whole table as I have done the fixes to ensure there is no occurrence of invalid condition. I only want the future ones to be checked. ALTER TABLE KB.table ADD CONSTRAINT

RE: primary/ foreign key constraints for oltp, overhead?...soluti

Title: RE: primary/ foreign key constraints for oltp, overhead?...soluti Thanks Jared -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 16, 2001 11:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: primary/ foreign key constraints

RE: primary/ foreign key constraints for oltp, overhead?...soluti

Title: RE: primary/ foreign key constraints for oltp, overhead?...soluti Thanks Anita -Original Message- From: A. Bardeen [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 16, 2001 5:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: primary/ foreign key constraints for oltp

RE: primary/ foreign key constraints for oltp, overhead?...soluti

Amar, That's the whole point Jared was trying to make: your locking issue is because you *don't* have indexes on your foreign keys. You might want to review the following notes: 11828.1 FOREIGN KEYS, INDEXES AND PARENT TABLE LOCKING 33453.1 (V7) REFERENTIAL INTEGRITY AND LOCKING 38373.1

RE: primary/ foreign key constraints for oltp, overhead?...soluti

No indexes on foreign key. still the same result. rgds amar -Original Message- Sent: Monday, June 11, 2001 2:05 PM To: Multiple recipients of list ORACLE-L overhead?...soluti Jared has a point. Is there an index on the foreign key? Another minor detail: You should of course never

RE: OT - SSN( Enforced Constraints (sic) ??

Hell, when I joined the gym they asked for it. I asked them what they needed for and they said they didn't and I did not have to supply it. Duh... I find it amazing how much they ask for the SSN here in the US. I don't recall being asked for my Social Insurance number this much back home in

RE: Enforced Constraints (sic) ??

There is also a problem with SSNs, if you deal with Foreign nationals. We had that problem with a US Army program in Europe and Korea. We had to make up Unique numbers to fit the program. Georgette -Original Message- Sent: Tuesday, June 12, 2001 12:41 To: Multiple recipients of list

RE: Enforced Constraints (sic) ??

It's interesting that SSNs are not recycled. My mother works for the SSA and says they are after the person is deceased for a certain period of time (I forget the specifics). Also, a lot of people get nervous when you use their SSN for an identifier. I've noticed that most State Driver's

RE: Enforced Constraints (sic) ??

Close. You forgot about the violation of one of the key rules in creating unique keys. Do not embed meaning in the key. The first 3 numbers are determined on where you apply for the SSN. That reduces the usable numbers. Someone once told me that the two numbers in the middle mean something

RE: OT - SSN( Enforced Constraints (sic) ??

When the DMV first asked for my SSN, I gave them an incorrect one, because as far as I'm concerned they don't need to know it. Now that they actually check the number with the SSA I was forced to correct it. Most places are forbidden to require that you supply your SSN unless they need it to

Re: OT - SSN( Enforced Constraints (sic) ??

except check out the ssn faq and alot of those numbers are not used. joe PS: http://www.faqs.org/faqs/privacy/ssn-faq/ Regina Harter wrote: When the DMV first asked for my SSN, I gave them an incorrect one, because as far as I'm concerned they don't need to know it. Now that they

RE: primary/ foreign key constraints for oltp, overhead?...soluti

Jared, I tried again and got the same result. on oracle 8.1.7 (RBO). session1 : delete from emp where deptno = 10; session2 : delete from dept where deptno = 30; session 2 hanged and waited till transaction in session one was committed. the max_trans on both tab is set to 255, incase this

Re: primary/ foreign key constraints for oltp, overhead?...soluti

Jared has a point. Is there an index on the foreign key? Another minor detail: You should of course never update a primary key column, of course :-) Amar Kumar Padhi wrote: Jared, I tried again and got the same result. on oracle 8.1.7 (RBO). session1 : delete from emp where deptno = 10;

RE: primary/ foreign key constraints for oltp, overhead?...soluti

in a trigger on the detail table. rgds amar -Original Message- Hi, my current project database has no primary/ foreign key constraints. Curious about this basic check missing in the system, I was informed that these constraints result in lot of locking issues and would be a bottleneck to huge

RE: primary/ foreign key constraints for oltp, overhead?...soluti

in a trigger on the detail table. rgds amar -Original Message- Sent: Saturday, June 09, 2001 7:54 AM To: '[EMAIL PROTECTED]' Hi, my current project database has no primary/ foreign key constraints. Curious about this basic check missing in the system, I was informed that these constraints

Re: primary/ foreign key constraints for oltp, overhead?...soluti

On Sunday 10 June 2001 21:50, Amar Kumar Padhi wrote: - locks Oracle generates internal locks on dict tables to maintain the data integrity. e.g.: I deleted a record from detail table in one session. In another session I tried to delete a master record not related to the deleted detail

Conventions for naming indexes, constraints etc.

Hi listers, A couple of days back somebody in the list had sent an URL about the convention to be followed for naming indexes, constraints etc. I have lost it somewhere. Could any of you who have saved and have it now send it to me? I am in need of it very badly. TIA and regards

Re: Conventions for naming indexes, constraints etc.

cc: Sent by: Subject: Conventions for naming indexes, constraints etc. [EMAIL

RE: Conventions for naming indexes, constraints etc.

group.com cc: Sent by: Subject: Conventions for naming indexes, constraints etc. [EMAIL PROTECTED] 01.04.18 12:20 Please respond to ORACLE-L

RE: Constraints

Roland, Unique or primary key constraints will drop the associated index if disabled. If reenabled they would need to be done with the storage clause or will just go in the default tablespace. Iain Nicoll -Original Message- Sent: 05 April 2001 11:21 To: Multiple recipients of list

Check the constraints

Hallo Anyoine know about any program that can check all the constraints after the database is designed? Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: Check the constraints

Roland, Oracle Designer can reverse engineer an Oracle database and capture all constraint (and other) info. You can then run various reports and/or display the data model in diagrams to allow you to validate the accuracy and completeness of the constraints. It can do much, much more as well

RE: Check the constraints

Title: RE: Check the constraints Hi, The SQL impact from Toad maybe can help. rgds, -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Subject: Check the constraints Hallo

Constraints with Synonyms?

Hi, I have a need to create a synonym in a schema (A) for a table that is another schema (B). This is no problem. However, the table in question is a "parent" table and I cannot create the "references" constraint from the "child" to the "parent" when the "parent" is a synonym. When I

Re: FK Constraints

Hi All, Nobody has proposed this before so let me throw it out for discussion. Think about a compromise between having and not having referential integrity constraints. The approach is that during development and testing, all RIs are enabled. But when you push to production, disable or drop all

Re: FK Constraints

Rachel Carmichael wrote: the DBA is not responsible for the data?? Could you PLEASE come to my office and explain that (I'll bring the heavy club) to my developers, users and management? They seem to believe that my primary function is to dig information out of the database for them.

Re: FK Constraints

Ramani: I live daily with the negative effects of referential integrity enforced (sometimes) at the application level. From my standpoint, there have been no "pros" to this method. I need to use a lot of data from our mainframe DB2 database, where all of the RI is written into their

Re: FK Constraints

Rachel, One way I got this across to my developers and users was in creating new users for the DB. Every time I got a new user request, I would forward it to the director of the group that officially "owns" the data to get his permission to allow them in HIS data. After a few round robins of

Re: FK Constraints

collected all the cudgels yet :) From: Rodd Holman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: FK Constraints Date: Tue, 20 Mar 2001 07:35:32 -0800 Rachel, One way I got this across to my developers and users was in creating

Re:FK Constraints

e: 3/19/2001 10:05 AM Hi all: We have a situation where are no relationships are defined at the database level. i.e no foreign keys constraints have established at the Database. The application is still at the Development Stage. Everything is controlled at the application level. I as the

  1   2   >