Wednesday, January 22, 2014

How to take a snapshot in oracle Database

To create a snapshot you have to run the below command in oracle database.


EXEC DBMS_WORKLOAD_REPOSITORY.create_snapshot;



New snapshot with snap id will be generated.












at



























Labels:
,
,
,
,


















No comments:















Post a Comment


















        

      









Subscribe to:
Post Comments (Atom)









Command to do active duplicate for Oracle Database



1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...