Oracle

EXP-00056: ORACLE error 932 encountered
Hello I have an oracle database 10.2.0.1.0 running on Solaris 5.8 which I imported the data from a different version 10.1.0.4.0, the Import was done fromuser=test touser=test, after I tried to export the same data out and I keep getting these error messages EXP-00056: ORACLE error 932 encountered ORA-00932: i... 9 Nov 2005 21:42

RAC internals - GLOBAL ENQUEUE SERVICES DEADLOCK DETECTED
We're encountering many of "Global Enqueue Services Deadlock detected" messages in the alert log of one of our database instances (two node RAC database) together with quite big global cache cr request waits in STATSPACK report. The problem is that the only other available information is trace file that looks like:... 11 Nov 2005 08:16

SP2-0332: Cannot create spool file
I am trying to run the following script CreateMovies.sql from sql plus. SP2-0332: Cannot create spool file. DROP USER MOVIES CASCADE * I am getting the above error and no clues what it means. any has clue? SK. CREATEMOVIES.SQL***************** SET ECHO OFF UNDEF DBNAME PROMPT WHAT IS THE DATABAS... 31 Oct 2005 00:38

Adjust AWE_WINDOW_MEMORY value
Hi, Context: OS Windows 2003, 8GB RAM, 4CPU Ref: Metalink note 225349.1 I'm trying to adjust the AWE_WINDOW_MEMORY value (set as key into the registry). I have set the AWE_WINDOW_MEMORY to 1GB (=1,048,576 Bytes) As describ into the Metalink note 225349.1: "If the # of Map misses is relatively high, or par... 9 Nov 2005 21:42

Default value for log_buffer parameter
Using Oracle 10.2.0.1.0 on Solaris 9. Value for parameter sga_target = 1G. I let the value for parameter log_buffer default. SQL> show parameter log_buffer NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_buffer ... 28 Oct 2005 10:37

vmware + RAC 10g + windows
Hy, i want to test a single node 19g RAC (10.1.0.2) under a vmware. after installing the OS ( W2K SP4), the CRS, the DB, i try tu run the vipca but it fail with the error : PRKH-1010 : Communication avec les services CRS impossible. [OCR Error(Native: prsr_initCLSS:[21])] does anyone try all this with succes... 26 Oct 2005 05:28

Error ORA-12547: TNS: lost contact
Hi all, I' ve patched Oracle 9.2.0.1.0 on Tru64 with patchset for Oracle 9.2.0.6. After I have installed it launching the runInstaller in tha Patch directory, i try to connect to sqlplus for the post installation tasks. But appears the error: ORA-12547: TNS:lost contact Here is my tnsnames.ora: OR... 24 Oct 2005 07:04

Error ORA-12547 after patching Oracle 9i on Tru64
Hi all, I' ve patched Oracle 9.2.0.1.0 on Tru64 with patchset for Oracle 9.2.0.6. After have installed it launching the runInstaller in tha Patch directory, i try to connect to sqlplus for the post installation tasks. But appears the error: ORA-12547: TNS:lost contact How can I solve, please? Antonio ... 24 Oct 2005 07:04

Oracle - Column Order
Hi, Is there a way to change the order of the columns in a table? I know that you can change the name via using the COL$ dictionary table. Is there also a sneaky way like that to change the order of the columns? Thanks, Arthur ... 19 Oct 2005 02:02

FORALL and BULK COLLECT INTO together in SELECT statements
I have a procedure implementation below. Please suggest an efficient WORK AROUND. CREATE OR REPLACE TYPE DnisNumberList IS TABLE OF CHAR(11); / CREATE OR REPLACE TYPE DateList IS TABLE OF DATE; / CREATE OR REPLACE TYPE NumberList IS TABLE OF NUMBER; / PROCEDURE replace_dnis_list ( user_name IN ... 18 Oct 2005 07:14