This content has been marked as final. Show 23 replies
The child ones, as you will kill its parent, they will remain inconsistent. So , you have to disable them first.1 person found this helpful
How do I query the child constraints?
This will help1 person found this helpful
select 'alter table 'a.owner'.'a.table_name' disable constraint 'a.constraint_name';'
from dba_constraints a, dba_constraints b
where a.constraint_type = 'R'
and a.r_constraint_name = b.constraint_name
and a.r_owner = b.owner
and b.table_name like 'TABLE_YOU_WANT_TO_TRUNCATE';
How about nologging? I want want truncate or delete a table not to log.
Is this command correct?
Alter table EMP nologging;
Alter tablespace nologging;
Alter database nologging;
+ RUN > alter database switch log file;
How about nologging? I want want truncate or delete a table not to log.Sigh....
Yes, how about it?
What does nologging do?
What are the drawbacks of nologging?
What does truncate log?
What does delete log?
When you know the answers to those questions, you'll know whether nologging is right for you.
Now, if only the documentation had direct and simple answers to those questions...
Is this command correct?If only Oracle would ever get around to documenting the syntax of their commands in the SQL Reference Guide.
security? can we get security in here please?
Just show me the right command so I can credit points , kk ;)
why you refuse read the documentation? 99% of your question are in documentation, you are generating a constant abuse on this forum that frustrates users who try to help and therefore some gurus will leave this forum.
STOP ANSWERING DOCUMENT QUESTIONS
There are lots of reference present online.You can easily find it1 person found this helpful
Some of them is
Always do online crosscheck and you can also use the search feature of this forum before posting your issues.
Just show me the right commandOh, now you're commanding me to show you the command to use, huh?
When you pay my salary or hourly rate, you can do that. Not before.
NOLOGGING is not relevant for a TRUNCATE.1 person found this helpful
TRUNCATE is DDL, not DML, therefore it doest not generate any redo to begin with.
NOLOGGING is only relevant for direct path inserts, SQL*Loader operations in terms of DML.
Even if the table is in NOLOGGING, when you do a DELETE it will still generate redo normally.
Please read: http://docs.oracle.com/cd/B19306_01/server.102/b14200/clauses005.htm
so I can credit points , kkHow about not, kk
therefore some gurus will leave this forum.If a "guru" left this forum because of the infantile behaviour of one person, then something is wrong with that picture.