tag:blogger.com,1999:blog-940885937847335876.post5020502397383072284..comments2024-01-31T15:08:14.203+05:30Comments on One Can Succeed at Almost Anything For Which He Has Enthusiasm...: Flashback Features in Oracle 10gNEERAJ VISHENhttp://www.blogger.com/profile/04032578930084182369noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-940885937847335876.post-53225187822166919882013-05-15T22:33:09.685+05:302013-05-15T22:33:09.685+05:30Hi Saran ,
It seems privilege issue . Grant the ...Hi Saran , <br /><br />It seems privilege issue . Grant the sufficient required privilege to connected user . Try to grant DBA role and check the output .<br /><br />Let me know if there is any issue .<br /><br />Enjoy :) NEERAJ VISHENhttps://www.blogger.com/profile/04032578930084182369noreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-81626094100718621472013-05-15T07:59:12.484+05:302013-05-15T07:59:12.484+05:30Hi Neeraj,
I'm facing the below issue while u...Hi Neeraj,<br /><br />I'm facing the below issue while using dbms_flashback. So can u assist me on this..<br />SQL> select dbms_flashback.get_system_change_number from dual;<br />select dbms_flashback.get_system_change_number from dual<br /> *<br />ERROR at line 1:<br />ORA-00904: : invalid identifier<br /><br /><br />SQL> select * from v$version;<br /><br />BANNER<br />----------------------------------------------------------------<br />Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod<br />PL/SQL Release 10.2.0.3.0 - Production<br />CORE 10.2.0.3.0 Production<br />TNS for 32-bit Windows: Version 10.2.0.3.0 - Production<br />NLSRTL Version 10.2.0.3.0 - Production<br /><br />SQL> desc dbms_flashback<br />ERROR:<br />ORA-04043: object "SYS"."DBMS_FLASHBACK" does not exist<br /><br />Thanks<br />Sarathsarathhttps://www.blogger.com/profile/08107624918027005549noreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-86919141492340103422012-10-08T15:30:23.193+05:302012-10-08T15:30:23.193+05:30Hi Neeraj,
I am not sure if this is the correct p...Hi Neeraj,<br /><br />I am not sure if this is the correct post to put my comments.<br />I'll be grateful if you could assist me with my problem below.<br /><br />"I would like to identify all Insert/Update statements for a particular PeopleSoft application table.<br />We are facing this peculiar issue in production and Oracle GSC is unable to replicate and hence provide very little assistance.<br /><br />The table that is in question is PS_PAY_MISC_DST for which I need to find out all the Inserts/Updates that were made on this table to be able to isolate the problem. SYSDBA access rights are available with me.<br /><br />I say the problem is peculiar because we cannot replicate it in any of SDLC environments and neither can Oracle GSC replicate it in Demo. But the issue still persists and happens every month end"<br /><br />Thank you for your time!Ciphersbakhttps://www.blogger.com/profile/01586158446874473262noreply@blogger.com