RE: OS Level Defrag

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.net -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,

OS Level Defrag

Title: Message Hi,   Does anyone here do an O/S level defrag of their Oracle filesystems???   Background: (Tru64/8.1.7.4)   Sysadmin here were adamant that the Oracle domains were running out of extents and were highly fragmented (O/S level). DBA was adamant that the Oracle filesystems shoul

PL/SQL Help

The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This

RE: Sujatha.Madan@optus.net.au

way!!   chris   -Original Message-From: Sujatha Madan [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 11:29 PMTo: Multiple recipients of list ORACLE-LSubject: IGNORE: Unix Help   Sorry ... but I solved it.   Cheers Su

IGNORE: Unix Help

sysdate - "time interval"  but I am trying to avoid that.   Thanks in advance,   Sujatha Madan.

Unix Help

do this using sysdate - "time interval"  but I am trying to avoid that.   Thanks in advance,   Sujatha Madan.

OT: Oracle DBA Position in Sydney

technologies (IP and mobile) ... and ... you get to work with me. If you are interested and want more info, please contact me offline or call me on 0402 354 347. Oh yes: Those ALREADY eligible to work in Australia ONLY - visa's will NOT be sponsored! Good luck, Sujatha Madan PS: Sorry once

RE: dba age

I've used RPT/RPF as a programmer and some of them are still used. Now as a DBA , I see them still running against 8.1.7 and i am only 31 yrs young. Regards Mada

RE:

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

RE: Oracle Internet File System

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

RE: RMAN: One Catalog DB .. different target db releases

above process??? ... Has anyone been through this before - or know of any bug I did try and drop/delete everything I did and redo it all, but it didn't work either. Sorry for the lengthy mail and thanks in advance for your help Cheers Sujatha --- S

RMAN: One Catalog DB .. different target db releases

oing anything wrong in the above process??? ... Has anyone been through this before - or know of any bug I did try and drop/delete everything I did and redo it all, but it didn't work either. Sorry for the lengthy mail and thanks in advance for your help Cheers Sujatha -

RE: SOLVED: RBS datafile recovery

t ORACLE-L Suji, When you post a question and figure out the answer, please tell us as well so we don't have to reinvent the wheel should it ever happen to us! Rachel --- Sujatha Madan <[EMAIL PROTECTED]> wrote: > I think I've figured it out and now I have more info (after &

SOLVED: RBS datafile recovery

lease help me with this problem? ... or am I doing something totally wrong ??? Oracle: 8.1.7 on W2K ... Test db and machine only. Cheers, Sujatha --- Sujatha Madan Database Administrator Custom Management Centre Optus Business Operations 'yes&#

RBS datafile recovery

s 8) Recover RBS tablespace Could some one please help me with this problem? ... or am I doing something totally wrong ??? Oracle: 8.1.7 on W2K ... Test db and machine only. Cheers, Sujatha --- Sujatha Madan Database Administrator Custom Management Ce

RE: "Take Care of your DBAs"

Melbourne!!! ... you got to be kidding!   Sydney - Heaven on Earth. :)   Cheers Sujatha -Original Message-From: Ferenc Mantfeld [mailto:[EMAIL PROTECTED]]Sent: Friday, 31 January 2003 6:20 AMTo: Multiple recipients of list ORACLE-LSubject: Re: "Take Care of your DBAs" Snow

RE: _allow_resetlogs_corruption

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

_allow_resetlogs_corruption

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

RE: question about rman

tion if the backups start after our call centers are open for business.   thanks for the info though.  i'll do some checking for omniback.  -Original Message-From: Sujatha Madan [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 21, 2003 2:37 PMTo: Multiple

RE: question about rman

Title: question about rman Correct me if I am wrong, but I thought the backup software will only initiate the RMAN backup once your server has reached the top of the queue and it is ready to be written to tape. At least that's what happens with Legato.   Regards, Sujatha   -Original M

RE: Unix Q: Substring-ing an output.

gt;>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>> Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or respo

RE: Unix Q: Substring-ing an output.

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

RE: svrmgrl echo v$database in script

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: Sujatha Madan INET: [EMAIL PROTECTED] Fat C

RE: DBA work load

an E-Mail message to: [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

RE: DBA work load

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 ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HE

RE: WebLogic, Oracle JDBC related

ED] (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 t

RE: WebLogic, Oracle JDBC related

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 ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (li

RE: WebLogic, Oracle JDBC related

DY, 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: Sujatha Madan INET: [EMAIL PROTECTED] F

RE: Legato oracle module.

NSUB 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: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Ser

RE: Legato oracle module.

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: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (85

W2K problem in connection

s. Cheers, Sujatha --- Sujatha Madan Database Administrator Custom Management Centre Optus Business Operations 'yes' OPTUS PH # +61 2 9775 5316 Mobile # +61 402 354 347 FAX # +61 2 9775 5360 Email [EMAIL PROTECTED] WEB h

8.1.7.4

Has anyone patched up to 8.1.7.4 yet??? Anything we should be aware of??? Regards, Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Solid DB and Oracle (NNM)

nce, The Vision" = Sujatha Madan <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01-05-2002 02:58 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Fax to:

Solid DB and Oracle (NNM)

Thanks and regards, Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public I

RE: Saving down time on Install

formation (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: datafile sizing ?

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

RE: Upgrade 8.0.5 to 8.1.7.3

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 mess

RE: initjvm and rmjvm failing

Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Intern

RE: Please ignore: Internet DBA'ng

an [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 16 April 2002 5:13 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Please ignore: Internet DBA'ng How? -Original Message----- From:   Sujatha Madan [SMTP:[EMAIL PROTECTED]] Sent:   04 ÕÝÑ, 1423 09:08 AM To: Mu

Please ignore: Internet DBA'ng

Solved this issue. > -Original Message- > From: Sujatha Madan > Sent: Tuesday, 16 April 2002 2:55 PM > To: Multiple recipients of list ORACLE-L (E-mail) > Subject: Internet DBA'ng > > Hi, > > We have a network/web hosting shop, and on

Internet DBA'ng

associated with this? Or is there anything that I should be aware of in terms of security? Or should I be asking them any questions? Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services

runInstaller problems - urgent

o initialize threads: cannot find class java/lang/Thread Could not create Java VM" I've got the CLASSPATH set to $ORACLE_HOME/jdbc/lib/classes111.zip I'm running 8.1.7 on HP-UX Please help. Thanks --- Sujatha Madan Database Administrator Custo

LMT's or DMT's

Also, is the "dbms_space_admin.tablespace_migrate_to_local()" package "reliable" or is there anything that I should be aware of??? Thanks Sujatha --- Sujatha Madan Database Administrator Custom Management Centre Optus Business Oper

RE: Remote DB Installation

Sorry I was too quick in sending.   With the telnet, you need some sort of X windows application - liek Reflection X or XWin or something like that.   The Oracle Installator will work via this.     -Original Message-From: Sujatha Madan [mailto:[EMAIL PROTECTED]]Sent: Friday

RE: Remote DB Installation

You need to establish a telnet or ssh connection to the remote server. That's all you need.   -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]Sent: Friday, 22 March 2002 2:33 PMTo: Multiple recipients of list ORACLE-LSubject: Remote DB Installation I have

RE:Wondering ... Lite: Redo sequence poll

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

RE: HP-UX Oracle Install

xperience, The Vision"= Sujatha Madan <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 28/02/2002 12:13 PM Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-

HP-UX Oracle Install

g there won't be a problem, but I just wanted to make sure. Thanks Sujatha ------- Sujatha Madan Database Administrator Custom Management Centre Optus Business Operations 'yes' OPTUS PH # +61 2 9775 5316 Mobile # +61 402 354 34

RBS Tablespace Recovery

one can give me. Cheers, Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Intern

RE: Where does a DBA go from here?

I'm in for it!   -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 19 February 2002 7:08 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Where does a DBA go from here?Yeah, we're doing the Forum on 27-28 of May (confirmed) and we'll d

RE: Where does a DBA go from here?

Thanks for the information Suhen.   -Original Message-From: Suhen Pather [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 19 February 2002 11:48 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Where does a DBA go from here? Sujatha,        

RE: Where does a DBA go from here?

Where can I get more information about this Database Forum in Sydney??   Cheers,   Sujatha -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 19 February 2002 10:18 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Where does a DBA go from

RE: Moving Oracle Binaries from HP to SUN

) 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: Sujatha Madan IN

RE: RMAN error while TSPITR

--- > 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 ORACLE-L > (or the

RE: RMAN error while TSPITR

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 ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for oth

RE: Rename a datafile

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: http://www.orafaq.com -

FW: OCOPY

pelling 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: http://www.orafaq.com --

RE: OCOPY

ng 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: http://www.orafaq.com --

FW: Backup Strategy

-- 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 >

RE: Backup Strategy

-- 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 > >

RE: RMAN-20202 error while recovery

ng 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: http://www.orafaq.com -- A

RE: Changes to db after renaming mount points

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

Changes to db after renaming mount points

to new location (ii) Do a ALTER DATABASE RENAME FILE for each datafile moved. Does this sound fine? ... Have I missed anything? ... or should I look out for something special? Thanks for your help Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan

RE: Control files & Redo Logs

to mirror > this as well, and not have *all* of your control files or on the *same* > disk? > > -Original Message- > Madan > Sent: 30 November 2001 05:05 > To: Multiple recipients of list ORACLE-L > > > Hi!!! > > Is it a good idea to put redo logs and co

Control files & Redo Logs

Hi!!! Is it a good idea to put redo logs and control files on the same disk with nothing else on the disk??? Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: rman disk channel destination

Title: rman disk channel destination Hi,   Are you asking how to set the target directory for the backup images   If you are the script should go something like this:   .. allocate channel d1 type disk backup format '\u01\backups\controlfiles\cf%d_t%t_s%s_p%p' (current controlfile);

RE: rman question

Title: rman question Hi,   Your initial statement is correct. If you use rman to backup, you must use it to restore/recover. All the rman backup sets are understandable only by rman.   Cheers   Sujatha -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday,

RE: RE: Unix Oracle Processes

sage 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: Sujatha Madan INET: [EMAIL PROTECTE

RE: RE: Unix Oracle Processes

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

RE: Unix Oracle Processes

you shutdown? did the database you think you shut down, shut down properly? --- Sujatha Madan <[EMAIL PROTECTED]> wrote: > Hi, > > If I have shutdown my database doesn't that mean that all the smon, > pmon > processes will be killed??? > > After I shutdown my d

Unix Oracle Processes

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

Upgrading from 8.0.5 to 8.0.6

* script and do the other steps for an upgrade? Or do I have to use that db assistant and do an Upgrade Database objects. Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Import Help

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: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Ne

Import Help

://www.orafaq.com -- Author: Sujatha Madan 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: Antwort: ORA - 12560: TNS: protocol adapter error

OTECTED] (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).

create database scripts v8.0.6 & 8.1.7

Hi, If I have a create database script which I've used with v8.0.6, would I be able to use these same scripts in v8.1.7??? ... or are there any modifications to be made. Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [

pfs_mount/umount

the CD never comes out. Does anyone know of a way around this??? ... assuming I have no free space to copy the CD onto disk. Regards, Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: Constraint Enable/Disable

l_constraints where constraint_type in ('C','R') / later you could replace the DISABLE with ENABLE and.... .. regards > -- > From: Sujatha Madan[SMTP:[EMAIL PROTECTED] ] > Reply To: [EMAIL PROTECTED] > Sent: Friday, November 02, 2

RE: Constraint Enable/Disable

;||table_name||' disable constraint '||constraint_name||';' from all_constraints where constraint_type in ('C','R') / later you could replace the DISABLE with ENABLE and .. regards > -- > From: Sujatha Madan[SMTP:[EMAIL PROTECTED] ]

Constraint Enable/Disable

Hi, Is there a way to disable all constraints, and then enable them all again? Thanx Sujatha

RE: Startup error

rst semaphore set. HP-UX Error: 28: No space left on device Additional information: 1 SVRMGR> Could someones please tell me what this means and how I should fix it. Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PRO

Startup error

ace left on device Additional information: 1 SVRMGR> Could someones please tell me what this means and how I should fix it. Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 53

RE: Root to connect as system

being able to login, > maybe that was back and hardcoded for svrmgrl. > > joe > > Sujatha Madan wrote: > > > > Ok, I have solved the issue of the listener, however I still cannot get root > > to log on as system. > > > > - My Oracle home is set correct > > -

RE: Root to connect as system

"why are you insisting on root logging into the database???" create a new userid to do the connection. i thought i remembered somewhere about root not being able to login, maybe that was back and hardcoded for svrmgrl. joe Sujatha Madan wrote: > > Ok, I have solved the issue

RE: Root to connect as system

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 ORACLE

RE: Root to connect as system

a tns service name Deepak PS: have you set the env variables .. type env at the unix prompt and check if PATH /ORACLE_HOME/ LD_LIBRARY_PATH are set correctly --- Sujatha Madan <[EMAIL PROTECTED]> wrote: > Hi, > > How can I allow root to connect to the database as > system. At

RE: Root to connect as system

unix prompt and check if PATH /ORACLE_HOME/ LD_LIBRARY_PATH are set correctly --- Sujatha Madan <[EMAIL PROTECTED]> wrote: > Hi, > > How can I allow root to connect to the database as > system. At the moment > when I try this, I keep getting a ORA-01034: Oracle > not avail

Root to connect as system

: Sujatha Madan 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

Win XP

Hi! Has anyone tried installing v8.1.7 or v9i on Windows XP??? Cheers, Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: System tablespace datafile

http://www.superpages.com > -Original Message- > From: Sujatha Madan [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, October 04, 2001 10:20 PM > To: Multiple recipients of list ORACLE-L > Subject: System tablespace datafile > > Hi, > > Does the system tables

System tablespace datafile

Hi, Does the system tablespace/datafile always have a maxbytes of zero??? ... or do I have a problem??? Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: DB Names in multiple oracle installs

if oracle home, version are different, their SID name should be different. I tested. I'm able to create two databases on one oracle server with different SID, but at a time i can startup only one database. REgards, Nirmal. > -Original Message- > From: Sujatha Madan [SM

DB Names in multiple oracle installs

Hi,   Is it possible to call two databases the same name if they are residing on the same machine, in different oracle homes? ... One database is version 8.0.6 and the other is 8.1.7.   Thanks   Sujatha

RE: could anyone please call this number ?

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

RE: OT Terrorist Acts

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

RE: Alter tablespace add datafile

q.com -- Author: Sujatha Madan 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 mai

RE: Alter tablespace add datafile

e new one and leave the old one? >- Is there any other way I can get around this by not shutting down the >database??? > >Thanks in advance > >sujatha >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Sujatha Madan > INET: [EMAIL P

RE: Alter tablespace add datafile

used, then if you're not at 2G then you can resize it up(which is my preferred method before adding a datafile). Either can be done without taking the database down. After you've created the new datafile, oracle will use it automagically :) joe Sujatha Madan wrote: > > One of our

Alter tablespace add datafile

there any other way I can get around this by not shutting down the database??? Thanks in advance sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: Export/Import question

-- Author: Sujatha Madan 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 lis

  1   2   >