UKoom

Normally, creating a snapshot comprise of these steps; 1. create databse link create database link TEST_DBLINK.US.ORACLE.COM connect to AMICOS identified by AMICOS using 'test'; 2. create snapshot Create snapshot  Test_SnapShot REFRESH COMPLETE START WITH SYSDATE NEXT SYSDATE+1/24 as select * from A_Table@TEST_DBLINK If  we want to refresh snapshot FAST, we need to do these two steps: 1. create ...

// // The table you ...

Use the CREATE DATABASE LINK statement to create a database link. A database link is a schema object in one database that enables you to access objects on another database. The other database need not be an Oracle Database system. However, ...

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 ...

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