Home » RDBMS Server » Server Administration » ORA-01482: unsupported character set in 10g with gather stats (10.2.0.1 Windows 2003 x64 Sp1)
ORA-01482: unsupported character set in 10g with gather stats [message #356107] |
Wed, 29 October 2008 10:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
jrmtl
Messages: 27 Registered: February 2006
|
Junior Member |
|
|
Hi all,
I was just wondering if this error is common and what i would need to change without affecting the whole database.
We are on still on ithe base install release10.2.0.1 and I only get the issues in one environments tables and not another?!
Can it be data related ?
(TRACEFILE)
*** 2008-10-21 22:00:20.156
*** ACTION NAME:(GATHER_STATS_JOB) 2008-10-21 22:00:20.156
*** MODULE NAME:(DBMS_SCHEDULER) 2008-10-21 22:00:20.156
*** SERVICE NAME:(SYS$USERS) 2008-10-21 22:00:20.156
*** SESSION ID:(111.46637) 2008-10-21 22:00:20.156
ORA-01482: unsupported character set
*** 2008-10-21 22:00:20.156
GATHER_STATS_JOB: GATHER_TABLE_STATS('"TRESOR_RRTAP"','"EMPLOYER"','""', ...)
ORA-01482: unsupported character set
*** 2008-10-21 22:00:20.266
GATHER_STATS_JOB: GATHER_TABLE_STATS('"TRESOR"','"EMPLOYER"','""', ...)
ORA-01482: unsupported character set
*** 2008-10-21 22:00:27.641
GATHER_STATS_JOB: GATHER_TABLE_STATS('"TRESOR_RRTAP"','"MEMBER"','""', ...)
ORA-01482: unsupported character set
Much appreciated
John
|
|
|
|
|
|
|
|
Re: ORA-01482: unsupported character set in 10g with gather stats [message #356346 is a reply to message #356107] |
Thu, 30 October 2008 07:45 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
jrmtl
Messages: 27 Registered: February 2006
|
Junior Member |
|
|
Hi Babu... here is the output
E:\oracle\product\10.2.0\db_1\OPatch>opatch lsinventory
Invoking OPatch 10.2.0.1.3
Oracle interim Patch Installer version 10.2.0.1.3
Copyright (c) 2005, Oracle Corporation. All rights reserved..
Oracle Home : E:\oracle\product\10.2.0\db_1
Central Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch version : 10.2.0.1.3
OUI version : 10.2.0.1.0
OUI location : E:\oracle\product\10.2.0\db_1\oui
Log file location : E:\oracle\product\10.2.0\db_1\cfgtoollogs\opatch\opatch200
10-30_07-44-33AM.log
Lsinventory Output file location : E:\oracle\product\10.2.0\db_1\cfgtoollogs\o
tch\lsinv\lsinventory2008-10-30_07-44-33AM.txt
------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 10g 10.2.0.1.
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 5695786 : applied on Mon Oct 27 12:22:50 EST 2008
Created on 26 Dec 2006, 13:58:41 hrs
Bugs fixed:
5695786, 5694720, 5689937, 5500954, 5490936, 5490846, 5298887, 4939157
5092688, 4900129, 5366688, 5227899, 5109749, 5239701, 5225798, 5242648
5059261, 5049088, 5049080, 5059258, 4712199, 4901291, 5012796, 4447168
4537790, 4745114, 4458790, 4698156, 4916909, 4570793, 4523125, 4644048
4748797, 4671216, 4751888, 4515623, 4546618, 4898338, 4767699, 4908068
4496863, 4884408, 4542082, 4923787, 4865122, 4690147, 4686909, 4619452
4690401, 3807408, 4626732, 4573573, 4868255, 4573980, 4584509, 4902585
3748430, 4754888, 4383610, 4770480, 4577670, 4667809, 4309867, 4569842
4517846, 4439465, 4114966, 4751931, 4554682, 4554846, 4529672, 4583539
4629654, 4727495, 4505011, 4562889, 4629844, 4652261
------------------------------------------------------------------------------
OPatch succeeded.
|
|
|
Goto Forum:
Current Time: Wed Aug 21 17:45:56 CDT 2024
|