Oracle TRUNCATE

[Ivor1]

Thanks. Got nothing (when I put a % at the beginning too, the statement showed itself so for an instant I thought....)

Since what I really wanted was not the time so much as the culprit, I employed soft means to find out. Not involving death or major organ failure, so quite in order as an information-gathering exercise.

Truncate might have been all upper case I think so may be thats why you didnt find anything.

SELECT * from V$SQL is always good to see what people are running, or are upto.

[expat]

Might be worth having a look in the V$SQL table within the schema the truncated table lives. Try the following, there is last load and first load date fields in that table as well.

SELECT * FROM V$SQL where SQL_TEXT like ('Truncate%')

Thanks. Got nothing (when I put a % at the beginning too, the statement showed itself so for an instant I thought....)

Since what I really wanted was not the time so much as the culprit, I employed soft means to find out. Not involving death or major organ failure, so quite in order as an information-gathering exercise.

[Ivor1]

Might be worth having a look in the V$SQL table within the schema the truncated table lives. Try the following, there is last load and first load date fields in that table as well.

SELECT * FROM V$SQL where SQL_TEXT like ('Truncate%')

[EqualOpportunities]

Anyone know how to find out when a table was TRUNCATEd in Oracle? (Apart from asking the usual suspects).

Not so you'd notice...

However, if your database is running in Archivelog mode, dust off log miner and see at what what you can find - that'll give you a reasonable indication of time, depending on log switch frequency.

Alternatively, write the letters A-Z and the numbers 0-9, in a circle, on a piece of paper; I'll find a shot glass, or a bottle top, or something.

HTH

[expat]

Anyone know how to find out when a table was TRUNCATEd in Oracle? (Apart from asking the usual suspects).

I guess not....

Logically speaking, one answer is: TRUNCATE it. Look at your watch.

[expat]

Anyone know how to find out when a table was TRUNCATEd in Oracle? (Apart from asking the usual suspects).