Database Administration (MOSC)

MOSC Banner

Need to tuncate table

edited Apr 7, 2010 5:48AM in Database Administration (MOSC) 6 commentsAnswered
 Hello all,
I want to truncate a table from one schema to other schema.
I can't give  "grant drop any table to table;" as it is dangerous.
I cant create a stored procedure as i can't run the procedure manually everytime.

Please give some suggesstion to implement this.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center