UKoom

There are two kinds of timezone: 1. DBTIMEZONE you can set the time zone for database by "alter database set time_zone='+08:00'". To make this take effect, you should reboot the database. But if you have a column that is of TIMESTAMP WITH ...

Oracle In vs Exist the two are processed very very differently. Select * from T1 where x in ( select y from T2 ) is typically processed as: select * from t1, ( select distinct y from t2 ) t2 where t1.x = t2.y; The subquery is evaluated, distinct'ed, indexed (or hashed or sorted) and then joined ...

Syntax: FOR record_index in cursor_name LOOP {.statements.} END LOOP; You would use a CURSOR FOR Loop when you want to fetch and process every record in a cursor. The CURSOR FOR Loop will terminate when all of the records in the cursor have been fetched. Here is an example of a function that uses a CURSOR ...

When you drop a materialized view, Oracle Database does not place it in the recycle bin. Therefore, you cannot subsequently either purge or undrop the materialized view. The keyword SNAPSHOT is supported in place of MATERIALIZED VIEW for backward compatibility. Prerequisites The materialized view must be in your own ...

I have not yet seen enough of 5.1 in real-world production environments. MySQL 5.1 rease as “GA” seems to be the most controversial to date. It ...

connect database using port: Assign tcp port:

1)    Take the tablespace offline ALTER TABLESPACE tablespace-name OFFLINE; 2)    Use the OS to Move the tablespace to the new location 3)    Run the following command: ALTER TABLESPACE tablespace-name RENAME DATAFILE ‘OS path to old tablespace\tablespace-datafile- name.dbf’ TO ‘OS path to new location\tablespace-datafile-name.dbf’; 4)    Take the tablespace back online ALTER TABLESPACE tablespace-name ONLINE; If the following error ...

I. Download patch set p5337014_10203_WINNT.zip II. To install the Oracle Database 10g patch set interactively: Log on as a member of the Administrators group to the computer on which you are going to install Oracle components. If you are installing on a Primary Domain Controller or a Backup Domain Controller, log on ...

Sqlnet.ora is a text file that provides SQL*Net with basic configuration details like tracing options, default domain, encryption, etc. This file can be found in the ORACLE HOME\NETWORK\ADMIN directory. It can be used to enable/disable trace. Reference: http://www.orafaq.com/wiki/Sqlnet.ora#Sample_sqlnet.ora_files http://users.handysoft.co.kr/~jelong/net_para.txt http://www.dba-oracle.com/t_tns_12560_protocol_adapter_error.htm

The error "TNS-12560: TNS: protocol adapter error" is usually related to a configuration issue with the listener: TNS-12560 TNS:protocol adapter error Cause: A generic protocol adapter error occurred. Action: Check addresses used for proper protocol specification. Before reporting this error, look ...