Oracle
How to convert milliseconds to date string in Oracle SQL
2554
If you store the date in milliseconds, for instance, 1126483200000, its milliseconds since January 1, 1970, 00:00:00 GMT in Oracle, we can see, even one
ASJAVA.COM
Oracle
Oracle error: DRG-10758: index owner does not have the privilege to use file or URL datastore
096
Oracle Error :: DRG-10758 Index owner does not have the privilege to use file or URL datastore Cause. Error details: When you tried to create an index
ASJAVA.COM
Oracle
Oracle DBA_TABLESPACES: List All Tablespaces
2306
DBA_TABLESPACES Introduction The view Oracle DBA_TABLESPACES describes all tablespaces in the database. so if you select it, it returns the list of the
ASJAVA.COM
Oracle
Oracle: Extend or Decrease the Size of a Tablespace
066
The size of Tablespace is combination of  size of ALL individual datafiles, You can enlarge a database in four ways: Add a datafile to a tablespace You
ASJAVA.COM
Oracle
Oracle Tablespaces Usage Query: Bytes used, Bytes free, Percent used
135
Example query to check free,used space and Percent used per tablespace: select a.TABLESPACE_NAME, a.BYTES bytes_used, b.BYTES bytes_free, b.
ASJAVA.COM
Oracle
Create Tablespaces in Oracle
0102
A tablespace is a storage location where the actual data underlying database objects can be kept, it is a logical storage unit within an Oracle database
ASJAVA.COM
Oracle
Oracle import/export Utilities: imp and exp
073
Oracle’s export (exp/expdp) and import (imp/impdp) utilities are used to perform logical database backup and recovery. When exporting, database objects
ASJAVA.COM