Oracle
in [SQL]
|
How to reorganize a tablespace within Oracle Enterprise Manager 10g Hi, I tried to reorganize a tablespace (oracle 10.2.0.3) an got the warning: Reorganization includes a table with a LONG column. To support reorganization of tables with LONG columns that are greater than 32KB the external procedure MGMT$REORG_MOVELONGCOMMAND must be configured properly. It has been determine... 26 Jan 2010 05:26
40 Fast Facts about Oracle http://www.baselinemag.com/c/a/Business-Intelligence/40-Fast-Facts-about-Oracle-776052/ Quite interesting ;-) Matthias ... 27 Jan 2010 13:43
dbms_stats hint? While tracking down an ora-1652 error today I noticed two very similar statements that were running just prior to the error. They contained a dbms_stats hint and looked something like the one below. What is the dbms_stats hint and can I safely assume it was the stats job that generated these statements? BTW these s... 26 Jan 2010 15:29
Radiohead lyrics in Oracle RDBMS code Hi. strings oracle.exe | grep radiohead Starting at least at 10.2.0.1, function kfasSelfTest_update() (located in kfas.o) use Radiohead lyrics to test... something related to ASM probably. Schematic pseudocode: #define STRING "I'm a creep, I'm a winner, what the hell am I doing here.I don't belong here -... 5 Feb 2010 17:18
10rR2 automatically re-creates missing TEMP files I've done following test: - Brought database down using 'shutdown abort' - Renamed temp files to .bak - Started database using 'startup' Basically I wanted to know whether Oracle will complain about missing temp files or it will ignore them and then I'll be able to add them manually. Instead Oracle re-created ... 21 Jan 2010 18:01
SQL to get total count for each colon delimited entry hi, I've a table with the following structure and data, SQL> desc datcon Name Null? Type ------------------------------------------- -------- ------------------------------------ ID NUMBER CODE ... 23 Jan 2010 08:43
Run 32-bit and 64-bit listener at the same time on W3K 64-bit I have Oracle 10.2.0.4-64 bit running on W3K-64-bit. Now I need to run a 32-bit 9.2.0.5 (yes I know, ouch) on this box. I cannot get the listener to work. I use batch file to specifically point to the 9.2 environment, but for some reason it points to the 64-bit version. Any clues? E:\dbscripts>rem set orac... 25 Jan 2010 13:55
Is AskTom Down...Again? I've been getting the Oracle Application Express Login page lately. Anyone else having issues? ... 19 Jan 2010 13:29
How to release space Hi I have a big table with 2 clob columns I have to truncate this table I did: truncate table blabla reuse storage; after I did: alter table blabla deallocate unused; but it doesn't free space allocated for the LOBSEGMENT's how can I get the released space ? Thanks in advance 9.2.0.6 ... 18 Jan 2010 18:46
Oracle 11g OCA/OCP Exams Preparing for my Oracle 11g OCA/OCP Exams. I welcome any suggestion and help from anyone please. --- news://freenews.netfront.net/ - complaints: news(a)netfront.net --- ... 19 Jan 2010 13:29 |