OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » data view (sql+)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

data view [message #648350]

Sun, 21 February 2016 13:18

vishnuy
Messages: 1
Registered: February 2016
Location: BANGLORE

Junior Member

Dear team,
I had one table with data
after that i can did truncate the my table, if then automatically my data is cleared from table except columns names,
my Query is how to retrieve the my data into table

Report message to a moderator

Re: data view [message #648351 is a reply to message #648350]

Sun, 21 February 2016 13:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

if you really issued TRUNCATE TABLE, then the data is no longer available since you removed it.
one can not ROLLBACK the TRUNCATE command

Report message to a moderator

Re: data view [message #648352 is a reply to message #648351]

Sun, 21 February 2016 14:04

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

You can use flashback or a back up if either is available. Otherwise you're out of luck

Report message to a moderator

Previous Topic:	filtering in a table by ignoring the records those are unnecessary anymore
Next Topic:	initialize a nested table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 18:36:48 CDT 2024