Oracle

Export hangs with: "exporting cluster definitions"
Export hangs on "exporting cluster definitions" Summary: Export hangs, the terminal-output shows "exporting cluster definitions". The exp session does not request any lock. The DB has no lock-request at all (i.e. no blocking). The exp session holds a "library cache pin" Killing the exp session will not remove t... 20 Sep 2005 09:08

SQLLDR fixed format and number format
Hi NG, the following situation: I have a datafile with following format: Aug 05 97.865 97.865 0.000 97.870S 97.865 97.950 97.665 97.865 13 N/A 0| 202 20,418 -164 [newline] Sep 05 97.865 97.860 0.000 97.865 97.860 97.995 94.290 97.860 20... 19 Sep 2005 16:37

dbms_stats & analyze table
Pls help I have a DBA role privileges. When I try to perform DBMS_STATS.GATHER_INDEX_STATS on an index which belong to other user, I encounter insufficient privileges. But I can perform analyze table / index without any problem. ... 16 Sep 2005 12:04

Unicode problem and ORA-12899 error!
Hi all, we had a database which its nls_characterset was WE8MSWIN1252 so we could not save non-Latin data there so we reinstall it with AL32UTF8 characterset. We run a script that creates all structures and procedures and ....But now when we try to do an insert in a varchar2(30) or char(18) column it raises ORA-... 15 Sep 2005 16:00

How to find Column name - ORA-01438: value larger than specified precision allows
Hello I have a very large table with many columns that can cause this. Input is coming through external application integration and we do not have control on code that inserts data in our table. We can however change precision in the table. Problem is that I can not find a way to get name of offending column. ... 14 Sep 2005 18:19

Oracle 10G Schedule Backup Fails
I'm using OEM 10G to schedule a backup with my username which has sysdba privileges. The backup fails with the message: Unable to perform the backup because the database is closed. I know the database is up and running because I can log into it. Any ideas why this isn't working? Any place to point me to that w... 13 Sep 2005 20:37

RMAN crosscheck problem
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Can someone explain to me what's going on here? I recently queried my RMAN catalog and found a lot of old backups, much older than the configured retention period of 30 days. I run a "delete obsolete" once a week so I was surprised to find things well over a year old... 13 Sep 2005 18:03

CBO influences
Platform: 8.1.7 and 9.2.0.1 on various Win2k or Win2003 Last week a developer brought me a query that was running satisfactorily in prod (8.1.7), but took 45 minutes in test (9.2.0). As it happens, we are in the middle of transitioning a group of databases from 8i to 9i, and so have several copies of this data... 15 Sep 2005 09:12

TIMEOUT ON CONTROL FILE ENQUEUE
Oracle version 7.3.4.5.0 on HP-UX 10.20 (yes I know it's ancient :-) Last night (perhaps during a hot backup, I'm not certain yet), our Oracle instance came to a halt. The trace file has this, and: ORA-00600: internal error code, arguments: [2103], [0], [0], [1], [900], [], [], [] ORA-00447: fatal error in bac... 13 Sep 2005 06:35

What happen if I resize a datafile during RMAN backup?
Hi All, I know if I am doing RMAN backup and then one file do an "autoextend" , then RMAN later on will complaint. RMAN backup will fail. But I never do a RESIZE on a datafile while RMAN backup?(probably RMAN fail ...) Just curious , do anyone know what will happen? I know I could similate the situation.... 8 Sep 2005 20:55