Database Administration (MOSC)

MOSC Banner

truncate in scripts

edited Apr 23, 2013 8:55AM in Database Administration (MOSC) 12 commentsAnswered
Db = 10g 10.2.0.5

I found a SQR routine that runs a delete from on a table to clear its contents every run.  Obviously I want to get this replaced with a truncate instead but the programmers complain that if they create their own test tables and run this routine it won't work because the schema name is hard coded for the production schema.

I'm thinking of ways around it (if forced to) but I wanted to post this to see what ideas or experience you may be able to share.

Thank you

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