OraFAQ Forum: SQL & PL/SQL » Flash back Tables

Home » SQL & PL/SQL » SQL & PL/SQL » Flash back Tables

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

Flash back Tables [message #220062]

Sun, 18 February 2007 07:19

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Hi,

I have oracle10g database.

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bi
PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for Solaris: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production

When i use DBMS_FLASHBACK it is working fine.

SQL> select DBMS_FLASHBACK. GET_SYSTEM_CHANGE_NUMBER from dual;

GET_SYSTEM_CHANGE_NUMBER
------------------------
1.9930E+10

But when i use Flashback command:

SQL> FLASHBACK TABLE flash_bak TO BEFORE DROP;
SP2-0734: unknown command beginning "FLASHBACK ..." - rest of line ignored.

i am getting the above error.

If it is regarding the priviliges then ,how come i can use DBMS_FLASHBACK but not FLASHBACK.

Please let me know should i set any parameter on or if it is a issue of privileges ,how can i give privilge to scott/tiger schema.

Thanks,
Srinivas

Report message to a moderator

Re: Flash back Tables [message #220063 is a reply to message #220062]

Sun, 18 February 2007 07:26

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

HI,

SP2-0734: unknown command beginning "FLASHBACK ..." - rest of line ignored

Long story in Short >>> Must sure your using 10g SQLPLUS TOOLS instead of Lower version sqlplus tools

It is correct your using 10gr1.and it is fully supported FLASH BACK feature.
but you are login with sqlplus of which version ?
May be it is <= 10g.

just try on your command prompt.
[pre]
c:\>%ORACLE_HOME%\bin\sqlplus system/oracle@tns_entry
SQL>try flashback option.

regards
Taj

[Updated on: Sun, 18 February 2007 07:29]

Report message to a moderator

Re: Flash back Tables [message #220064 is a reply to message #220062]

Sun, 18 February 2007 08:16

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Hi,

When i went through the path:

C:\Forms10g\bin>sqlplus scott/tiger@ora10g

SQL*Plus: Release 9.0.1.4.0 - Production on Sun Feb 18 19:58:15 2007

(c) Copyright 2001 Oracle Corporation. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

This is what i got from the path.

Can you please tell me where i can update even by sql*plus tool.
Can you give me the download URL.

Thanks a lot for your reply...
Srinivas

Report message to a moderator