Home » SQL & PL/SQL » SQL & PL/SQL » Flash back Tables
Flash back Tables [message #220062] Sun, 18 February 2007 07:19 Go to next message
srinivas.k2005
Messages: 342
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
Re: Flash back Tables [message #220063 is a reply to message #220062] Sun, 18 February 2007 07:26 Go to previous messageGo to next message
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 Go to previous messageGo to next message
srinivas.k2005
Messages: 342
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
Re: Flash back Tables [message #220065 is a reply to message #220064] Sun, 18 February 2007 08:22 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

Install Oracle 10g Client.



regards
Taj
Re: Flash back Tables [message #220674 is a reply to message #220065] Wed, 21 February 2007 09:28 Go to previous message
srinivas.k2005
Messages: 342
Registered: August 2006
Senior Member
Thanks a lot.
Previous Topic: want to update any character of a field
Next Topic: Order By Trouble
Goto Forum:
  


Current Time: Sat Dec 10 16:35:08 CST 2016

Total time taken to generate the page: 0.06726 seconds