Hard Links
- Hard links have actual content
- Hard link is the replica of the original file
- All hard links have the same inode number
Soft Link Vs Hard Link in Solaris & AIX Unix OS – Difference and Features
How to Find Out Last Modified Time of a Row in an Oracle 10g 11g Table Using ORA_ROWSCN and SCN_TO_TIMESTAMP Functions?
ora_rowscn pseudo column and SCN_TO_TIMESTAMP function
Oracle 11g database can link the system change number and corresponding timestamp for certain amount of time period. This short period of time depended on the auto-tuned undo retention period.
How to Get Current SCN for Oracle 10g 11g Database? DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER and V$database
There are two ways to get the current scn (System Change Number) for an oracle database.
Method 1
Get Timestamp from SCN in Oracle 10g 11g? Convert SCN to Timestamp Using scn_to_timestamp and timestamp_to_scn
There are 2 functions to perform these operations.
For converting SCN to Time Stamp you can use scn_to_timestamp function and for converting time stamp to SCN use timestamp_to_scn.
How to get Aadhaar UID application enrollment centers information for Maharashtra & Orissa
STATE NAME
|
ENROLLMENT CENTER NAME/LOCATION
|
ENROLLMENT CENTER ADDRESS
|
ORISSA
|
Central Bank of India, Rasulgad Branch
|
Rasulgad Square |
How to Rename an Unnamed datafile (UNNAMED00004) to Original Name in Oracle 9i 10g 11g Standby Database?
Please find the steps to rename an unnamed datafile to original name in Standby Database.
Step1. Find out the exact name for the datafile which is in unnamed format from V$DATAFILE table.
How to get Aadhaar UID application enrollment centers information for Uttrakhand, Tripura, Uttar Pradesh, West Bengal?
STATE NAME
|
ENROLLMENT CENTER NAME/LOCATION
|
ENROLLMENT CENTER ADDRESS
|
TRIPURA
|
Bagabasa
|
Bagabasa Panchyat Office
|
TRIPURA
|
Chandanmura
|
Chandanmura Panchyat Office |
