RE: O/S copies of datafiles

2001-08-09 Thread Smith, Ron L.
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 I

RE: ora-600/ora07445

2001-08-08 Thread Smith, Ron L.
nd 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 I

RE: OT -- suggestions to ensure nerdiness in potential IT

2001-08-03 Thread Smith, Ron L.
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, Californ

RE: Listener.ora DNS or IP?

2001-08-01 Thread Smith, Ron L.
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 this mailing

Listener.ora DNS or IP?

2001-08-01 Thread Smith, Ron L.
the listener work properly? Will it resolve either way? 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

RE: Using AT command in NT

2001-08-01 Thread Smith, Ron L.
(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: Off Topic - Anybody know how to copy a DVD?

2001-08-01 Thread Smith, Ron L.
he 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: [

RE: Off Topic - Anybody know how to copy a DVD?

2001-07-31 Thread Smith, Ron L.
of list ORACLE-L > > > My kids keep breaking their DVD movies. Does anyone know a way to make > a > backup copy of a DVD? > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Smith, Ron L. > INET: [EMAIL PRO

RE: Off Topic - Anybody know how to copy a DVD?

2001-07-31 Thread Smith, Ron L.
-- 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 / Mai

Off Topic - Anybody know how to copy a DVD?

2001-07-31 Thread Smith, Ron L.
My kids keep breaking their DVD movies. Does anyone know a way to make a backup copy of a DVD? -- 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: How to know Oracle Down ?

2001-07-31 Thread Smith, Ron L.
e 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 PROT

RE: Quest's SharePlex

2001-07-31 Thread Smith, Ron L.
ike 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

RE: Perl Script for Alert Log

2001-07-31 Thread Smith, Ron L.
the books. Ron -Original Message- Sent: Monday, July 30, 2001 9:00 PM To: Multiple recipients of list ORACLE-L Ron, thanks for the script, but what was the name of the book that taught you this! Rachel >From: "Smith, Ron L." <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTEC

Perl Script for Alert Log

2001-07-30 Thread Smith, Ron L.
$~ = "OUTREC"; write; } $dateline = $sdateline; $line = ; $abbrev = " "; } } format OUTREC = ^<<<<<<<<<<<<<<<<<<<<<<<< ^<<<<<<<<<<&

ORA-03127 during Export

2001-07-27 Thread Smith, Ron L.
. Any idea why this would happen and how to fix 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

Grouping records using decode

2001-07-24 Thread Smith, Ron L.
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 To

RE: Reproduce ORA-0600

2001-07-24 Thread Smith, Ron L.
error? > >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 Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Publ

Reproduce ORA-0600

2001-07-24 Thread Smith, Ron L.
rows, deleting rows, reading by the index by requesting all columns in the index, updating all columns in the index. Nothing seems to work. Any ideas on how I can reproduce the error? Ron Smith [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L.

Insufficient priveleges

2001-07-23 Thread Smith, Ron L.
uthor: 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

Long running Analyze

2001-07-20 Thread Smith, Ron L.
out 6 hours. Does this seem normal? Is there any way to speed it up? 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, Calif

Perl Script for Alert Log

2001-07-19 Thread Smith, Ron L.
: 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: Analyze

2001-07-16 Thread Smith, Ron L.
RACLE-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--

Analyze

2001-07-16 Thread Smith, Ron L.
, 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-Mail

Rename alert log

2001-07-10 Thread Smith, Ron L.
Can the alert log be renamed while the database is up and running? 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

Alert log scan script

2001-07-10 Thread Smith, Ron L.
-- 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

Corrupt block in DBVERIFY

2001-07-09 Thread Smith, Ron L.
q.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 this ma

SQL*LOADER Questions

2001-07-09 Thread Smith, Ron L.
possible in SQL*Loader? 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 Lists

Password file in 8.1.6

2001-06-28 Thread Smith, Ron L.
wrong? 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) 538-5051 San Diego, California-- Public Internet access

RE: OT RE: 24 x 7 on NT?

2001-06-27 Thread Smith, Ron L.
e 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: Kimberly Smith INET: [EMAIL PROTECTED] Fat Cit

RE: 24 x 7 on NT?

2001-06-26 Thread Smith, Ron L.
pp will be available 24 x 7 on NT? Is anyone faced with this? 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

RE: Ora-1654 Unable to extend index on tablespace

2001-06-25 Thread Smith, Ron L.
7;ListGuru') 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

24 x 7 on NT?

2001-06-25 Thread Smith, Ron L.
://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 this

RE: SGA QUESTION

2001-06-25 Thread Smith, Ron L.
taining: 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 Network Services

RE: db_file_multiblock_read_count

2001-06-25 Thread Smith, Ron L.
u 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 D

RE: Griping about auditing (not the Oracle Kind)

2001-06-25 Thread Smith, Ron L.
r 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-

RE: Prompt in Korn shell

2001-06-21 Thread Smith, Ron L.
California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line

RE: Security delete the Guest account - Help!

2001-06-14 Thread Smith, Ron L.
q.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 this mailing

Security delete the Guest account - Help!

2001-06-14 Thread Smith, Ron L.
Guest account back to NT and SQLMAil should work? 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, Calif

RE: Netbackup BLI and SQLBacktrack

2001-06-14 Thread Smith, Ron L.
stGuru') 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:

ORA-04031

2001-06-07 Thread Smith, Ron L.
he bits after 2G - thus corrupt db. Unless you're on raw, I'd recommend a ceiling of 2g on any datafile - just to be safe hth connor --- "Smith, Ron L." <[EMAIL PROTECTED]> wrote: > I have taken over an Oracle database that is setup > with autoextend on the &g

Auto Extend

2001-05-31 Thread Smith, Ron L.
I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City

RE: Build an exact copy of a database using export / import

2001-05-30 Thread Smith, Ron L.
his works pretty well but I miss some of the grants and The full import wants to create tablespaces that I may or may not want created. I get a lot of errors on system objects. Does anyone have the proper steps to create an exact copy of a production database using export / import? Thanks! Ron

Build an exact copy of a database using export / import

2001-05-30 Thread Smith, Ron L.
errors on system objects. Does anyone have the proper steps to create an exact copy of a production database using export / import? Thanks! Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL

RE: ??? strange database link problem

2001-05-17 Thread Smith, Ron L.
EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). > -- Pleas

RE: ??? strange database link problem

2001-05-17 Thread Smith, Ron L.
e 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

Database Link ORA-02085

2001-05-17 Thread Smith, Ron L.
that point to Instance 'A' on server 'A'. When I tried the link I get an ORA-02085 which says the link name must be the same as the instance name. Any ideas why they do not work the same? Thanks! Ron Smith Database Administration [EMAIL PROTECTED] -- Please see t

RE: Export Split Script

2001-05-16 Thread Smith, Ron L.
essed export and the output is still over 2G. Does >anyone have the export script that splits the export files into multiple >files? > >Ron Smith >Database Administration >[EMAIL PROTECTED] >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: S

Export Split Script

2001-05-16 Thread Smith, Ron L.
I tries using a compressed export and the output is still over 2G. Does anyone have the export script that splits the export files into multiple files? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L

What is the cost of replication?

2001-05-16 Thread Smith, Ron L.
everything working? 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, California-- Public

RE: DBSNMP user?

2001-05-14 Thread Smith, Ron L.
s reporting. > > Rodd Holman > > >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< > > On 5/11/01, 2:45:31 PM, "Smith," Ron "L.&quo

DBSNMP user?

2001-05-11 Thread Smith, Ron L.
I have a user that keeps showing up in my NT database called DBSNMP. The OS user name is SYSTEM. Does anyone know where this user might be coming from? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L

LSNRCTL Password

2001-05-09 Thread Smith, Ron L.
Can anyone tell me what the syntax is to start, stop, or reload the listener when there is a password on it? -- 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

Rename Database on NT

2001-05-08 Thread Smith, Ron L.
This has probably been answered a million times but... Is there any way to rename an Oracle database and all its services on NT? -- 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

RE: unix command question

2001-05-02 Thread Smith, Ron L.
SUB 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--

RE: Actual size of database

2001-05-01 Thread Smith, Ron L.
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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

RE: How to get rid off file permanently?

2001-04-12 Thread Smith, Ron L.
lso 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-- Pub

RE: index on table with 3 million rows ???

2001-04-11 Thread Smith, Ron L.
ge 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 PROTECTE

8.1.6 on NT?

2001-04-09 Thread Smith, Ron L.
where there are on Metalink? 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, California

"AT" scheduler

2001-04-03 Thread Smith, Ron L.
Can anyone tell me how to schedule a batch job to run every 5 minutes using the "AT" scheduler? 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) 53

How do you turn off MTS?

2001-04-02 Thread Smith, Ron L.
I have a new instance that for some reason is running MTS. The only MTS parameter in the startup file is mts_dispatchers = "(protocol=TCP)". Is this what started MTS? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED]

Oracle on NT - Slow performance

2001-04-02 Thread Smith, Ron L.
, SYNTIME -- 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

NT Server very slow

2001-03-23 Thread Smith, Ron L.
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 yourself from

How long will 8.0.6 be supported?

2001-03-20 Thread Smith, Ron L.
I can't get into Metalink. Can anyone tell me how long 8.0.6 will be supported? 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

RE: NT Batch processes continue to run

2001-03-19 Thread Smith, Ron L.
- 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

Offtopic - Read a MAC CD on an NT desktop

2001-03-16 Thread Smith, Ron L.
Is there any way to read a CD created on a MAC machine from my NT Desktop? 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

Batch SQL hangs on locked row

2001-03-16 Thread Smith, Ron L.
(fileID_Errlog,'invalid_path on '||CurrDate); UTL_FILE.FCLOSE(fileID_Errlog); .stuff END; / -- 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)

NT Batch processes continue to run

2001-03-15 Thread Smith, Ron L.
run each day and complete normally. Any idea why the processes don't end? 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

Cannot delete due to lock

2001-03-13 Thread Smith, Ron L.
UTL_FILE.FCLOSE(fileID_Errlog); etc... -- 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: Rename tablespace

2001-03-12 Thread Smith, Ron L.
__Reply Separator____________ Author: "Smith; Ron L." <[EMAIL PROTECTED]> Date: 3/12/2001 8:56 AM I need to rename a tablespace. If I do an export, won't the import want to put all the objects back in the old tablespace? -- Please see the official ORACLE-L FAQ: ht

Rename tablespace

2001-03-12 Thread Smith, Ron L.
I need to rename a tablespace. If I do an export, won't the import want to put all the objects back in the old tablespace? -- 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

RE: Does NT write to random locations on disk?

2001-03-09 Thread Smith, Ron L.
a bad idea, but if db is shutdown, should be no problem. I'll (try to) log an iTAR through the NT CSI I have if it is of sufficient interest. regards, ep On 9 Mar 2001, at 11:35, Smith, Ron L. wrote: Date sent: Fri, 09 Mar 2001 11:35:38 -0800 To: Multip

RE: Does NT write to random locations on disk?

2001-03-09 Thread Smith, Ron L.
ACLE-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) 5

What or who is PUBLIC?

2001-03-08 Thread Smith, Ron L.
Can anyone point me to a paper or explanation of the Oracle role? called PUBLIC? How do you manage permissions for PUBLIC? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED

Off Topic - PKZIP

2001-03-07 Thread Smith, Ron L.
-- 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: Beta program opportunity

2001-02-28 Thread Smith, Ron L.
nd 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)

RE: Oracle DBA evolution path - please share your opinion

2001-02-26 Thread Smith, Ron L.
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-5

RE: Re:Anyone using CA products?

2001-02-26 Thread Smith, Ron L.
suppression system in the computer room on a > Friday late afternoon. > > Dick Goulet > > ________Reply Separator > Author: "Smith; Ron L." <[EMAIL PROTECTED]> > Date: 2/23/2001 1:00 PM > > I have been trying to get upgra

Anyone using CA products?

2001-02-23 Thread Smith, Ron L.
: 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

RE: How to find a listener service without running lsnrctl servic

2001-02-21 Thread Smith, Ron L.
r 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 --

RE: free tool??

2001-02-20 Thread Smith, Ron L.
their properties? Thanks to All . Bunyamin Karadeniz -- 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: Beta program opportunity

2001-02-16 Thread Smith, Ron L.
r 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 ---

Truncate in a procedure?

2001-02-16 Thread Smith, Ron L.
? 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, California-- Public Internet access

How to check file size in DOS

2001-02-14 Thread Smith, Ron L.
I need to check the size of a file from within a batch script to see if it is empty. Is there any way to do this? 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

RE: Opinions on OLTP

2001-02-13 Thread Smith, Ron L.
) 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.

RE: Database Re-org tools

2001-02-09 Thread Smith, Ron L.
o 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 Inte

RE: Opinion on duplicate values

2001-02-06 Thread Smith, Ron L.
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 / Mai

NT 6a?

2001-02-06 Thread Smith, Ron L.
Does anyone know if there are any problem with compatibility for NT 6.a and Oracle Server Work Group version 7.3.4.4.0? 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

RE: table access via Browser

2001-02-06 Thread Smith, Ron L.
or 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 ac

RE: Pinning Tables

2001-02-05 Thread Smith, Ron L.
lude 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 PROTECT

RE: Need help - Database link - Please!!

2001-02-05 Thread Smith, Ron L.
n anyone help? > > > > Ron Smith > > Database Administration > > [EMAIL PROTECTED] > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Smith, Ron L. > > INET: [EMAIL PROTECTED] > > > > F

RE: Need help - Database link - Please!!

2001-02-05 Thread Smith, Ron L.
at contains the database link and > tries to update table-a in database-b. > The result is an Oracle error that states insufficient privileges on > table-a. > > Can anyone help? > > Ron Smith > Database Administration > [EMAIL PROTECTED] > > -- > Please see the off

Need help - Database link - Please!!

2001-02-05 Thread Smith, Ron L.
Oracle error that states insufficient privileges on table-a. Can anyone help? 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

RE: Unix script question

2001-01-31 Thread Smith, Ron L.
bscribing). -- 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: Unix script question

2001-01-31 Thread Smith, Ron L.
(note EXACT spelling of 'ListGuru') 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: h

RE: Index Usage Monitoring

2001-01-31 Thread Smith, Ron L.
stGuru') 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:

RE: Archive log file monitoring Unix script - Help needed

2001-01-31 Thread Smith, Ron L.
ODY, 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

RE: How to drop a database

2001-01-30 Thread Smith, Ron L.
lic Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORA

<    1   2   3