 | | | Oracle List | | I don 't have any issues
-----Original Message-----
From oracle-l-bounce@(protected) [mailto oracle-l-bounce@(protected)]
On Behalf Of ryan_gaffuri@(protected)
Sent Wednesday October 03 2007 3Tom
> Thanks to Alvaro Jose Fernandez & Ric Van Dyke this is solved. The DENSITY
> and CLUSTER FACTOR values in the user_tab_columns for my database table had
> bad values. These values are calcuTom
You might also want to check the num_distinct column of user_tab_columns to see if that 's a realistic number. I 've had situations where it was really low (like 400 when there were millions of dI searched Oracle Metalink for any new patches required for Nov 4 Sunday
DST but did not find anything.
Have anyone found any new patches required for that weekend for any of
Oracle 10.2.0.2 OAS OWhat is 70111?
Could be either 1 nov 1970
Or 11 januari 1970
With no way to distinguish based on this entry alone
-----Original Message-----
From oracle-l-bounce@(protected) [mailto oracle-l-bouHarvinder
It 's a multi-step process. First load the data into a column of type
"char " (CHAR_COL). Second add a column of type "date " (DATE_COL).
Third analyze the values you have. Fourth buSQL > select lpad(to_char(input_date) 6 '0 ') from date_conv
LPAD(T
------
991123
000421
060823
000000
070930
And here we 've got it parsed out into YY MM DD. You 'll need to translate some stuff baOk this shouldn 't be too difficult. I 'm not going to give you the complete answer but here 's a good start
Here 's the setup using your test data
SQL > create table date_conv(input_date number(6) Harvinder
Are these valid dates? Some clearly aren 't ( "0 "). I can think of at least
two ways to get this loaded
1. Use a column expression (http //tinyurl.com/29k93m) within your
Sqlloader con "0 1 jan 1900
1 1 jan 1900 "
It looks inconsistent but that is the requirement since moving legacy data and it is clearly defined in the requirement.
"Also 2-digit year? Is 02 supposed to map toRyan
I use the latest version of Firefox 2.0.0.7 with MetaLink all the time. No problems at all. Specifically I was able to open an SR w/ Oracle as recently as a few days ago. No problems.
ThaHmm...so
0 1 jan 1900
1 1 jan 1900
??
Seems inconsistent to me.
Also 2-digit year? Is 02 supposed to map to 2002 or 1902??
I think you need to better understand your current dataset beforeData is in format "yymmdd " for example
991123 (23 nov 1999)
421 (21 apr 1900)
60823 (23 aug 2006)
0 (1 jan 1900)
70930 (30 sep 2007)
Default Year 1900
Default Month 1
Default Day 1
-----Original Well that depends on what those values actually represent...
Are they julian dates? Days/minutes/seconds since some epoch?
How would you convert 991123? What date does that represent? How about The stats are up to date. Yes all of the dates in the column have time
00 00 00.
Still the optimizer trace shows that this index was not even
considered I 'm also unable to get the index to be Does the directory that it 's looking for actually exist? Does your
ORACLE_HOSTNAME value match the server_name.domain?
Privileged/Confidential Information may be contained in this message or attachWe have been having alot of problems opening tars. We go to the create tar screen fill everything out. Hit next and nothing happens. Never had this problem before.
Oracle is now telling us that IE 7Hi
We have a flat file that contains a column and the values are stored as
991123
421
60823
0
70930
Now we are moving data from flat file to table and this column will be
inserted into Date dat
While on the server I have already verified that my Oracle_sid is set correctly but when I try to login to dbconsole I get with emctl start dbconsole I get
OC4J Configuration issue. /u01/app/oracI could easily recreate this tablespace but I need to get rid of the
partition first.
I 've done the offline drop but it won 't let go of the handle.
Any suggestions?
SQL > ALTER TABLE REPADM
I inherited an AIX server that has Grid Control on it. I am not sure if it was ever truly working. Is there something else I need to stop/restart to get these things operational? First I ran opmnSomeone mentioned they were thinking about ZFS and one of the SAs
pointed me to this
http //blogs.sun.com/realneel/entry/zfs_and_databases
No experience one way or the other.
Larry
************All
I have some exciting positions open at IPsoft 's HQ in Manhattan New
York and ITPL Bangalore.
New York
We are looking for senior oracle DBAs for account leadership/client
facing roles based oSteve
I would start by looking at the database-stig-v7r2.pdf which is available for download from iase.disa.mil/stigs/stig/database-stig-v7r2.pdf .
Specifically section 4 titled Database AuditinHave you considered or investigated auditing each individual account
granted DBA privs with something like...
AUDIT ALL BY <userid >
AUDIT ALL PRIVILEGES BY <userid >
Hi
Btw the scheduling latency problem is where where timed_os_statistics comes
in handy - it will populate the "OS Wait-cpu (latency) time " statistic in
v$sesstat and v$sysstat so you can actuallyHi
The session longops array is split into multiple parts each having its own
freelist and latch.
Operations on each array are protected by separate "longop free list parent "
latches ( controlled bDQpTdGV2ZSwNCg0KSG93IGFib3V0IGF1ZGl0IGFsbCBERExzIGZvciBpZHMgdGhhdCBoYXZlIERC
QSByb2xlIGFzc2lnbiB0byB0aGVtPyBXZSBkaWQgYXQNCm91ciBwbGFjZSB0byBzYXRpc2Z5IGNv
bXBsaWFuY2UuDQoNCk1heWVuDQoNCg0KDQogICAgICAgIC
Typo... Would be neat if there was a Think driver though....
--T
-----Original Message-----
From Ted Coyle [mailto oracle-l@(protected)]
Sent Wednesday October 03 2007 10 16 AM
To 'oracle-l 'The Inspector General office is breathing down our necks here and is
requesting that we audit all activities performed by anyone with DBAish
role privs. We are currently on version 9i and are current |
|
|
