OracleXEの導入結果
SQL> select instance_name,status,version,edition from v$instance; INSTANCE_NAME STATUS VERSION EDITION xe OPEN 10.2.0.1.0 XE
SQL> select * from v$version; PL/SQL Release 10.2.0.1.0 - Production CORE10.2.0.1.0Production TNS for 32-bit Windows: Version 10.2.0.1.0 - Production BANNER Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product SQL> select * from v$nls_parameters; PARAMETER VALUE NLS_LANGUAGE JAPANESE NLS_TERRITORY JAPAN NLS_CURRENCY \ NLS_ISO_CURRENCY JAPAN NLS_NUMERIC_CHARACTERS ., NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT RR-MM-DD NLS_DATE_LANGUAGE JAPANESE NLS_CHARACTERSET AL32UTF8 NLS_SORT BINARY NLS_TIME_FORMAT HH24:MI:SSXFF NLS_TIMESTAMP_FORMAT RR-MM-DD HH24:MI:SSXFF NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR NLS_TIMESTAMP_TZ_FORMAT RR-MM-DD HH24:MI:SSXFF TZR NLS_DUAL_CURRENCY \ NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE SQL> select file_name,bytes from dba_data_files; FILE_NAME BYTES C:\ORACLEXE\ORADATA\XE\USERS.DBF 104857600 C:\ORACLEXE\ORADATA\XE\SYSAUX.DBF 450887680 C:\ORACLEXE\ORADATA\XE\UNDO.DBF 94371840 C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF 356515840 SQL> select file_name,bytes from dba_temp_files; FILE_NAME BYTES C:\ORACLEXE\ORADATA\XE\TEMP.DBF 20971520 SQL> select username,account_status from dba_users; USERNAME ACCOUNT_STATUS SYS OPEN SYSTEM OPEN ANONYMOUS OPEN MDSYS EXPIRED & LOCKED OUTLN EXPIRED & LOCKED DIP EXPIRED & LOCKED TSMSYS EXPIRED & LOCKED FLOWS_FILES EXPIRED & LOCKED CTXSYS EXPIRED & LOCKED DBSNMP EXPIRED & LOCKED FLOWS_020100 EXPIRED & LOCKED XDB EXPIRED & LOCKED HR EXPIRED & LOCKED
