ORA-01578 data block corrupted

Title: ORA-01578 data block corrupted I got ORA-01578 error while querrying info for below table. How do I fix this error? SQLSelect count(*) from GATEWAYCALLSTATS; * ERROR at line 2: ORA-01578: ORACLE data block corrupted (file # 3, block # 2683299) ORA-01110: data file 3:

Delete vs. truncate to free up spaces.

Title: Delete vs. truncate to free up spaces. I am using delete command to delete million records in several tables to free up space in tablespace. I understand delete command does not release unused spaces as truncate command but I could not use truncate to delete ALL records in table as I

RE: Delete vs. truncate to free up spaces.

/server.920/a96524/c12p arti.htm#464767 or http://tinyurl.com/362ba -Original Message- Nguyen, David M I am using delete command to delete million records in several tables to free up space in tablespace. I understand delete command does not release unused spaces as truncate command but I

RE: Unreadable time_stamp format

Try milliseconds from the epoch - 1/1/1970 select to_date('01/01/1970','mm/dd/') + ( 1069716948959 / (24*60*60*1000) ) from dual You really need to know how the timestamp column is defined by your app. Jared Nguyen, David M [EMAIL PROTECTED] Sent

RE: Unreadable time_stamp format

it. /SOAPBOX Try this: select user_name , to_date('01/01/1970','mm/dd/') + ( time_stamp / (24*60*60*1000)) from user_activity_log where rownum = 100 HTH Jared Nguyen, David M [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2003 07:54 AM

Unreadable time_stamp format

Title: Unreadable time_stamp format I need to view time_stamp column in USER_ACTIVITY_LOG table but it displays unreadable format as shown below. Is there a way to decode it to be readable? SQL desc USER_ACTIVITY_LOG Name Null? Type -

RE: Unreadable time_stamp format

; -Original Message- From: Nguyen, David M [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 4:39 PM To: Multiple recipients of list ORACLE-L Subject: Unreadable time_stamp format I need to view time_stamp column in USER_ACTIVITY_LOG table but it displays unreadable format as shown

Could not run export utility from cron job

Title: Could not run export utility from cron job I am able to run export utility from CLI manually but when I schedule it to run from cron job on SUN Solaris8 it fails to run as it does not recognize exp command. Does someone have any idea? Below is the command I run export manually. $exp

Who is querying database info using dblink

How do I check who is querying database information via database link? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Location of trace files and alert log

Title: Location of trace files and alert log How do I locate where all trace files and alert log are saved? There is no parameter setup in init.ora file. Thanks, David

RE: Perl Book

Programming the Perl DBI from Oreilly is really good for your need. -Original Message- From: Farnsworth, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Perl Book

RE: Date format is unreadable

/1970, while Oracle date arithmetic is in days. Sorry. Nguyen, David M wrote: Yes, it is a Unix timestamp. I use your syntax and I got following error. 1 select user_name,client_ip,node_name,to_date('01/01/1970','MM/DD/')+tig 2 where user_name = 'admin' 3* order by time_stamp

Date format is unreadable

I try to query a report to check user activity but I could not read date column. Is there a way to reformat the column to be readable? Date colum calls "time_stamp" as shown below. SQL desc user_activity_log Name Null? Type -

How to improve queries remotely

What is a guideline to improve remotely query using database link? Regards, David

RE: Date format is unreadable

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Snapshot refreshes are failing

the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: What to check?

. Hopefully one of these will give a hint about where to look for the cause. Regards, Mark. Nguyen, David M To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] david.m.nguye cc: [EMAIL PROTECTED] Subject: What to check? Sent by: [EMAIL PROTECTED] om 01/03/2003 08

What to check?

Title: What to check? Someone writes a SQL script to dump a table on three different database on three different Solaris8 machines, he complaines one of machines took 6 hours to dump a table while other two's only take one hour. He asks me to investigate why. I log into the machine in

RE: Oracle Performance Tuning Exam

Title: RE: Oracle Performance Tuning Exam There are totally five exams we have to pass to get certified, I'd like to know which exam should I take first and what next in order?  Thanks, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent:

RE: Embeded password in script

Title: RE: Embeded password in script Thank you, Jared. I have the book you wrote and will look into it. Regards, David -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Monday, February 24, 2003 4:51 PM To: Multiple recipients of list ORACLE-L Subject: Re:

RE: Sun admininstrator

What's requirements? David -Original Message- From: John Shaw [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 5:04 PM To: Multiple recipients of list ORACLE-L Subject: Sun admininstrator I normally wouldn't post this kind of thing on this forum - but since

It takes too long to shutdown database

Title: It takes too long to shutdown database I try to bounce database by shutting it down and starting it back up but it just hang in there for almost 45 minutes trying to shut down. It is running on Solaris8, I can press Ctrl+C to interrupt it or issue a kill command to kill it but I

Upgrading from 8.1.5 to 8.1.6

after upgrading? Regards, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Export generates ORA-04031 error

calling SYS.DBMS_REFRESH_EXP_SITES.schema_info_expacle Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Embeded password in script

following steps to shutdown database, how do I code these steps in the script? $svrmgrl SVRMGRLconnect internal SVRMGRLshutdown Thanks in advance, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services

RE: Embeded password in script

Oracle. Nguyen, David M [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] o.com cc: Sent by: Subject: Embeded

RE: Upgrading from 8.1.5 to 8.1.6

? Is there any files being linked to the old version after upgrading? Regards, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California

Updating error

- parent key not found Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Which rollback segment is currently active?

Title: Which rollback segment is currently active? I have three rollback segments which all show ONLINE. I want to drop one of them but I need to know which one should I drop. How do I find out which one is good to drop? SVRMGR select segment_name,owner,tablespace_name,status from

RE: Replication question

see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services

Replication question

replicate from the master database? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Comparing between two tables

-- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

ORA-04031

, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E

RE: Increase size of data files and rollback segments

to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Increase size of data files and rollback segments

. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when

Increase size of data files and rollback segments

How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Thanks,David

Changing column format

: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

Monitor replication via OEM

Title: RE: Experience with Quest Shareplex I install oracle enterprise manager on windows NT, create an event to monitor replication then stop replication on slave database, check alarm from OEM but I don't see any alarms. Does anyone use OEM to monitor replication? If so, please

RE: How to fix ORA-03113 error

= 483 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

How to fix ORA-03113 error

of thread 1 LGWR: terminating instance due to error 204 Instance terminated by LGWR, pid = 483 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET

RE: stupid RMAN question

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Password is not case sensity and uncrypted

Is password case-sensity in oracle database? And how do I encrypt it as it shows unencrypted in password field? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Tool to load data

use a wizard to create the CTL file, then you can later just re-load that file and execute the load. -Original Message-From: Nguyen, David M [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 02, 2002 12:45 PMTo: Multiple recipients of list ORACLE-LSubject: Tool

table_changes

I heard people said we can check table_changes to make sure data is actually loaded into table using sqlldr. If this is true, how do I verify data is loaded by looking table_changes? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET

Data file size growing causing high disk space.

I have data files save under /export/home/oradata directory and this directory shows 100% full disk space because of the growth of these files. What should I do? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED

RE: Data file size growing causing high disk space.

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

How to load text file into database table

://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

Copy one user's table to another user's table

How do I copy all data in one user's table to another user's table? Regards, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

How to speed up import

I do backup database nightly using export utility. When I restore database using import, it takes more than 6 hours to finish. Is there a way to speed up import process? Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M

Disadvantages/advantages of user_ind_columns

I found a column_name "NPA_XXX"created in many many places in user_ind_columns. Does this have any disadvantages or advantages to oracle database such as slowing down SQL query or update table? Thanks,David

RE: It took more than an hour to update 10,000 records

were CPU parse time. The increased run time also resulted in 3x as many buffer busy waits for other sessions trying to hit the same table. HTH Jared Nguyen, David M [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/13/2002 01:34 PM Please respond to ORACLE-L

It took more than an hour to update 10,000 records

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: It took more than an hour to update 10,000 records

and npa_id = 201 and lata_id = 224; Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: It took more than an hour to update 10,000 records

= 224; Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Times_tamp column unreadable format

Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Display all privilleges belong to user

How do I display all privilleges belong to an user? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

How to?

Using LogMiner to read redo log, how do I tell a transaction is modified by which user and where user logins from like what columns in LogMiner should tell me this kind of information? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M

RE: How to?

-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Increase size of REDO log

How do I increase size of redo logs and how do I create additional redo logs? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Increase size of REDO log

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: LogMiner errors

Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Redo log

Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

LogMiner errors

-06512: at SYS.DBMS_LOGMNR, line 42 ORA-06512: at line 2 Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

How to read REDO log

Title: RE: ORA-27101 Error Can I setup LogMiner to read REDO log of Oracle8.0.5? Someone tells me LogMiner only works for Oracle8.1 or above, is it correct?Is there another tool to read REDO log besides LogMiner? Thanks,David

How to make SQLLDR to run faster?

://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

SQL question

How do I list all user accounts created in a database? And how do I list all user table indexes? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Errors with web forms using DBI

. Is there a way to fix these problems? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Replication errors

: at SYS.DBMS_IREFRESH, line 450 ORA-06512: at SYS.DBMS_REFRESH, line 182 Thanks, David Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Solaris 2.8

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Currently log-in users

How do I check who is currently logging into database, where he is accessing from and what he is doing? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: OEM Error On Unix

: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send

RE: Currently log-in users

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: OEM Error On Unix

containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network

RE: Export taking to long

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

How to tune SQL and CPU usage

of running oracle processes? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Ticket tracking system

, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Ticket tracking system

ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: How to calculate time using SQL

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: How to calculate time using SQL

-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: How to calculate time using SQL

Thanks for your advices, Stephane. David -Original Message- Sent: Monday, April 01, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Nguyen, David M wrote: Jack, How about substracting a system date with a database replication date to get difference of time? Can you

Displaying time zone

How do I display time zone in date format using SQL? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Free scripts

I try to find some scripts (PL/SQL package) to monitor my oracle database such as tablespace, rollback segment, etc. Does someone know a website that has this? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED

Re-open a ticket that is closed using SQL

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

LIKE and % operator

subject like '%general%'; no rows selected. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

How to restart SNMP daemon process

How do I restart a daemon process on UNIX if it dies? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

How to import PDF files into Oracle database

Is is possible to store PDF files in oracle database to allow user accesses the files, open it and read it? If so, please advise how. I am using oracle8i with DBI running on Solaris8. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M

How to change timezone on unix

How do I change timezone on unix? Thanks, David

Script stops running.

); } -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Oracle process causes High CPU

to object), addr: 0x 7f6c7d78 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x 7f6c7d78Background_Core_Dump = FULL Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network

Oracle trace file on/off

Hi all, How do I find out if someone is running trace on oracle database and how do I turn trace off? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858