trunc.sql

--
-- Title :       trunc.sql
-- Description : To truncate a table of 
--               different ownership without
--               without requiring the DROP ANY 
--               TABLE privilege.
--
-- Usage/Notes : (1) Ensure trunc_proc.sql has
--                   run first.
--               (2) Supply owner and table
--                   name of table to be
--                   truncated.
--
-- Copyright :   ABCdba.com 2005
--
 
ACCEPT table_owner 
PROMPT 'Enter table owner : '
ACCEPT table_name 
PROMPT 'Enter table name to be truncated :  '
 
EXEC TRUNC_PROC ('&table_owner..&table_name');

© copyright 2001-2014 ABCdba.com | all rights reserved