RE: Why DB_Name 4 chars only.

(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: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: ANALYZE question

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

Problem with export 8.1.7 Sun

/cdwtst/exp/exp_pipe_cdwtst $OUTFILE exp $USERPASS full=y compress=n consistent=y buffer=100 file=/u013/oradata/cdwtst/exp/exp_pipe_cdwtst log=$LOGFILE -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services

Triggers are getting disabled

://www.orafaq.com -- Author: Smith, Ron L. 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

RE: Triggers are getting disabled

becomes invalid due to change to an object on which it depends, AFAIK that wouldn't set it to disabled. --- Smith, Ron L. [EMAIL PROTECTED] wrote: We have a DW that gets refreshed each night. Many of the tables are truncated. Several times during the nightly processing dozens of triggers

RE: Addit'l DBA Resources needed for Adv Rep/Dist DB?

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: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: dblink problem ( ORA-02019 )

BODY, include a line 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: Smith, Ron L. INET: [EMAIL PROTECTED

When was analyze run last?

If there a way in 7.3.4 to tell the last time analyze was run on an index? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Need improvement on Oracle Loader

-- Author: Smith, Ron L. 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

SQLLDR73 from a Win 2000 Machine

I need to run SQLLDR73 from a Win 2000 server, loading data to a 7.3.4 Unix server. I can't load 7.3.4 in the Win 2000 server. What might I need to get the load to run on the Win 2000 machine? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L

RE: SQLLDR73 from a Win 2000 Machine

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

Export 7.3.4 / Import 8.1.7

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

RE: Export 7.3.4 / Import 8.1.7

. Mark Stahlke DuhBA Denver Newspaper Agency -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 2:00 PM To: Multiple recipients of list ORACLE-L Subject:Export 7.3.4 / Import 8.1.7 I

Anyone using 8.1.7.4

I have an upgrade of Oracle 7.3.4 on NT. I hear 8.1.7.3 had a lot of bugs. Should I go with 8.1.7.4? Any experience with 8.1.7.4? Ron Smith [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network

RE: DB Size

, include a line 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: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City

Compare Schemas

://www.orafaq.com -- Author: Smith, Ron L. 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

ORA-00600: internal error code, arguments: [4400], [48]

-- Author: Smith, Ron L. 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

Export taking to long

/expimp/adprod/exp_pipe_adprod log= $LOGFILE Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Export taking to long

/expimp/adprod/exp_pipe_adprod log= $LOGFILE Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

ORA-00020: maximum number of processes (100) exceeded

I need to increase max processes but I can't log in. Can anyone tell me how to get into the database when I get ORA-00020 errors? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Rebuild Oracle Listener Service

My oracle listener service is not working on NT. Can someone send me a script to rebuild the listener service? Thanks! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

Processes hang from remote calls

the SQL session always ends? Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: ORA-00020: maximum number of processes (100) exceeded

Unix. -Original Message- Sent: Monday, April 01, 2002 8:48 AM To: Multiple recipients of list ORACLE-L Hi Ron, what o/s are you on? -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 9:28 AM To: Multiple recipients of list ORACLE

SQL*Loader-282: Unable to locate character set handle for charact

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

Oracle Exports and performance

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

TWO Task error

-- Author: Smith, Ron L. 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

RE: SOFT PARSE RATIO?

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

RE: Hundreds of schemas in one instance?

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

TWO Task error

-- Author: Smith, Ron L. 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

How's the job market?

and how tuff would it be to find a job if I needed to do so? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Anybody against using views?

we think. I can see several reasons to use views and a few reasons not to use them. I was just wondering what the rest of the group thought. Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City

Oracle Licensing - Concurrent users

both Oracle 7 and Oracle 8. Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: Oracle Licensing - Concurrent users

Thanks for the info! Ron -Original Message- Sent: Tuesday, February 19, 2002 2:41 PM To: Multiple recipients of list ORACLE-L Smith, Ron L. wrote: We have been asked to gather statistics on the number of clients using Oracle. This is being done to determine if we have sufficient

Instream SQL

I have a Unix batch script that calls a short (5 line) SQL script. Is there any way to include the SQL statements in the Unix script instead of calling the SQL? Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET

RE: Instream SQL

of list ORACLE-L I have a Unix batch script that calls a short (5 line) SQL script. Is there any way to include the SQL statements in the Unix script instead of calling the SQL? Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L

Storing Unix SYSTEM Date

. Can anyone tell me the best way to handle this? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Connecting to 8.1.7.2 with Unicode Character set

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

Instream SQL

I have a batch script running on Unix and I need to call a short SQL script (3 or 4 lines). Can someone show me the syntax to execute an inline SQL session so I can have all the code in one script? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron

RE: NT Monitoring Scripts

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: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

OUTLN

Can anyone tell me what the OUTLN user is for? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: OPS$

the difference. Can anyone help? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

OPS$

Does anyone have any information on security problems using the OPS$ account? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: OPS$

Even so, they are still limited by the permissions given to OPS$ORACLE. Right? Ron -Original Message- Sent: Wednesday, January 30, 2002 1:26 PM To: Multiple recipients of list ORACLE-L anyone can name their pc oracle and then connect in if you set remote_os_authent --- Smith, Ron L

Oracle Roles

I hate Oracle documentation on CD! Can anyone tell me where to find the definitions for the Oracle Roles? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: OPS$

AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: OPS$ anyone can name their pc oracle and then connect in if you set remote_os_authent --- Smith, Ron L. [EMAIL PROTECTED] wrote: Does anyone have any

Public Privileges on system tables?

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

RE: Operating system choice

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: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: webdba from BMC

on it. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Export 7.3.4 / Import 8.1.7?

Can I do a full export from 7.3.4 and then do a full import into 8.1.7? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: HP vs SUN for a UNIX box

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

Oracle 8.1.7 install error

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

Which Character set?

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

RE: OT -: SQL BackTrack info

to the organization or not. If possible also let me know how in the hell does it do a online object extraction from the backup. Would appreciate all your comments and recommendations Thx Gautam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET

RE: sniped sessions

Attached are the scripts we use to kill sniped sessions. This is part of a series of monitoring scripts we developed for our Oracle databases. The scripts are scheduled through Cron and run every 15 minutes. A logonid or an email address is passed to the scripts for either paging or email. In

RE: Exporting thru a pipe

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: Connection problem

-- Author: Smith, Ron L. 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

RE: NT question

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: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

PeopleSoft

://www.orafaq.com -- Author: Smith, Ron L. 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

Oracle 8.1.7 on MS 2000

Any experience with Oracle 8.1.7 on MS2000? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Thu Jan 3 11:53:22 2002 ORA-00600: internal error code, argumen

Does anyone happen to know what this error code means? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: Thu Jan 3 11:53:22 2002 ORA-00600: internal error code, arg

anyone happen to know what this error code means? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Standby Database - Log Shipping

-- Author: Smith, Ron L. 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

Parallel Server

Is anyone using Oracle Parallel Server? It that the best solution for a standby server? Any idea what it would cost? Are there any classes covering implementation? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED

Off Topic - Windows XP Dialup connection

Windows 98 and ME. Any suggestions? Thanks! Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Please help! Recover a database on another server

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

RE: Please help! Recover a database on another server

controlfile? Try using a backup controlfile as opposed to a copy of the controlfile. yes, there is a difference. --- Smith, Ron L. [EMAIL PROTECTED] wrote: We are trying to recover a database to another server. The backup was a hot backup. The files are all copied to the new server, along

RE: Please help! Recover a database on another server

of the controlfile. yes, there is a difference. --- Smith, Ron L. [EMAIL PROTECTED] wrote: We are trying to recover a database to another server. The backup was a hot backup. The files are all copied to the new server, along with the archive log that was created a few seconds after

RE: SQL Server E-mail List

may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: Unix Cron Job

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: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Oracle Open World

Just thought I would ask. How does everyone feel about Oracle Open World this year. Will attendance be down? Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City

RE: Physical access to servers for maintenance

://www.orafaq.com -- Author: Smith, Ron L. 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

RE: TOAD DBA Module

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

Physical access to servers for maintenance

to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron

RE: Physical access to servers for maintenance

it. Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: Oracle error after recovery

// of the other instance was dumped to the trace file. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Oracle Recovery from Cold backup.

://www.orafaq.com -- Author: Smith, Ron L. 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

RE: Oracle Recovery from Cold backup.

files in log archive destination directory, which is defined in init.ora, you don't have to do anything but type 'auto' while doing recovery. Oracle will automatically apply all necessary archive log files and then you need to open database. Smith, Ron L. [EMAIL PROTECTED] wrote: I have

Oracle error after recovery

systems, database cannot be mounted shared. // *Action: Shutdown the other oracle instance and try again. The name // of the other instance was dumped to the trace file. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED

RE: Copy Oracle's binary.

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

RE: Determining Oracle status

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: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Subtract 1 month from current date

Can someone tell me how to subtract 1 month from the current date? Also, where can I find answers and examples to this type of coding question? Thanks! Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L

RE: test schema from prod

: Smith, Ron L. 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

How to subtract 1 from current month

: Smith, Ron L. 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 an E

RE: Subtract 1 month from current date

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

RE: Subtract 1 month from current date

? Also, where can I find answers and examples to this type of coding question? Thanks! Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED

Is Virus protection software safe on an NT / Oracle server?

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

Hanging processes on NT

://www.orafaq.com -- Author: Smith, Ron L. 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

RE: STOP THE PRESS!!

that can be done against terrorism is to go on with our lives and keep fixing oracle problems. God and Larry Ellison know that there are many. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Delete Alertlog on NT

Is there any problem deleting the alert log on NT while the instance is up and running? V7.3.4 - 8.1.6 Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Unique contraint violation

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

RE: Unique contraint violation

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

Open World Entertainment

Does anyone know what the Wednesday night entertainment will be at Oracle Open World this year? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

New (sort of) Oracle parameters

-- Author: Smith, Ron L. 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

RE: New (sort of) Oracle parameters

-- Author: Smith, Ron L. 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

RE: New (sort of) Oracle parameters

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

RE: Urgent -- pipe import ???

') and in the message BODY, include a line 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: Smith, Ron L. INET: [EMAIL

07_DICTIONARY_ACCESSIBILITY

Does anyone have any experience and or info on the 07_DICTIONARY_ACCESSIBILITY parameter? Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: Urgent -- pipe import ???

Attached are a couple of export import scripts I received earlier from a member of the user group. Hope they help. Ron Smith -Original Message- Sent: Monday, August 13, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Hi all, I sent this last Friday. Maybe not too

RE: O/S copies of datafiles

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

RE: ora-600/ora07445

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

<    1   2   3   >