UKoom

It sure is easier to remove oracle products than to add them.... The method suggested, using Oracle Universal installer to remove the product, is the safest method, and the only reliable means if you have several different ORACLE-HOMEs on you server. However, if you want to remove all oracle software from your ...

SQL> create table tst (col varchar2(10), row_chng_dt date); Table created. SQL> insert into tst values ('Version1', sysdate); 1 row created. SQL> select * from tst ; COL ROW_CHNG ---------- -------- Version1 16:10:03 SQL> drop table tst; Table dropped. SQL> select object_name, original_name, type, can_undrop as "UND", can_purge as "PUR", droptime ...

Can one import tables to a different tablespace?ITPUB个人空间g!] g4`6k;W)a Oracle offers no parameter to specify a different tablespace to import data into. Objects will be re-created in the tablespace they were originally exported from. One ...

Recompile the invalid objects: SET NEWPAGE 0 SET SPACE 0 SET LINESIZE 80 SET PAGESIZE 0 SET ECHO OFF SET FEEDBACK OFF SET HEADING OFF SET MARKUP HTML OFF SET ESCAPE \ SPOOL RECOMPILE.SQL select 'ALTER VIEW ', object_name, 'compile \;' from user_objects where status = 'INVALID' and object_type='VIEW'; SPOOL OFF Reference: http://www.oracle-base.com/articles/misc/RecompilingInvalidSchemaObjects.php

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

SQL Server: SELECT TOP 10 product, descr, email FROM products ORACLE:...

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