How to check tablespace creation time in oracle 11g

Let we discuss how to check the tablespace creation time in Oracle 11g?

*By using this query we will get the tablespace name, status and creation time

 


SQL>  col FILE_NAME for a45
SQL>  col tablespace_name for a10
SQL>  col status for a15
SQL>  col creation_time for a15
SQL>  set lines 999 pages 100
SQL> select a.File_name,a.Tablespace_name,a.status,b.creation_time from 
dba_data_files a inner join V$datafile b on a.file_name=b.Name 
group by a.File_name,
a.Tablespace_name,a.status,b.creation_time ;

FILE_NAME                                     TABLESPACE STATUS          CREATION_TIME
--------------------------------------------- ---------- --------------- ---------------
C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF  SYSTEM     AVAILABLE       27-AUG-17
C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF   USERS      AVAILABLE       27-AUG-17
C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF  UNDOTBS1   AVAILABLE       27-AUG-17
C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SAM01.DBF   SAM        AVAILABLE       19-SEP-17
C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF SYSAUX     AVAILABLE       27-AUG-17

 

 

Popular posts from this blog

Error in starting the service (OracleMTSRecovery)

Image
 While i am installing the oracle 11g database i got the popup message " Error in starting the service.The service OracleMTSRecoveryService was not found " i just ignored the message and continue my installing but the installation was successful with errors, so once again i started the installation this time also i got the same error pop up and  searched on google to resolve this issue by using below steps S-1: S-2: press " Ctrl + r " then type " regedit " you 'll got this screen and  then choose " HKEY_LOCAL_MACHINE "   S-3:  Then choose " SYSTEM "  => " ControlSet001 " => " Services " => " OracleMTSRecoveryService "       S-4:                 After   choosing the " OracleMTSRecovery " we can see the " imagepath " which was mentioned below Double click the image and change the path where we are going to install the software(like be...
Read more

ORA-39000, ORA-39143 ORA- 31619 invalid dump file in datapump

Today i am tired to export  one schema (hr) from the one database  into another database  ( import schema ) so i created one directory which is called "ram" grant read and write access to  the system user ,then i started export the schema (hr) from production  while i did the export of hr schema the job was successful after that i did import schema like below expdp : C:\>expdp system/oracle directory=ram schemas=hr dumpfile=hr.dmp logfile=hr.log ...... ...... Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_02 is:   C:\datapump\HR.DMP Job "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully completed at 13:23:40 impdp: C:\>impdp system/oracle directory=ram remap_schema=hr:scott dumpfile=HR.DMP logfile=hr.log it through an error like below . ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31619: invalid dump file "C:\datapump\hr.dmp" ORA-27091: unable to queue I/O ORA-27070: async read/write failed OSD-04006: ReadFile() failu...
Read more

ORA-00439: feature not enabled: Flashback Database

Today we discuss ORA-00439: feature not enabled: Flashback Database ora error This is the test database I was performing flashback on the dummy table to deleted some rows  and tried to do the flashback above-mentioned Error S-1: SQL> flashback table hr.rg to timestamp to_timestamp('2018-04-18 12:57:00','YYYY -MM-DD HH:MI:SS'); flashback table hr.rg to timestamp to_timestamp('2018-04-18 12:57:00','YYYY-MM-D D HH:MI:SS') * ERROR at line 1: ORA-00439: feature not enabled: Flashback Table S-2: To view version of my oracle SQL> select * from V$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production PL/SQL Release 11.2.0.2.0 - Production CORE    11.2.0.2.0      Production TNS for 32-bit Windows: Version 11.2.0.2.0 - Production NLSRTL Version 11.2.0.2.0 - Production S-3: to features of my oracle edition SQL> SELECT Parameter, Valu...
Read more