http://www.orafaq.com/node/2 Default Temporary Tablespaces: In Oracle 9i and above, one can define a Default Temporary Tablespace at database creation time,...
Read More » Oracleselect * from v$datafile;select * from dba_data_filesselect * from dba_tablespaces ***** 5 STAR *****http://www.oracle-wiki.net/startsqldisplayspcusgdf SET PAUSE ONSET PAUSE...
Read More » Oracleget character set in Oracle DatabaseSQL> SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ; or SQL> SELECT * FROM...
Read More » Oraclehttps://docs.oracle.com/cd/B28359_01/server.111/b28310/dba007.htm#i1006853 Password file is only used to authenticate for SYSDBA,SYSOPER and SYSASM. Not for the normal user. password file...
Read More » Oraclehttp://www.orafaq.com/faq/what_are_the_difference_between_ddl_dml_and_dcl_commands DDL, DML and DCL commands DDL Data Definition Language (DDL) statements are used to define the database structure or...
Read More » Oraclehttp://www.oracle-dba-online.com/managing_redo_logfiles.htm Viewing Information About LogfilesTo See how many logfile groups are there and their status type the following query. SQL>SELECT...
Read More » Oraclehttp://ss64.com/ora/startup.html STARTUP Startup a database instance. This is a SQL*Plus command (not part of standard SQL) Syntax: STARTUP [FORCE] [RESTRICT]...
Read More » Oraclehttps://www.bnl.gov/phobos/Detectors/Computing/Orant/doc/network.804/a48385/ch5.htm Using the Listener Control UtilityThe network listener establishes listen endpoints on a machine. These listen endpoints are well-known addresses...
Read More » OracleDatabase Versus Instance The database is the data on disk, stored in operating system files (or possibly, under Unix, in...
Read More » Oraclehttp://www.dba-oracle.com/t_rename_database_oracle_sid.htmA new method for a database rename instance For Oracle9i and beyond, Oracle author Dr. Tim Hall has this procedure...
Read More » Oracle