Hi,
Here goes my system config.
>
Development Server
OEL 5.0
DB Version
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
>
I added a datafile to a user TS, and then executed following query
select * from v$datafile;
there is a column called "Creation Date", it shows me today's date for this new datafile, but shows 30th June 2005 for other data files which are member of System, sysaux TS ... so my question is why does it shows that old date for system datafiles ? is it because Oracle software was packaged by Oracle corp. in 2005 ?
Also second question is since i am new to Oracle and have been using mostly sqldeveloper tool instead of sqlplus , is it true to say that at some point of time i will have to use sqlplus , since sql developer doesn't support executing ALL commands / queries like for example when i execute 'archive log list' in sql plus it works fine where as the same doesn't work in sql developer tool , so i am just trying to understand that am i doing something wrong , or is my assumption correct that i should also start to learn how to use sqlplus ?
Regards
Learner