| bulk delete of table-rows [message #73386] |
Thu, 08 April 2004 02:55  |
Florian Magirius
Messages: 1
Registered: April 2004
|
Junior Member |
|
|
Hello,
what is the right syntax to truncate more than one table in one command, I want to write the command in a sql-batch. I used the option "reuse storage"
I tested it for several tables, also parent-tables (I assumed they are), each of them could be truncated in a seperated truncate-command. But in a batch-file in svrmgrl it didn't work.
Does anybody have an idea?
Thanks.
FM
|
|
|
|
| Re: bulk delete of table-rows [message #73418 is a reply to message #73386] |
Tue, 20 April 2004 22:39  |
Pankaj Gupta
Messages: 4
Registered: April 2004
|
Junior Member |
|
|
1. Such batch commands can run only via sqlplus command. cause on svrmgrl u cannot run sqlplus command.
2. incase of Tables having Parent and Child relationship and delete on cascade is defined on parent then the child row will automatically get deleted.
yes u have to write seprate truncate command to delete
seprate table (Incase the tables and not related as mentioned above).
u cannot delete rows from all tables using one truncate command.
Regards
Pankaj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
