Character set issue
Hi there, I'm trying to change my database (Oracle 8.1.7) character set from WE8ISO8895P1 to WE8ISO8895P15. I would have thought this was possible but I get this message: ORA-12712: new character set must be a superset of old character set The reason I'm doing this is to allow the use of the Euro character and WE8ISO8895P1 doesn't allow me to do this. Any help appreciated. TIA, Steven Hovington. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steven Hovington 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-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).
Delete query
Hi, Can anyone help me with this delete statement? I have the following table: Name Null?Type - - USER_ID NOT NULL NUMBER(15) PASSWORD VARCHAR2(30) CREATEDDATE What I need to do is delete the oldest record for a particular user_id. And its doing my head in. Any help appreciated! Thanks, Steve. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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).
Re: Delete query
At 10:25:44 09 Jul 2002 -0800, Thomas Day wrote: Do you want to delete the oldest record for a given userid (many answers provided) or the oldest record for each userid (a little more work)? Thomas, I wanted to delete just the oldest (by date) record for a given user id. Thanks for all the replies everyone, very helpful indeed. Steven. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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).
sql query
Hi, I have this sql statement: select to_number(null) as id, to_char(null) as car_make from dual union select id, car_make from carmake order by car_make; So this selects a blank record and then the records from carmake. But I want the blank record to appear at the top of the list, and it must be done in the select statement. Can this be done? TIA, Thanks, Steven Hovington -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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).
Program field in v$session
This column is 64 characters in length - if for example the shortcut to a program is longer than this, it can't all be stored, so is there any way of getting this info? Thanks, Steven H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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).
Disk layout
Could anyone please point me towards documentation which discusses optimum disk layouts for Oracle databases. Thanks in advcance. Steven. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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).
RE: Accept statement
Sure,
Here it is:
set serveroutput on;
spool d:\temp.sql;
accept var_a char prompt 'Enter new location:'
declare
temp varchar2(520);
i number;
startpos number;
cursor cur1 is select name from v_$datafile;
local_var varchar2(100) := var_a;
begin
DBMS_OUTPUT.ENABLE(1);
open cur1;
loop
fetch cur1 into temp;
i:= instr(temp,'\');
startpos:= 0;
while i0 loop
startpos:= i+1;
i:= instr(temp,'\',startpos);
end loop;
dbms_output.put_line('alter database rename file ' || temp ||
local_var ||substr(temp,startpos) ||';');
exit when cur1%notfound;
end loop;
close cur1;
end;
/
spool off;
Steven H.
-Original Message-
Gennick
Sent: 18 September 2001 19:25
To: Multiple recipients of list ORACLE-L
Tuesday, September 18, 2001, 1:30:17 PM, you wrote:
SH I'm am trying to use an accept statement to grab some info from the user
in
SH an SQL script,
SH and then use that in a subsequent PL/SQL block. I can do the Accept ok,
but
SH can't sem to
SH access the variable onside the block. Can anyone point me in the right
SH direction?
Can you post the part of your script in which you are doing
this?
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Hovington
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 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).
Turning off output when running pl/sql
Hi, I'm running a block of PL/SQL in SQL Plus (8.1.7), and when its completed it says the usual: PL/SQL procedure successfully completed. at the end. I'm spooling the output of the PL/SQL block to a file using dbms_put.put_line but I want to get rid of the above line. Anyone know how I can do this? Thanks in advance, Steven H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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).
Accept statement
I'm am trying to use an accept statement to grab some info from the user in an SQL script, and then use that in a subsequent PL/SQL block. I can do the Accept ok, but can't sem to access the variable onside the block. Can anyone point me in the right direction? Thanks in advance. Steven H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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).
RE: !! Keeping the list alive
That is disgraceful. Here when people were let go they were at least treated properly, given good packages (over and above what was legally required), and the services of a careers counciller to help them prepare their cv, brush up on interview techniques contact reqruitement agencies etc. Even if they were pissed at being out of a job, they had no complaints as to how the company treated them. Steven H. -Original Message- McDonald Sent: 03 September 2001 18:25 To: Multiple recipients of list ORACLE-L Time to chip in my horror story (and why I'll never do permie again). Company in OZ decided to cut down numbers. Bosses walked around with security guards into each persons office and tell them they have 5 minutes to leave to premises and give them a ticket which has a 15minute after-hours timeslot in which they will have a supervised cleanout of their desk/office etc. They were marched down the lift and out into the street. I only knew this because the girl that gave me a lift to work phoned me from home and said sorry, can't take you home, my job is gone So - if you ever get a chance to work for BHP in Australia :-( Cheers Connor -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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).
Upgrade of database
Can anyone point me towards the documentation for upgrading Oracle 8i, from 8.1.6 to 8.1.7. Thanks in advance Steven H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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).
Database using 100% of CPU
We are having a problem with our database - it is using 100% of the CPU. This has only started happening recently, and restarting the database temporarily stops it happening - it usually recurrs a few hours later. There are no jobs running, and at the moment there are no active connections. Obviously something has kicked this off, can anyone shed any light on this or suggest how to find out what is running on the db? Thanks in advance, Steven H. (Oracle 8.1.6.0.0 EE on NT 4 SP5) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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).
RE: Database using 100% of CPU
Which are the event tables, and how do I run the statspack report? There are no jobs and no active sessions (except mine, and its not me...). Thanks, Steven H. -Original Message- Spence Sent: 17 August 2001 18:35 To: Multiple recipients of list ORACLE-L Have you looked at the event tables? Perhaps running a statspack report from now to the next 10 minutes and look at the biggest waiters. If it is unix, look for the process which is eating up the resources, query v$process to get the process address, then use that to get the session, then use the sql address to find the sql.\ Also query v$session for active sessions which are active for a long time. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Friday, August 17, 2001 12:41 PM To: Multiple recipients of list ORACLE-L We are having a problem with our database - it is using 100% of the CPU. This has only started happening recently, and restarting the database temporarily stops it happening - it usually recurrs a few hours later. There are no jobs running, and at the moment there are no active connections. Obviously something has kicked this off, can anyone shed any light on this or suggest how to find out what is running on the db? Thanks in advance, Steven H. (Oracle 8.1.6.0.0 EE on NT 4 SP5) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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 see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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 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 see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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).
Oracle Reportwriter Crystal Reports (Slightly OT)
Does anyone have any recommendations on these reporting tools, or pointers to resources discussing the relative merits? Thanks in advance, Steven H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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).
RE: part of the table export (incremental?)
So what should you use instead? Steven. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: 02 August 2001 17:21To: Multiple recipients of list ORACLE-LSubject: Re: part of the table export (incremental?) and the incremental/cmulative options in export are only there for backwards compatibility w/scripts, my understanding is they are not really supported anymore. joe [EMAIL PROTECTED] 08/02/01 10:30AM if you are running 8i, you can use a where clause on the export.incremental export does not export only the changed rows but will export the entire table if even as little as one byte in one row has changed.From: "Tatireddy, Shrinivas (MED, Keane)" [EMAIL PROTECTED]Reply-To: [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]Subject: part of the table export (incremental?)Date: Thu, 02 Aug 2001 02:05:26 -0800Hi dba'scan anybody tell me how to do export part of the table..i.e. incremental data.when i exported at 10 am it has 1000 rows ( i did full exp)100 rows newly added in the 2 hrswhen i do exported at 12 am ( incremental) it exporting all therows(1100) of the tablebut i need only the rows, that are newly inserted.is there any way to do such export?thnx in advsrinivas--Please see the official ORACLE-L FAQ: http://www.orafaq.com--
Problem connecting to a db
I have someone on a remote site who is having problems connecting to a db in server mgr as internal. connect internal should work, but it replies with insufficient privileges, I must be missing something. Does anyone have a suggestion what this could be? OS is NT 4, using Oracle 8.1.6 standard and they are logged on to NT as administrator. Thanks, Steven. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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).
RE: Problem connecting to a db
Logged on as administrator (NT4). Then in svrmgrl: connect internal/oracle Or : connect internal (prompted for password): oracle Same error message either way. Tried it several times, I don't *think* it is being typed wrong... Steven. -Original Message- Gramolini Sent: 17 July 2001 14:41 To: Multiple recipients of list ORACLE-L How is the user logged on to the server before trying to run svrmgrl? I always log on as oracle. hth, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 8:30 AM I have someone on a remote site who is having problems connecting to a db in server mgr as internal. connect internal should work, but it replies with insufficient privileges, I must be missing something. Does anyone have a suggestion what this could be? OS is NT 4, using Oracle 8.1.6 standard and they are logged on to NT as administrator. Thanks, Steven. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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 see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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 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 see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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).
RE: RE: Problem connecting to a db
There is no ORA_DBA group, which I guess is a problem. Is this supposed to be created during the Oracle installation? Thanks, Steven. -Original Message- Walthour Sent: 17 July 2001 15:36 To: Multiple recipients of list ORACLE-L Steven: To log on as INTERNAL in svrmgrl on NT, the user must be a member of the ORA_DBA group, not the Administrators group. Is the user in question a member of the ORA_DBA group? -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio --- Original Message --- From: Steven Hovington [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/17/01 10:06:17 AM Logged on as administrator (NT4). Then in svrmgrl: connect internal/oracle Or : connect internal (prompted for password): oracle Same error message either way. Tried it several times, I don't *think* it is being typed wrong... Steven. -Original Message- Gramolini Sent: 17 July 2001 14:41 To: Multiple recipients of list ORACLE-L How is the user logged on to the server before trying to run svrmgrl? I always log on as oracle. hth, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 8:30 AM I have someone on a remote site who is having problems connecting to a db in server mgr as internal. connect internal should work, but it replies with insufficient privileges, I must be missing something. Does anyone have a suggestion what this could be? OS is NT 4, using Oracle 8.1.6 standard and they are logged on to NT as administrator. Thanks, Steven. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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 see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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 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 see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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 see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour 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 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 see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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).
RE: RE: Problem connecting to a db
This was the problem. All working now. Thanks everyone for the answers! Steven. -Original Message- Walthour Sent: 17 July 2001 15:36 To: Multiple recipients of list ORACLE-L Steven: To log on as INTERNAL in svrmgrl on NT, the user must be a member of the ORA_DBA group, not the Administrators group. Is the user in question a member of the ORA_DBA group? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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).
RE: DB on NT
Hi, Regarding the issue of databases larger than 1GB on NT, could someone please explain this to me, as I was not aware of this 'saying'. Thanks in advance, Steven H. -Original Message- Antje Sent: 05 July 2001 10:51 To: Multiple recipients of list ORACLE-L Hi, I' hav to build up foolowing matrix DB Size .. Operating system NT Sun Solaris AIX ... Has anyone a similar matrix to share? Especially I'm interested in the size for NT. I know there was a saying - put no database larger than 1 GB on a NT machine. Is this still true with 8.1.7 or is it stable with larger databases also? Regards, Antje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 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).
