| pamidi |
Posted: Jul 19, 2008 07:03:53 AM |
Total Post: 5
Joined: Jul, 2008
|
Hi All
what is ORA-01555
what is ORA-600
can u tell cler informaion
Regds
Ramesh |
|
|
 Murtuja |
| Posted: Jul 20, 2008 03:06:49 AM |  |
|
Total Post: 857
Joined: Jan, 2006
|
Can you please read the books?
|
|
|
|
|
| Avnish |
| Posted: Jul 20, 2008 11:46:03 PM | |
|
Total Post: 154
Joined: Dec, 2007
|
Hi,
Please post a right thread in right manner. Here your subject is Difference between Truncate & delete and you are asking for ORA-0155 , ORA-0600 Errors?
Thanks & Regards
Avnish Yadav
|
|
|
|
|
| muna |
| Posted: Aug 01, 2008 02:13:08 AM | |
|
Total Post: 14
Joined: Jul, 2007
|
truncate-
is a dml operation
it empty total data from table
we can not use undo opertion after truncate
it is fast compare to delete
delete-
it delete certion row
we use coditon for delete
we can use undo opertion
slow compare to truncate
|
|
|
|
|
| seema |
| Posted: Sep 02, 2008 05:31:17 AM | |
|
Total Post: 70
Joined: Jan, 2008
|
Truncate - 1.DDl command
2.That will remove data not the structure.
Delete-1.DML command
2.If we are not specify any condition or where clause in delete command that will be same as truncate command.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
