Tag Info

New answers tagged

0

Use a query to generate a drop type script [in SQL Plus]: set lines 132 set head off set pages 0 spool drop_types.sql select 'drop type '||type_name||';' from user_types; spool off Then execute the script in SQL Plus: @drop_types.sql


2

select empid, empname, sum(sal) as sal, sum(comm) as comm from emp group by empid, empname;


2

Based on your comments, here is a maybe faster version: SELECT TABLE1.* , TABLE2.COL1 , TABLE2.COL4 FROM TABLE1 INNER JOIN TABLE2 ON TABLE1.COL4 = TABLE2.COL2 WHERE TABLE1.COL1 IN ('1','TEXT','HO TED') AND TABLE1.COL2=1800 AND TABLE1.COL3>=100 AND TABLE2.COL1=10519198 AND TABLE2.COL3=('TEXT') And you need to create a tree-index on ...


1

There are other parameters that can influence execution plan, like PGA size, number of CPUs, disk I/O speed, different sample sizes when you are gathering statistics, index modifications, different system load, different block sizes and so on and on. Just too many to check them all. You could try sqlTXplain or sql Health Check Oracle's tools to find the ...


0

Restore should not be an issue. Both Linux and Windows are little endian so you are OK there. Are you using rman? You can always recreate the database on Windows and perform an export/import to the new database. Ideally you want to just restore using RMAN directly to the Windows server. Check out Chapter 4 of Oracle® Database Backup and Recovery Advanced ...


2

For me the wording "Distributed transactions are not supported for temporary tables" is clear: In a distributed transaction you should not use statements that involve temporary tables. This means you should not even insert into an already created temporary table in an XA transaction. Of course it can happen that it works but nevertheless it is not supported ...



Top 50 recent answers are included