Re: Is possible to truncate a remote DB?

From: Mark D Powell <mark.powellNOmaSPAM_at_eds.com.invalid>
Date: 2000/07/24
Message-ID: <06ead8bf.897a5a53@usw-ex0102-015.remarq.com>#1/1

miguelangel6886_at_my-deja.com wrote:
>Hi!
>Does anybody know if is it possible to truncate a remote
database? I
>mean, without using drop table or delete from.
>regards,
>Miguel
>

On the targe db set up a truncate procedure then execute this from your local db. With version 8.1 and up you can use the pl/sql execute immediate statement and for version 7 - 8 you can use the dbms_sql package. Have the procedure owner be the table owner for privilege reasons, and build in a check of authorized tables to be truncated to prevent malicious or just plain stupid use.

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Mon Jul 24 2000 - 00:00:00 CDT