System Change Numbers (SCN) on 9i, 10g

I want to know how to get the SCN numbers in Oracle 9i and 10g. Please let me know if you have the answer.

asked Dec 21 '09 at 08:51 AM in Default

OracleApprender
763 ● 53 ● 67 ● 73

(comments are locked)

2 answers:

The current SCN can be retrieved by querying the V$DATABASE view.

answered Dec 21 '09 at 10:58 AM

Do you have any idea to get the same in the query format ?

Dec 21 '09 at 12:16 PM OracleApprender

Thank you for your quick response

Dec 21 '09 at 12:17 PM OracleApprender

you mean like 'SELECT * FROM V$DATABASE'?

Dec 21 '09 at 12:35 PM HillbillyToad

Yes. I want it in SELECT query format.

Dec 21 '09 at 01:49 PM OracleApprender

(comments are locked)

Answer for this question is :

select sys.dbms_flashback.get_system_change_number from dual;

answered Dec 22 '09 at 07:01 AM

OracleApprender
763 ● 53 ● 67 ● 73

(comments are locked)

Your answer

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Topics:

sql x599
oracle x359

asked: Dec 21 '09 at 08:51 AM

Seen: 1221 times

Last Updated: Dec 22 '09 at 11:32 AM