date:20010309

At 01:55 PM 3/9/01 -0800, you wrote:
>Hi Dennis,
>
>In my previous job as a dba in a dot com, it was found db2 to be more
>attractive in terms of price/features.
>
>are u including database clients software, hardware for the database server
>and backup infrastructure for the concerned databases
>
>would be glad to receive ur summary.

FYI this is basically what I'm asking:

I've specified the server as an intel box with 2x750 Mhz cpu, running
either linux or NT.
I've specified 3 scenarios in terms of number of servers and number of
users, and a fourth as an internet-based database server for a web page.

I've asked for the price for each dbms *only*. This should give me an idea
of the relative costs for the databases under a number of conditions. If
the salescritter attempts to bob and weave, that's relevant information as
well.

Dennis Taylor

ILLEGITIMUS NON CARBORUNDUM.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dennis Taylor
  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: Need RMAN script command to close database

2001-03-09 Thread Jack C. Applewhite


Alex,

You could do what you want in a batch or shell script before
calling RMan.  Below is a snippet of a *.cmd file used by
Veritas NetBackup to do a cold backup with RMan.  It's for
Windows2000 or NT, but you could do something similar on
UNIX.

@REM --- Set the
variables --
---
...
@set OUTF=%~dpn0.out
...
@set TMPF=%~dpn0.tmp
...
@set ORACLE_HOME=d:\oracle\ora81
...
@set ORACLE_SID=mysid
...
@REM ---

@REM Call Server Manager to shutdown the target database in
immediate priority.
@REM This lets current calls to the database complete, but
prevents further
@REM logons or calls.
@REM
@REM The shutdown-startup logic of this script can be
commented out if you know
@REM that the database will always be mounted and in a
consistent state before
@REM this script is executed.
@REM ---


@echo connect internal/oracle > %TMPF%
@echo shutdown immediate >> %TMPF%
@echo exit >> %TMPF%

@echo # >> %OUTF%
@echo %ORACLE_HOME%\bin\%SVRMGR% >> %OUTF%
@type %TMPF% >> %OUTF%
%ORACLE_HOME%\bin\%SVRMGR% < %TMPF% >> %OUTF%

@REM ---

@REM Startup the database in case it had crashed or was not
shutdown cleanly
@REM prior to starting this script.  This will perform a
crash recover if
@REM it is needed. Use the RESTRICT option because we are
going to shutdown
@REM again right away and we don't want to let users in
during the short
@REM interval. The default init.ora file will be used
by startup. If it was
@REM moved, the name was changed, or ORACLE_HOME and
ORACLE_SID are not set, use
@REM the pfile= option on the startup command.
@REM ---


@echo connect internal/oracle > %TMPF%
@echo startup restrict open >> %TMPF%
@echo shutdown immediate >> %TMPF%
@echo exit >> %TMPF%

@echo # >> %OUTF%
@echo %ORACLE_HOME%\bin\%SVRMGR% >> %OUTF%
@type %TMPF% >> %OUTF%
%ORACLE_HOME%\bin\%SVRMGR% < %TMPF% >> %OUTF%

@REM ---

@REM Now we know that the database is cleanly closed and is
ready for a
@REM cold backup. RMAN requires that the database be started
and mounted
@REM to perform a backup.
@REM ---


@echo connect internal/oracle > %TMPF%
@echo startup mount >> %TMPF%
@echo exit >> %TMPF%

@echo # >> %OUTF%
@echo %ORACLE_HOME%\bin\%SVRMGR% >> %OUTF%
@type %TMPF% >> %OUTF%
%ORACLE_HOME%\bin\%SVRMGR% < %TMPF% >> %OUTF%

@REM ---

@REM Temporary file no longer needed.
@REM ---


@if exist %TMPF% del %TMPF%

@REM ---

@REM What kind of backup will we perform.
@REM ---


@if "%NB_ORA_INCR%" == "1" goto differential

@if "%NB_ORA_CINC%" == "1" goto cumulative

@REM ---

...
now call RMan and do the cold backup...




Hope this helps you.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]


-Original Message-
Berindei
Alex
Sent: Friday, March 09, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L



Hi smart guys,

I need a RMAN script command to close a database, do you
think this can be
done.

What I know is I can start the database, for "MOUNT" state
to "OPEN" with
next script, using a SQL command:

{
  allocate channel type disk 
  sql 'ALTER DATABASE OPEN';
}

What I have?
I have an open database in NOARCHIVE log mode (don't ask
why) which I want
to backup.
What I want?
To put database in MOUNT state from RMAN script, backup
whole database,
reopen the database.
{
HERE NEED COMMAND TO PUT DATABASE IN MOUNT STATE
  allocate channel type disk 
  backup  whole database in MOUNT state
  sql 'ALTER DATABASE OPEN';
}

Thanks alex.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  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 fr

RE: Does NT write to random locations on disk?

At 01:55 PM 3/9/01 -0800, you wrote:
>Oracle datafiles are formatted into blocks.  Data is read either physically
>by block or an indexed block number.  If you compress using zip and then
>uncompress, the blocks have not changed.  If you reorg the file the blocks
>will probably change and the data wont be where Oracle thinks it is.
>

I'm working from logic rather than specific knowledge of Oracle here, so I
could be way off base. But if you are set up to use a cooked rather than
raw file system, then the block number that Oracle uses should be
file-relative rather than disk-relative, i.e. the block labelled '34' would
be the 34th or 35th block *in the file* rather than *on the disk*. No
matter how much you defrag, zip, unzip, copy, mash, spit on, or otherwise
vilify the file, it still ends up with the same data in that block.
Theoretically.

Dennis Taylor

ILLEGITIMUS NON CARBORUNDUM.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dennis Taylor
  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: Does NT write to random locations on disk?

Well then forget the compress issue. I can shutdown the 
database, move the db files to another directory, do the
usual dba excercises to let Oracle know the new location,
and startup with no problems. (Oracle 7.3 on Netware3)

The reason I remember is that when we upgraded from 7.0 to
7.3, the documentation about placement of db files was 
incredibly sucky. Naturally, I researched it throughly 
(various TARs, complaints, etc.), and it turns out it was 
much simpler than the docs made it sound.

Anyways, I'll submit an iTar since I need to know this stuff
when we migrate to NT/Win2k in the near future.

regards,
ep

On 9 Mar 2001, at 13:55, Smith, Ron L. wrote:

Date sent:  Fri, 09 Mar 2001 13:55:35 -0800
Send reply to:  [EMAIL PROTECTED]

> Oracle datafiles are formatted into blocks.  Data is read either physically
> by block or an indexed block number.  If you compress using zip and then
> uncompress, the blocks have not changed.  If you reorg the file the blocks
> will probably change and the data wont be where Oracle thinks it is.
> 
> I wouldn't do it.
> 
>  
> 
> -Original Message-
> Sent: Friday, March 09, 2001 2:31 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Are you talking about a shutdown database, or one started?
> 
> (After shutdown) why can I ".zip" the database files on 
> Netware3, move them around (copy to DAT, CD, backup directories,
> etc., then restore them (potentially in another location), 
> and successfully run the database after?
> 
> As far as I recall, the db files work "independent" of the
> low level allocation details of the OS I/O system.
> 
> I would guess running defrag while db is started is 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:   Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> 
> > I wouldn't think you would want to reorg an Oracle tablespace with an NT
> > defrag utility.  You would corrupt the data.
> 
> ...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  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).

function index concepts - urgh

I'm having just a little trouble with concepts here. I've created a table with FIRST_NAME and LAST_NAME fields. I want to be able to index the table using 

create index HOLDER_NAME_IDX on HOLDER (UPPER(LAST_NAME||' '||FIRST_NAME));

In other words I want to be able to store data as mixed upper & lower case, and I want to be able to look it up using mixed upper and lower case. I'm a little confused about the select statements, though. If I say:

insert into holder (last_name,first_name) values ('taylor','dennis');

then

select * from holder where last_name = 'Taylor' and first_name = 'Dennis';

is that going to use the index? Or do I have to torque the select statement a little more? Or is there a better way to set up the index? Or is the problem just that it's friday? or maybe Friday?





Dennis Taylor

ILLEGITIMUS NON CARBORUNDUM.

--  Please see the official ORACLE-L FAQ: http://www.orafaq.com --  Author: Dennis Taylor 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: Weird - unable to extend err

Ganti, things like new users get created in the database every day. 
sometime people put

create user scott identified by tiger;

ok their default and temp ts is system.

u let it go to max extents, scott is logged in and creates some
outrageous table with 10K initial 10K next pctincrease 0, they create a
300M table, want to guess how many extents that is?

is it a performance problem to get the data out, not really anymore, but
the drop of that table, means ALOT of DML against FET$ and UET$ to say
the least.

anyone else feel free to beat me up(i know there are a few of you out
there), but I dont see any reason to set maxtextents on anything in
system tablespace.

Joe
[EMAIL PROTECTED] wrote:
> 
> OK Joe,
> 
> I am taking back my suggestionCan you exactly tell me what would happen if
> (maxextents unlimited ) for system tablespace
> 
> As far as i know only datadictionary  and packages(compiled code) reside in
> tablespace SYSTEM.So even if i give maxextents unlimited
> 
> What would happen if no body is creating any objects or whatever in that
> tablespace
> 
> I am a relatively new DBA (6 months you can say)
> 
> Cheers
> Ganti
> 
> ---
> 
> The contents of this e-mail are confidential to the ordinary user
> of the e-mail address to which it was addressed and may also be
> privileged. If you are not the addressee of this e-mail you should
> not copy, forward, disclose or otherwise use it or any part of it
> in any form whatsoever. If you have received this e-mail in error
> please notify us by telephone or e-mail the sender by replying to
> this message, and then delete this e-mail and other copies of it
> from your computer system. Thank you.
> 
> We reserve the right to monitor all e-mail communications through
> our network.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   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).

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  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: Does NT write to random locations on disk?

2001-03-09 Thread Jacques Kilchoer

Title: RE: Does NT write to random locations on disk?





-Original Message-
From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
Sent: vendredi, 9. mars 2001 12:31


> I would have to agree, it is not going to actually defrag the datafile itself.
>  NT defrag is not taking apart files and putting them back together,
> it moves files around.  It is going to consider the db file one big file,
> it might not do anything at all to defrag.


My head is starting to hurt. :( I thought the NT defrag would try to:
a) Make sure all the free blocks on disk were contiguous, and
b) Make sure that the files on disk were in contiguous blocks.
Isn't that right?


Of course, doing a "defrag" on the disk containing the datafiles will do nothing to remedy fragmentation of Oracle tables inside the tablespace.

Nevertheless, I would think that doing an NT "defrag" should not "corrupt" the Oracle data inside the datafiles.


--
any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.

 
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

Re: Re-claiming the space from Table after deleteion

It has always bothered me that Oracle has the compress=Y option on exp, but not a 
maximum initial extent size. We have a table that is larger then 2 gig  and when you 
create an export, the table can't be imported without pre creating the table. If they 
had a max extent in exp, we could set it to maybe 1 gig and never have problems. The 
problem is that an extent must exist in only one data file and most Unix OS's have a 
max file size of 2 gig (though this is changing in new releases)

>>> SHAIBAL TALUKDER <[EMAIL PROTECTED]> 03/09/01 11:31AM >>>

 Raghu,

If you go with compress = y you will end up with one big initial extent which is not 
desirable specifically if you are talking about real big tables.

just my $0.02

Shaibal

  Raghu Kota <[EMAIL PROTECTED]> wrote: 
Hi Rafi

This is the problem many big databases facing!!If you clean up the database 
every year and reorganizing the database You would't have see this scenario. 
For the matter fact iam also facing same problem, My one table grown like 
22G, I simply can't do any thing?? Iam doing just for Indexes Rebuild for 
getting what ever space I can avail. As you said you deleted 40% of data!! 
You can reorganize your Indexes to avail some space.

Other wise Export to Tape and reimport it, But here again problem when you 
say compress=y, due to heavy data Its another big headche??

May be our friends give some ideas???

Thanks
Raghu.

>From: [EMAIL PROTECTED] 
>Reply-To: [EMAIL PROTECTED] 
>To: Multiple recipients of list ORACLE-L 
>Subject: Re-claiming the space from Table after deleteion
>Date: Fri, 09 Mar 2001 01:56:07 -0800
>
>Dear All,
>
> Platform: Solaris 2.6, Oracle: 7.3.4.0
>
>We have a few tables which are growing very fast due to large no of
>insertions. But the data gets obselete after a month and we use a
>procedure to delete the obselete data from the tables.
>
> The problem is that the table does not free the space even after the 
>deletion of 40% of the data.
>
>How can we re-claim the unused space which got created due to deletion?
>
>How do we ensure that future inserts are done in this unused space?
>
>
> [We can not try exp/imp or truncate option
> due to the huge size & high activity and
> online use of the tables].
>
>Kind Regards and thanks to all there,
>
>
>Rafi Ahmad
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>--
>Author:
> 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).

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Raghu Kota
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).

-
Do You Yahoo!?
Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  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: Standby db license for 8.1.6

2001-03-09 Thread Mandar Ghosalkar


Hi Dennis,

In my previous job as a dba in a dot com, it was found db2 to be more
attractive in terms of price/features.

are u including database clients software, hardware for the database server
and backup infrastructure for the concerned databases

would be glad to receive ur summary.

-Mandar

> -Original Message-
> From: Dennis Taylor [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 09, 2001 2:20 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Standby db license for 8.1.6
> 
> 
> I'm in the process of doing comparitive pricing betwwen 
> oracle, sqlserver,
> and db2. Unless someone objects, I'll give a general summary 
> once the info
> is in.
> 
> 
> At 09:35 AM 3/9/01 -0800, you wrote:
> >You can open a standby database in read-only mode
> >now.  How are you going to prove that you are not
> >using it.  Don't get me wrong, I don't agree with
> >Oracle licensing but the argument is off.
> >
> >-Original Message-
> >Sent: Friday, March 09, 2001 7:47 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Yup, they want you to pay for it, because it is an 
> additional x number of
> >processors.  They don't care that it's not really "on" or 
> being accessed.
> >At filefrenzy, this policy actually led us to turn off a few of our
> >processors.  ;-)
> >
> >Diana
> >
> >-Original Message-
> >Sent: Friday, March 09, 2001 9:55 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >If we put together a standby db (SUN 4500) is Oracle going 
> to want more
> >license money?
> >
> >Our thinking is, the license(s) we already own on the 
> production server
> >(also a 4500) cover us to keep the standby db going.  We 
> will not use the
> >stand-by server for anything else.  There will be no user 
> access at all.
> >Our (hungry?) Oracle rep is telling us that this is a clear case of
> >"multiply by existing license(s) by 2", doubling our license 
> costs.  (Let's
> >ignore all of the issues of power unit, named users, etc. for this
> >conversation.)
> >
> >What has your experience been on this license issue for a standby db?
> >
> >
> >Thx
> >
> >  
> >
> >-- 
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >-- 
> >Author: Don Dealy, II
> >  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: Diana Duncan
> >  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: Kimberly Smith
> >  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).
> >
> >
> 
> Dennis Taylor
> 
> Hindsight is always 20-20.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Dennis Taylor
>   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).
>

compare date

2001-03-09 Thread Mitchell


Hi

is there any ADSM  guru here to give me some help?.

I used rman and adsm to backup database  and I want to check the archivelog
by query command at ADSM server
so I can compare it to my oracle server.

Select  count(*) from backups  -- adsm version 3.1 for AIX
where owner = 'rman'   -- owner
and ll_name  like 'Archive_log_s%'   -- our archive log
and node name = 'SP1DB2' -- db name
and backup_date = '01/01/2001'  -- never work  ??? I tried quite few
ways.

Note:  backup_date is timestamp field.


Thanks in Advacne

Mitchell


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mitchell
  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: Forgot password for "internal" , any ideeas what I can do?

2001-03-09 Thread Eddy Confer

Title: RE: Forgot password for "internal" , any ideeas what I can do?





Pankaj
You say that you can change the internal password by connecting as SYS.  Connecting
from where as SYS?  SysMgr.  After I connect do I just issues the alter user command to
change the internal password.


Thanks



-Original Message-
From: Pankaj [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 1:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Forgot password for "internal" , any ideeas what I can do?



Hi Alex,


the default is "oracle" if you have not changed that...in case you do...you
can change that to whatever you want toby connecting through SYS
account..


eNjoy life Technically ;-)


Pankaj


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 09, 2001 11:05 PM



>
> Hi all,
>
> I just forgot the password for internal user, do you have any ideea how I
> can connect as 'SYSDBA'?
> Or how I can recover the password.
>
> Thx, alex.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Berindei Alex
>   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: Pankaj
  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).

(Fwd) RE: (Fwd/Oracle) Does NT write to random locations on di


Apparently the preferred defragger is Norton Utilities:

http://enterprisesecurity.symantec.com/content/productlink.cfm

-

(Symantec Speed Disk 5.1 for Windows NT Info ):

http://enterprisesecurity.symantec.com/products/products.cfm?ProductID=8&PID=3133528

(warning: above URL may wrap)

--- Forwarded message follows ---
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, 
[EMAIL PROTECTED]
Date sent:  Fri, 9 Mar 2001 14:21:03 -0600 

I'm pretty sure ABs preferrence is for SpeedDisk and if so, I'd have to
agree. :)

-Original Message-
Sent: Friday, March 09, 2001 2:19 PM
To: [EMAIL PROTECTED]


Mike,

Yes, I remember seeing discussion of the need for defragging
NT/Win2k servers (and AB's preference for Diskkeeper?).

   http://www.diskeeper.com/diskeeper/diskeeper.asp

I'm guessing the Oracle DBAs are still curious about the
underlying I/O architectural issues involved.

regards,
ep

(cc: via separate fwd to Oracle-L)

On 9 Mar 2001, at 12:00, Mike Soultanian <[EMAIL PROTECTED]> wrote:

Date sent:  Fri, 09 Mar 2001 12:00:50 -0800
To: [EMAIL PROTECTED]
Copies to:  [EMAIL PROTECTED]
locations on disk?

> I don't know the answer to your question, but if you didn't already
> know, there is diskeeper for NT.  Plus, they have a frag guard thing
> that will defrag on the fly, or something like that.  I haven't tried
> it, I just get their newsletter all the time :)
>
> Later,
> mike
>
> "Eric D. Pierce" wrote:
> >
> > --- Forwarded message follows ---
> > Date sent:  Fri, 09 Mar 2001 11:00:31 -0800
> > To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> > From:   "Boivin, Patrice J" <[EMAIL PROTECTED]>
> > Subject:Does NT write to random locations on disk?
> >
> > Using a little utility called contig I noticed that the Oracle 8.1.6
> > datafiles on my test NT server are quite fragmented, an average of 177
> > fragments per file, 118 fragments for the OEM repository datafile.  The
poor
> > utility couldn't do anything with the database files, they are too large
> > perhaps.
> >
> > These were created on an empty server, 8i release 2 went on it after a
> > defrag, then the OEM.  This is on a hard disk with 1.2G of free space,
none
> > of the datafiles come close to that.
> >
> > Why so many fragments?  Oracle created those files in one pass, does NT
> > write randomly to disk or what?
> >
> > Won't this have an impact on my NT database's performance?
> >
> > Oracle says tablespace fragmentation is not a big deal, but
fragmentation at
> > the OS level matters.   Supposedly that's why NT and WndowsXX came with
> > defragmentation tools.
> >
> > ???
> >
> > Is there a registry setting somewhere to tell NT to write contiguously
to
> > disk?

...

--
The WINNT-L list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/winnt-l.html .
--- End of forwarded message ---
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  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-claiming the space from Table after deleteion


The problem with truncating is that you have to release ALL records and the users 
procedure is deleting records older then one month, but not the more current records. 
And while you could move the data into a temp table, truncate, and reinsert the new 
records into the original table, you can't do this and keep the table available to the 
users.

>>> SHAIBAL TALUKDER <[EMAIL PROTECTED]> 03/09/01 11:25AM >>>

 Uttam,

I think you are mixing up here. These are two different issues. You are talking about 
extent allocation and the thread is opened for reclaiming space from a table.

As far as I know one can not reclaim space bellow the high water mark from a table. To 
reclaim the space you have to reduce the high water mark and you can do that by 
truncating.

Thanks

Shaibal


  "Majumdar, Uttam" <[EMAIL PROTECTED]> wrote: 
Provided all extents of the desired table are in same size, the incoming
data should use the free space.
regards;
Uttam majumdar

-Original Message-
Sent: Friday, March 09, 2001 4:56 AM
To: Multiple recipients of list ORACLE-L


Dear All,

Platform: Solaris 2.6, Oracle: 7.3.4.0

We have a few tables which are growing very fast due to large no of
insertions. But the data gets obselete after a month and we use a
procedure to delete the obselete data from the tables. 

The problem is that the table does not free the space even after the
deletion of 40% of the data. 

How can we re-claim the unused space which got created due to deletion?

How do we ensure that future inserts are done in this unused space?


[We can not try exp/imp or truncate option 
due to the huge size & high activity and 
online use of the tables].

Kind Regards and thanks to all there,


Rafi Ahmad



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: 
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).


PG&E National Energy Group and any other
company referenced herein that uses the PG&E name or
logo are not the same company as Pacific Gas and
Electric Company, the regulated California utility. Neither
PG&E National Energy Group nor these other
referenced companies are regulated by the California Public
Utilities Commission. Customers of Pacific Gas and Electric Company
do not have to buy products from these companies in order
to continue to receive quality regulated services from the utility.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Majumdar, Uttam
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).


-
Do You Yahoo!?
Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  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: Standby db license for 8.1.6

2001-03-09 Thread Gene Sais


thats right. if its standy, they charge you, but if you use HA, say ibm sp's, hp mc 
serviceguard, or sun's /veritas trusted cluster, then you save on oracle licensing.  
btw, i heard veritas trusted cluster is a bear to set up (maybe the list can shed more 
light on this).  i never used it, but hp and ibm are pretty straight forward and less 
expensive than oracle licensing.  just my $.02.

>>> [EMAIL PROTECTED] 03/09 2:20 PM >>>


if you are operating in standby mode, then your database needs to be up in
order for you to apply logs from primary database. according to our oracle
rep, we have to pay for that extra license (# of cpus X cpu MHz X 1.5 for
RISC chip) i want to know where they come up with the 1.5.

kris

On Fri, 9 Mar 2001, Gene Sais wrote:

> I've been told the same, but I believe the rep is just trying to increase sales.  If 
>you think about it, you only have 1 license running at 1 time, installed at 1 time, 
>therefore pay for 1 license.  Usually, when you switch to the fail-over, the 
>filesystems are umounted from production and then mounted on the fail-over machine.  
>I don't see how this is 2 licenses, but if you were using the fail-over for a 
>read-only db or test db, then they got you.
> 
> >>> [EMAIL PROTECTED] 03/09 9:55 AM >>>
> If we put together a standby db (SUN 4500) is Oracle going to want more license 
>money?
> 
> Our thinking is, the license(s) we already own on the production server (also a 
>4500) cover us to keep the standby db going.  We will not use the stand-by server for 
>anything else.  There will be no user access at all.  Our (hungry?) Oracle rep is 
>telling us that this is a clear case of "multiply by existing license(s) by 2", 
>doubling our license costs.  (Let's ignore all of the issues of power unit, named 
>users, etc. for this conversation.)
> 
> What has your experience been on this license issue for a standby db?
> 
> 
> Thx
> 
> 
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> --
> Author: Don Dealy, II
>   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: Gene Sais
>   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).
> 

+-+--+-+--+-+-+-+--+-+--+-+
kris austin ... senior database manager, ocp ... advance internet, inc.
   www.advance.net ... [EMAIL PROTECTED] ... 201-459-2805
www.condenet.com ... 212-286-3843
+-+--+-+--+-+-+-+--+-+--+-+
Where there is love there is life. - Mahatma Gandhi 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Kris Austin
  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: Gene Sais
  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-claiming the space from Table after deleteion


yea in the table but not the index, since unless you put the exact same
value for the row the index leaf node will NOT be reused, hence my
statement about the partitioning.

Joe
William Beilstein wrote:
> 
> Also is this really a problem. In the next month you are going to import  more rows 
>which will use the deleted space anyway.
> 
> >>> "Joseph S. Testa" <[EMAIL PROTECTED]> 03/09/01 07:17AM >>>
> sounds like a candidate for partitioning.
> 
> joe
> [EMAIL PROTECTED] wrote:
> >
> > Dear All,
> >
> > Platform: Solaris 2.6, Oracle: 7.3.4.0
> >
> > We have a few tables which are growing very fast due to large no of
> > insertions. But the data gets obselete after a month and we use a
> > procedure to delete the obselete data from the tables.
> >
> > The problem is that the table does not free the space even after the 
>deletion of 40% of the data.
> >
> > How can we re-claim the unused space which got created due to deletion?
> >
> > How do we ensure that future inserts are done in this unused space?
> >
> > [We can not try exp/imp or truncate option
> > due to the huge size  & high activity and
> > online use of the tables].
> >
> > Kind Regards and thanks to all there,
> >
> > Rafi Ahmad
> >
> 
> --
> Joe Testa  http://www.oracle-dba.com
> Performing Remote DBA Services, need some backup DBA support?
> For Sale: Oracle-dba.com domain, its not going cheap but feel free to
> ask:)
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joseph S. Testa
>   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: William Beilstein
>   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).

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  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: Does NT write to random locations on disk?

2001-03-09 Thread Smith, Ron L.

Oracle datafiles are formatted into blocks.  Data is read either physically
by block or an indexed block number.  If you compress using zip and then
uncompress, the blocks have not changed.  If you reorg the file the blocks
will probably change and the data wont be where Oracle thinks it is.

I wouldn't do it.

-Original Message-
Sent: Friday, March 09, 2001 2:31 PM
To: Multiple recipients of list ORACLE-L

Are you talking about a shutdown database, or one started?

(After shutdown) why can I ".zip" the database files on 
Netware3, move them around (copy to DAT, CD, backup directories,
etc., then restore them (potentially in another location), 
and successfully run the database after?

As far as I recall, the db files work "independent" of the
low level allocation details of the OS I/O system.

I would guess running defrag while db is started is 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: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>

> I wouldn't think you would want to reorg an Oracle tablespace with an NT
> defrag utility.  You would corrupt the data.

...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  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: 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-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: Forgot password for "internal" , any ideeas what I can do?


Internal is NOT a user, it is the SYS user opened in a special mode. To connect as 
internal you must have set the Oracle password file to the SYS password and be logged 
onto the server as the Oracle administrative user. On a Unix system this is normally 
the "oracle" user with belongs to the "dba" group.

>>> Eddy Confer <[EMAIL PROTECTED]> 03/09/01 04:10PM >>>
Pankaj
You say that you can change the internal password by connecting as SYS.
Connecting
from where as SYS?  SysMgr.  After I connect do I just issues the alter user
command to
change the internal password.

Thanks


-Original Message-
Sent: Friday, March 09, 2001 1:40 PM
To: Multiple recipients of list ORACLE-L


Hi Alex,

the default is "oracle" if you have not changed that...in case you do...you
can change that to whatever you want toby connecting through SYS
account..

eNjoy life Technically ;-)

Pankaj

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 09, 2001 11:05 PM


>
> Hi all,
>
> I just forgot the password for internal user, do you have any ideea how I
> can connect as 'SYSDBA'?
> Or how I can recover the password.
>
> Thx, alex.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> --
> Author: Berindei Alex
>   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: Pankaj
  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: William Beilstein
  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: Does NT write to random locations on disk?


It hasn't caused me any problems - have only tried it on this test server so
far, and on my workstation.  

The workstation has Oracle 7.3. and 8.0.4 on it they have been running for
over a year.

I wouldn't try this on a production system!  These are test databases only.

I am just curious why the files are so fragmented.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  


-Original Message-
From:   Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, March 09, 2001 3:36 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Does NT write to random locations on disk?

I wouldn't think you would want to reorg an Oracle tablespace with
an NT
defrag utility.  You would corrupt the data.
Ron Smith
Database Administration
[EMAIL PROTECTED]
 

-Original Message-
Sent: Friday, March 09, 2001 1:01 PM
To: Multiple recipients of list ORACLE-L


Using a little utility called contig I noticed that the Oracle 8.1.6
datafiles on my test NT server are quite fragmented, an average of
177
fragments per file, 118 fragments for the OEM repository datafile.
The poor
utility couldn't do anything with the database files, they are too
large
perhaps.

These were created on an empty server, 8i release 2 went on it after
a
defrag, then the OEM.  This is on a hard disk with 1.2G of free
space, none
of the datafiles come close to that.

Why so many fragments?  Oracle created those files in one pass, does
NT
write randomly to disk or what?

Won't this have an impact on my NT database's performance?

Oracle says tablespace fragmentation is not a big deal, but
fragmentation at
the OS level matters.   Supposedly that's why NT and WndowsXX came
with
defragmentation tools.

???

Is there a registry setting somewhere to tell NT to write
contiguously to
disk?

TIA
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  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: 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-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: Boivin, Patrice J
  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-claiming the space from Table after deleteion

2001-03-09 Thread Alex Hillman


You are right. In this case my last point of increasing PCTUSED applies to
hole table.

Alex Hillman

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Raghu Kota
> Sent: Friday, March 09, 2001 1:18 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Re-claiming the space from Table after deleteion
>
>
> Mr Alex
>
> You overlooked imp point that is oracle 7.3
>
>
> >From: "Alex Hillman" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: Re-claiming the space from Table after deleteion
> >Date: Fri, 09 Mar 2001 08:45:57 -0800
> >
> >First of all, as Joe Testa said - if you partitioned this table by date -
> >let say one partition per month - you can truncate partitions that you
> >don't
> >need anymore. Second - if this option is not available - let say that you
> >need delete most but not all records from specific partition - you can
> >create temporary table, select into this table all records that
> should not
> >be deleted, truncate partition and then select into partition all records
> >from temporary table. And last case - if you need to delete let
> say 30-50%
> >of the recors and this table does not have a lot of deletes in everyday
> >activity and most deletes are batch in the end of month or some other
> >period - you can increase value of PCTUSED to 100-PCTFREE-5.
> >
> >Alex Hillman
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
> > > [EMAIL PROTECTED]
> > > Sent: Friday, March 09, 2001 4:56 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re-claiming the space from Table after deleteion
> > >
> > >
> > > Dear All,
> > >
> > >   Platform: Solaris 2.6, Oracle: 7.3.4.0
> > >
> > > We have a few tables which are growing very fast due to large no of
> > > insertions. But the data gets obselete after a month and we use a
> > > procedure to delete the obselete data from the tables.
> > >
> > >   The problem is that the table does not free the space even
> > > after the deletion of 40% of the data.
> > >
> > > How can we re-claim the unused space which got created due to
> deletion?
> > >
> > > How do we ensure that future inserts are done in this unused space?
> > >
> > >
> > >   [We can not try exp/imp or truncate option
> > >   due to the huge size  & high activity and
> > >   online use of the tables].
> > >
> > > Kind Regards and thanks to all there,
> > >
> > >
> > > Rafi Ahmad
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > >   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: Alex Hillman
> >   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).
>
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Raghu Kota
>   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: Alex Hillman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051

RE: Standby db license for 8.1.6

2001-03-09 Thread Gary Weber


Dennis,

PLEASE post your findings! I had to go through similar exercise recently
involving Oracle and Squeal Server, we may want to exchange notes off the
list.

Gary

-Original Message-
Taylor
Sent: Friday, March 09, 2001 3:20 PM
To: Multiple recipients of list ORACLE-L


I'm in the process of doing comparitive pricing betwwen oracle, sqlserver,
and db2. Unless someone objects, I'll give a general summary once the info
is in.


At 09:35 AM 3/9/01 -0800, you wrote:
>You can open a standby database in read-only mode
>now.  How are you going to prove that you are not
>using it.  Don't get me wrong, I don't agree with
>Oracle licensing but the argument is off.
>
>-Original Message-
>Sent: Friday, March 09, 2001 7:47 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Yup, they want you to pay for it, because it is an additional x number of
>processors.  They don't care that it's not really "on" or being accessed.
>At filefrenzy, this policy actually led us to turn off a few of our
>processors.  ;-)
>
>Diana
>
>-Original Message-
>Sent: Friday, March 09, 2001 9:55 AM
>To: Multiple recipients of list ORACLE-L
>
>
>If we put together a standby db (SUN 4500) is Oracle going to want more
>license money?
>
>Our thinking is, the license(s) we already own on the production server
>(also a 4500) cover us to keep the standby db going.  We will not use the
>stand-by server for anything else.  There will be no user access at all.
>Our (hungry?) Oracle rep is telling us that this is a clear case of
>"multiply by existing license(s) by 2", doubling our license costs.  (Let's
>ignore all of the issues of power unit, named users, etc. for this
>conversation.)
>
>What has your experience been on this license issue for a standby db?
>
>
>Thx
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Don Dealy, II
>  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: Diana Duncan
>  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: Kimberly Smith
>  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).
>
>

Dennis Taylor

Hindsight is always 20-20.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dennis Taylor
  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: Gary Weber
  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 cont

RE: Does NT write to random locations on disk?

2001-03-09 Thread Kevin Kostyszyn

Title: RE: Does NT write to random locations on disk?



I 
would have to agree, it is not going to actually defrag the datafile 
itself.  NT defrag is not taking apart files and putting them back 
together, it moves files around.  It is going to consider the db file one 
big file, it might not do anything at all to defrag.
Kev

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Jacques KilchoerSent: 
  Friday, March 09, 2001 3:06 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Does NT write to random locations on 
  disk?
  > -Original Message- > 
  From: Smith, Ron L. [mailto:[EMAIL PROTECTED]] > Sent: vendredi, 9. mars 2001 11:36 > 
  > I wouldn't think you would want to reorg an 
  Oracle tablespace > with an NT > defrag utility.  You would corrupt the data. 
  Forgive my ignorance, but in a datafile on a file-system-based 
  disk, doesn't Oracle go through the OS to access the files on disk? Why would 
  an NT defrag utility cause a problem? I think I'll go try it myself on a test 
  database this week-end (time permitting).

RE: Does NT write to random locations on disk?

Are you talking about a shutdown database, or one started?

(After shutdown) why can I ".zip" the database files on 
Netware3, move them around (copy to DAT, CD, backup directories,
etc., then restore them (potentially in another location), 
and successfully run the database after?

As far as I recall, the db files work "independent" of the
low level allocation details of the OS I/O system.

I would guess running defrag while db is started is 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: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> I wouldn't think you would want to reorg an Oracle tablespace with an NT
> defrag utility.  You would corrupt the data.

...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  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: Standby db license for 8.1.6


I'm in the process of doing comparitive pricing betwwen oracle, sqlserver,
and db2. Unless someone objects, I'll give a general summary once the info
is in.


At 09:35 AM 3/9/01 -0800, you wrote:
>You can open a standby database in read-only mode
>now.  How are you going to prove that you are not
>using it.  Don't get me wrong, I don't agree with
>Oracle licensing but the argument is off.
>
>-Original Message-
>Sent: Friday, March 09, 2001 7:47 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Yup, they want you to pay for it, because it is an additional x number of
>processors.  They don't care that it's not really "on" or being accessed.
>At filefrenzy, this policy actually led us to turn off a few of our
>processors.  ;-)
>
>Diana
>
>-Original Message-
>Sent: Friday, March 09, 2001 9:55 AM
>To: Multiple recipients of list ORACLE-L
>
>
>If we put together a standby db (SUN 4500) is Oracle going to want more
>license money?
>
>Our thinking is, the license(s) we already own on the production server
>(also a 4500) cover us to keep the standby db going.  We will not use the
>stand-by server for anything else.  There will be no user access at all.
>Our (hungry?) Oracle rep is telling us that this is a clear case of
>"multiply by existing license(s) by 2", doubling our license costs.  (Let's
>ignore all of the issues of power unit, named users, etc. for this
>conversation.)
>
>What has your experience been on this license issue for a standby db?
>
>
>Thx
>
>  
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Don Dealy, II
>  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: Diana Duncan
>  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: Kimberly Smith
>  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).
>
>

Dennis Taylor

Hindsight is always 20-20.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dennis Taylor
  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: Standby db license for 8.1.6

2001-03-09 Thread Mohan, Ross

Title: RE: Standby db license for 8.1.6





I'd love to see it. 


Any chance of a peek at WebSphere pricing, et alia?


Thanks!


-Original Message-
From: Dennis Taylor [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 3:20 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Standby db license for 8.1.6



I'm in the process of doing comparitive pricing betwwen oracle, sqlserver,
and db2. Unless someone objects, I'll give a general summary once the info
is in.

Re: RE: guidance for career in US as D.B.A.

2001-03-09 Thread Cyril Thankappan

Hi!

 Maybe this is off topic, but nevertheless
 it is relevant to our lives!

 With economies 'slowing down' globally

 can each of you please tell what is 
 the 'general IT scene'and Oracle scene in particular,
  in your country?

 Thanks
- Original Message --
Mandar Ghosalkar <[EMAIL PROTECTED]> wrote:
To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
From:Mandar Ghosalkar <[EMAIL PROTECTED]>
Date:Wed, 07 Mar 2001 18:20:28 -0800
Subject:RE: guidance for career in US as D.B.A. 

Hi neena

> Hi All ,
>  I am in India . I am an OCP DBA (8i)  
> having three years  IT experience ( Oracle( 7.3, 8 ) and
> Developer2000 , OS -
> windows NT).Three months back I have  joined one of the known 
> company of India.  The role of mine in the present job is
> of DBA. I
> have to handle two Oracle 7.3 databases on AIX of an 
> application which is stable since last five years. As the
> application is stable I am
> not getting good / challenging  exposure to DBA activities. 
First imp thing is that u always be in this situation. once the app becomes
stable u will always find urself idle.

1. Design a Disaster Recovery plan doc for ur db
2. Write db health check routines
3. research and find out how fatal bugs in 7.3 can stop ur production site
4. find out what wld stop (techincally) from migrating to 8i
5. learn AIX

> My aim is to go to US . Can you guide me :
Well the green paper is always yummy...

> 
> 1.. How to get the list of good firms in US , to apply for a 
> DBA post ?
www.dbajobs.com
www.dice.com

> 2. Shall I change my present job , just because the database 
> is of older version ( which I was not knowing while joining
> ) ?
change ur job if u dont hv work. not the question of version. its the
question of what u know in that version. remember versions will keep on
coming.
by the time u come to US and settle here, it may be 9i, who knows. there r
many gurus on this list who r masters in 7.x, cos that what their job
demanded. i met a guy in LA who had worked for NASA and had been working on
almost all types of unixes and oracle 7, was a dba, but hardly knew any
features of 8i. well he didnt found a need to keep up to date. 

> 3. Will certification of Sun Solaris System Administration be 
> helpful to me?
learning an OS never harms. it wld certainly add to ur resume.

> 4. Will an Advanced DBA course ( Oracle parallel server, 
> Replication, distributed DB)  be helpful to me ?
where will u apply that? well u can always learn everything, but try to
balance it against ur job requirements and in which sector of Oracle admin u
want to excel.

For a start why dont u try getting ur OCP in 8i.

> 
> -- neena
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mandar Ghosalkar
  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).

_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cyril  Thankappan
  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: guidance for career in US as D.B.A.

2001-03-09 Thread Cyril Thankappan

Hi!

 Maybe this is off topic, but nevertheless
 it is relevant to our lives!

 With economies 'slowing down' globally

 can each of you please tell what is 
 the 'general IT scene'and Oracle scene in particular,
  in your country?

 Thanks
- Original Message --
Mandar Ghosalkar <[EMAIL PROTECTED]> wrote:
To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
From:Mandar Ghosalkar <[EMAIL PROTECTED]>
Date:Wed, 07 Mar 2001 18:20:28 -0800
Subject:RE: guidance for career in US as D.B.A. 

Hi neena

> Hi All ,
>  I am in India . I am an OCP DBA (8i)  
> having three years  IT experience ( Oracle( 7.3, 8 ) and
> Developer2000 , OS -
> windows NT).Three months back I have  joined one of the known 
> company of India.  The role of mine in the present job is
> of DBA. I
> have to handle two Oracle 7.3 databases on AIX of an 
> application which is stable since last five years. As the
> application is stable I am
> not getting good / challenging  exposure to DBA activities. 
First imp thing is that u always be in this situation. once the app becomes
stable u will always find urself idle.

1. Design a Disaster Recovery plan doc for ur db
2. Write db health check routines
3. research and find out how fatal bugs in 7.3 can stop ur production site
4. find out what wld stop (techincally) from migrating to 8i
5. learn AIX

> My aim is to go to US . Can you guide me :
Well the green paper is always yummy...

> 
> 1.. How to get the list of good firms in US , to apply for a 
> DBA post ?
www.dbajobs.com
www.dice.com

> 2. Shall I change my present job , just because the database 
> is of older version ( which I was not knowing while joining
> ) ?
change ur job if u dont hv work. not the question of version. its the
question of what u know in that version. remember versions will keep on
coming.
by the time u come to US and settle here, it may be 9i, who knows. there r
many gurus on this list who r masters in 7.x, cos that what their job
demanded. i met a guy in LA who had worked for NASA and had been working on
almost all types of unixes and oracle 7, was a dba, but hardly knew any
features of 8i. well he didnt found a need to keep up to date. 

> 3. Will certification of Sun Solaris System Administration be 
> helpful to me?
learning an OS never harms. it wld certainly add to ur resume.

> 4. Will an Advanced DBA course ( Oracle parallel server, 
> Replication, distributed DB)  be helpful to me ?
where will u apply that? well u can always learn everything, but try to
balance it against ur job requirements and in which sector of Oracle admin u
want to excel.

For a start why dont u try getting ur OCP in 8i.

> 
> -- neena
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mandar Ghosalkar
  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).

_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cyril  Thankappan
  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: Does NT write to random locations on disk?

2001-03-09 Thread Mohan, Ross

Title: RE: Does NT write to random locations on disk?





maybe you could move the database to unix, reorg
it with a *unix* defrag utility, and then it would
work?


Check into TsReorg by Platinum ( used to be called
that, at least.) Actually worked well for smallish
dbms'.


hth


-Original Message-
From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 2:36 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Does NT write to random locations on disk?



I wouldn't think you would want to reorg an Oracle tablespace with an NT
defrag utility.  You would corrupt the data.
Ron Smith
Database Administration
[EMAIL PROTECTED]
 


-Original Message-
Sent: Friday, March 09, 2001 1:01 PM
To: Multiple recipients of list ORACLE-L



Using a little utility called contig I noticed that the Oracle 8.1.6
datafiles on my test NT server are quite fragmented, an average of 177
fragments per file, 118 fragments for the OEM repository datafile.  The poor
utility couldn't do anything with the database files, they are too large
perhaps.


These were created on an empty server, 8i release 2 went on it after a
defrag, then the OEM.  This is on a hard disk with 1.2G of free space, none
of the datafiles come close to that.


Why so many fragments?  Oracle created those files in one pass, does NT
write randomly to disk or what?


Won't this have an impact on my NT database's performance?


Oracle says tablespace fragmentation is not a big deal, but fragmentation at
the OS level matters.   Supposedly that's why NT and WndowsXX came with
defragmentation tools.


???


Is there a registry setting somewhere to tell NT to write contiguously to
disk?


TIA
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services    | Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO


E-Mail: [EMAIL PROTECTED]  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  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: 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-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: Does NT write to random locations on disk?

2001-03-09 Thread Jacques Kilchoer

Title: RE: Does NT write to random locations on disk?





> -Original Message-
> From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
> Sent: vendredi, 9. mars 2001 11:36
> 
> I wouldn't think you would want to reorg an Oracle tablespace 
> with an NT
> defrag utility.  You would corrupt the data.


Forgive my ignorance, but in a datafile on a file-system-based disk, doesn't Oracle go through the OS to access the files on disk? Why would an NT defrag utility cause a problem? I think I'll go try it myself on a test database this week-end (time permitting).

Need RMAN script command to close database

2001-03-09 Thread Berindei Alex



Hi smart guys,

I need a RMAN script command to close a database, do you think this can be
done.

What I know is I can start the database, for "MOUNT" state to "OPEN" with
next script, using a SQL command:

{
  allocate channel type disk 
  sql 'ALTER DATABASE OPEN';
}

What I have?
I have an open database in NOARCHIVE log mode (don't ask why) which I want
to backup. 
What I want?
To put database in MOUNT state from RMAN script, backup whole database,
reopen the database.
{
HERE NEED COMMAND TO PUT DATABASE IN MOUNT STATE
  allocate channel type disk 
  backup  whole database in MOUNT state
  sql 'ALTER DATABASE OPEN';
}

Thanks alex.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Berindei Alex
  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: (Fwd) Oracle's Savings Don't Add Up

2001-03-09 Thread Jim Conboy


Well well well.

I'm quite distressed to hear that Oracle's been shutting down and selling off servers 
like mad, but Metalink doesn't have the hardware it needs to run smoothly.  And some 
of their 'savings' are not spending less but keeping costs growing slower than 
revenues.  Reminds me of when my wife 'saves' a bundle on furniture, hard to retire on 
that kind of 'savings'.  But on the whole Oracle's cost-cutting seems pretty 
impressive and I don't think they deserved the negative headline.  If it keeps my 
bills from climbing even higher I'm all for it.

Jim

>>> [EMAIL PROTECTED] 03/09/01 02:05PM >>>

--- Forwarded message follows ---
To: [EMAIL PROTECTED] 
Date sent:  Fri,  9 Mar 2001 02:04:02 -0500 (EST)

TODAY'S NEWS

*  Oracle's Savings Don't Add Up
*  Web-Powered HR
*  TRANSFORMATION TODAY: Collective Wisdom
*  OPINION: Want E-Biz Influence? Be Ready For The Fallout
*  How Wall Street Reacted
=

...

***
Oracle's Savings Don't Add Up

Don't buy into Oracle's claims that it's saving billions of dollars by implementing 
its own e-business software. Much of the savings actually have come from cost-cutting 
measures that could have been achieved without the Internet, according to experts and 
an analysis of Oracle's financial 
statements.

Oracle has achieved impressive savings--hundreds of millions of dollars, in fact--by 
re-engineering business processes around the Internet. But it looks like Oracle isn't 
going to slide in safely this year or next on the many more billions it has promised 
to save.--Mitch Wagner

So where's the money? Read on:
http://update.internetweek.com/cgi-bin4/flo?y=eCsd0BdpN70V30LbsD 

Do you believe Oracle's claim that it's saving billions of dollars through the use of 
its own software and the Internet? Answer our Reader Poll:
http://update.internetweek.com/cgi-bin4/flo?y=eCsd0BdpN70V30LbtE 
 **

...


=
This issue is sponsored by NetReality,
Provider of the WiseWan application Priority Switch
Are your mission-critical applications running slow? Are you tired of
wasting precious dollars on unecessary bandwidth? SPEED SAP --
BOOST BAAN -- SUPERCHARGE CITRIX NetReality brings network
delivery assurance and allows you to control business priorities--in 
real time. For a FREE QoS analysis, log on to:
http://update.internetweek.com/cgi-bin4/flo?y=eCsd0BdpN70V30DURJ 

=

...

This message powered by FloNetwork
http://www.flonetwork.com 
--- End of forwarded message ---


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Eric D. Pierce
  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: Jim Conboy
  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: OEM 2.2 Oracle 8.1.7 on NT


Are you sure you have enough memory?

I notice on my test server, it doesn't matter how much virtual memory you
have, it's the physical RAM that counts.

As soon as my machine reached about 360M used (about 388M of physical RAM
was on it), the Management Server Service stopped and of course then you can
no longer connect to the OEM console.

Watch the CPU usage as well, dbsnmp uses CPU at regular intervals and keeps
CPU usage up near 100% in prolonged bursts.

I received more RAM for my test server today, I'm happy.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  


-Original Message-
From:   Ron Rogers [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, March 09, 2001 3:11 PM
To: Multiple recipients of list ORACLE-L
Subject:OEM 2.2 Oracle 8.1.7 on NT

List,
 I have a test server running NT 4.0 sp6a, Oracle 8.1.7 rel 3 with
the OEM 2.2 working real good. I added a printer and shared the drives and
printer with the developers. That's when the stuff hit the fan... I tried to
log into the OEM console and the error message said "VTK-1000 Unable to
connect to the management server testora". It appeared that the
sysman/password were changed.
I used the Oracle installer and removed the OEM and tried a
reinstall to get back to the initial startup uf the console connection where
the sysman/oem_temp is the id/password. No luck. I need info on where the
password is stored or how to completely remove the package and registry
entries. Can OEM be installed in a new location and work properly after I
remove the original?
 Thanks,
ROR mª¿ªm

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron Rogers
  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: Boivin, Patrice J
  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: Standby db license for 8.1.6

2001-03-09 Thread Kris Austin




if you are operating in standby mode, then your database needs to be up in
order for you to apply logs from primary database. according to our oracle
rep, we have to pay for that extra license (# of cpus X cpu MHz X 1.5 for
RISC chip) i want to know where they come up with the 1.5.

kris

On Fri, 9 Mar 2001, Gene Sais wrote:

> I've been told the same, but I believe the rep is just trying to increase sales.  If 
>you think about it, you only have 1 license running at 1 time, installed at 1 time, 
>therefore pay for 1 license.  Usually, when you switch to the fail-over, the 
>filesystems are umounted from production and then mounted on the fail-over machine.  
>I don't see how this is 2 licenses, but if you were using the fail-over for a 
>read-only db or test db, then they got you.
> 
> >>> [EMAIL PROTECTED] 03/09 9:55 AM >>>
> If we put together a standby db (SUN 4500) is Oracle going to want more license 
>money?
> 
> Our thinking is, the license(s) we already own on the production server (also a 
>4500) cover us to keep the standby db going.  We will not use the stand-by server for 
>anything else.  There will be no user access at all.  Our (hungry?) Oracle rep is 
>telling us that this is a clear case of "multiply by existing license(s) by 2", 
>doubling our license costs.  (Let's ignore all of the issues of power unit, named 
>users, etc. for this conversation.)
> 
> What has your experience been on this license issue for a standby db?
> 
> 
> Thx
> 
> 
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> --
> Author: Don Dealy, II
>   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: Gene Sais
>   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).
> 

+-+--+-+--+-+-+-+--+-+--+-+
kris austin ... senior database manager, ocp ... advance internet, inc.
   www.advance.net ... [EMAIL PROTECTED] ... 201-459-2805
www.condenet.com ... 212-286-3843
+-+--+-+--+-+-+-+--+-+--+-+
Where there is love there is life. - Mahatma Gandhi 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kris Austin
  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: Does NT write to random locations on disk?


(I'll forward your q to the following NT list)
In case you don't get any answer here, here is info for a 
good NT SysAdmn list where you can ask OS specific questions:

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
Date sent: Fri, 9 Mar 2001 13:21:06 -0500
Send reply to: Windows NT/2000 Discussion List <[EMAIL PROTECTED]>
To: Recipients of WINNT-L digests <[EMAIL PROTECTED]>

...

--
The WINNT-L list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info and
archives, see http://peach.ease.lsoft.com/archives/winnt-l.html .

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  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).

OEM 2.2 Oracle 8.1.7 on NT

2001-03-09 Thread Ron Rogers


List,
 I have a test server running NT 4.0 sp6a, Oracle 8.1.7 rel 3 with the OEM 2.2 working 
real good. I added a printer and shared the drives and printer with the developers. 
That's when the stuff hit the fan... I tried to log into the OEM console and the error 
message said "VTK-1000 Unable to connect to the management server testora". It 
appeared that the sysman/password were changed.
I used the Oracle installer and removed the OEM and tried a reinstall to get back to 
the initial startup uf the console connection where the sysman/oem_temp is the 
id/password. No luck. I need info on where the password is stored or how to completely 
remove the package and registry entries. Can OEM be installed in a new location and 
work properly after I remove the original?
 Thanks,
ROR mª¿ªm

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  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: Does NT write to random locations on disk?

2001-03-09 Thread Smith, Ron L.


I wouldn't think you would want to reorg an Oracle tablespace with an NT
defrag utility.  You would corrupt the data.
Ron Smith
Database Administration
[EMAIL PROTECTED]
 

-Original Message-
Sent: Friday, March 09, 2001 1:01 PM
To: Multiple recipients of list ORACLE-L


Using a little utility called contig I noticed that the Oracle 8.1.6
datafiles on my test NT server are quite fragmented, an average of 177
fragments per file, 118 fragments for the OEM repository datafile.  The poor
utility couldn't do anything with the database files, they are too large
perhaps.

These were created on an empty server, 8i release 2 went on it after a
defrag, then the OEM.  This is on a hard disk with 1.2G of free space, none
of the datafiles come close to that.

Why so many fragments?  Oracle created those files in one pass, does NT
write randomly to disk or what?

Won't this have an impact on my NT database's performance?

Oracle says tablespace fragmentation is not a big deal, but fragmentation at
the OS level matters.   Supposedly that's why NT and WndowsXX came with
defragmentation tools.

???

Is there a registry setting somewhere to tell NT to write contiguously to
disk?

TIA
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  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: 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-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).

(Fwd) Oracle's Savings Don't Add Up



--- Forwarded message follows ---
To: [EMAIL PROTECTED]
Date sent:  Fri,  9 Mar 2001 02:04:02 -0500 (EST)

TODAY'S NEWS

*  Oracle's Savings Don't Add Up
*  Web-Powered HR
*  TRANSFORMATION TODAY: Collective Wisdom
*  OPINION: Want E-Biz Influence? Be Ready For The Fallout
*  How Wall Street Reacted
=

...

***
Oracle's Savings Don't Add Up

Don't buy into Oracle's claims that it's saving billions of dollars by implementing 
its own e-business software. Much of the savings actually have come from cost-cutting 
measures that could have been achieved without the Internet, according to experts and 
an analysis of Oracle's financial 
statements.

Oracle has achieved impressive savings--hundreds of millions of dollars, in fact--by 
re-engineering business processes around the Internet. But it looks like Oracle isn't 
going to slide in safely this year or next on the many more billions it has promised 
to save.--Mitch Wagner

So where's the money? Read on:
http://update.internetweek.com/cgi-bin4/flo?y=eCsd0BdpN70V30LbsD

Do you believe Oracle's claim that it's saving billions of dollars through the use of 
its own software and the Internet? Answer our Reader Poll:
http://update.internetweek.com/cgi-bin4/flo?y=eCsd0BdpN70V30LbtE
 **

...


=
This issue is sponsored by NetReality,
Provider of the WiseWan application Priority Switch
Are your mission-critical applications running slow? Are you tired of
wasting precious dollars on unecessary bandwidth? SPEED SAP --
BOOST BAAN -- SUPERCHARGE CITRIX NetReality brings network
delivery assurance and allows you to control business priorities--in 
real time. For a FREE QoS analysis, log on to:
http://update.internetweek.com/cgi-bin4/flo?y=eCsd0BdpN70V30DURJ

=

...

This message powered by FloNetwork
http://www.flonetwork.com
--- End of forwarded message ---


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  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).

Does NT write to random locations on disk?


Using a little utility called contig I noticed that the Oracle 8.1.6
datafiles on my test NT server are quite fragmented, an average of 177
fragments per file, 118 fragments for the OEM repository datafile.  The poor
utility couldn't do anything with the database files, they are too large
perhaps.

These were created on an empty server, 8i release 2 went on it after a
defrag, then the OEM.  This is on a hard disk with 1.2G of free space, none
of the datafiles come close to that.

Why so many fragments?  Oracle created those files in one pass, does NT
write randomly to disk or what?

Won't this have an impact on my NT database's performance?

Oracle says tablespace fragmentation is not a big deal, but fragmentation at
the OS level matters.   Supposedly that's why NT and WndowsXX came with
defragmentation tools.

???

Is there a registry setting somewhere to tell NT to write contiguously to
disk?

TIA
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
  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: Forgot password for "internal" , any ideeas what I can do?

2001-03-09 Thread Pankaj


Hi Alex,

the default is "oracle" if you have not changed that...in case you do...you
can change that to whatever you want toby connecting through SYS
account..

eNjoy life Technically ;-)

Pankaj

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 09, 2001 11:05 PM


>
> Hi all,
>
> I just forgot the password for internal user, do you have any ideea how I
> can connect as 'SYSDBA'?
> Or how I can recover the password.
>
> Thx, alex.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Berindei Alex
>   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: Pankaj
  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-claiming the space from Table after deleteion

2001-03-09 Thread Raghu Kota


Mr Alex

You overlooked imp point that is oracle 7.3


>From: "Alex Hillman" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Re-claiming the space from Table after deleteion
>Date: Fri, 09 Mar 2001 08:45:57 -0800
>
>First of all, as Joe Testa said - if you partitioned this table by date -
>let say one partition per month - you can truncate partitions that you 
>don't
>need anymore. Second - if this option is not available - let say that you
>need delete most but not all records from specific partition - you can
>create temporary table, select into this table all records that should not
>be deleted, truncate partition and then select into partition all records
>from temporary table. And last case - if you need to delete let say 30-50%
>of the recors and this table does not have a lot of deletes in everyday
>activity and most deletes are batch in the end of month or some other
>period - you can increase value of PCTUSED to 100-PCTFREE-5.
>
>Alex Hillman
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
> > [EMAIL PROTECTED]
> > Sent: Friday, March 09, 2001 4:56 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re-claiming the space from Table after deleteion
> >
> >
> > Dear All,
> >
> > Platform: Solaris 2.6, Oracle: 7.3.4.0
> >
> > We have a few tables which are growing very fast due to large no of
> > insertions. But the data gets obselete after a month and we use a
> > procedure to delete the obselete data from the tables.
> >
> > The problem is that the table does not free the space even
> > after the deletion of 40% of the data.
> >
> > How can we re-claim the unused space which got created due to deletion?
> >
> > How do we ensure that future inserts are done in this unused space?
> >
> >
> > [We can not try exp/imp or truncate option
> > due to the huge size  & high activity and
> > online use of the tables].
> >
> > Kind Regards and thanks to all there,
> >
> >
> > Rafi Ahmad
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> >   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: Alex Hillman
>   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).

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raghu Kota
  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: NT install problem ???

2001-03-09 Thread Kevin Kostyszyn


Is this a networeked PC?
Kev

-Original Message-
Sent: Friday, March 09, 2001 11:40 AM
To: Multiple recipients of list ORACLE-L


Hi all,

When I installed Oracle Enterprise Editon 8.1.5 to NT
4.0, I got this:  12570, 0, "TNS:packet reader
failure"

12570, 0, "TNS:packet reader failure"
// *Cause: An error occurred during a data receive.
// *Action: Not normally visible to the user. For
further details, turn
// on tracing and reexecute the operation. If error
persists, contact
// Oracle Customer Support.

I clicked ignore, Oracle run for a minute and show
that Create db assistant not installed successfully.

Anyone knows why did this happen and how to solve the
problem?  Much appreciated.

Leslie


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  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: Kevin Kostyszyn
  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:imp (import) problem

2001-03-09 Thread GANTI . SIVA




You must have used compress=y,rather you should use  compress=n

OK then create index file and then edit for that table or schema  change
initial extent to lesser value..

Cheers
Ganti



---

The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this e-mail in error
please notify us by telephone or e-mail the sender by replying to
this message, and then delete this e-mail and other copies of it
from your computer system. Thank you.

We reserve the right to monitor all e-mail communications through
our network.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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: imp (import) problem

2001-03-09 Thread Ron Rogers


Joe,
There is not enough contigius free space in the tablespace DAILYCYCLE01A 
for the import to create the segment you are importing. Check the size of the 
segment on the original database and make sure you have the space 
available on the import server. You can always increate the size of the 
tablespace by increasing the size of the datafile or ading a datafile to
the tablespace.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 03/09/01 10:40AM >>>
While importing a huge table (AIX) I get this problem:
and the progam seems to hang up. Help! I'm still new
to ORACLE databases.

IMP-3: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace
DAILYCYCLE01A

TIA
Joe
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Leyden, Joseph
  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: Ron Rogers
  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: Standby db license for 8.1.6

2001-03-09 Thread Kimberly Smith


You can open a standby database in read-only mode
now.  How are you going to prove that you are not
using it.  Don't get me wrong, I don't agree with
Oracle licensing but the argument is off.

-Original Message-
Sent: Friday, March 09, 2001 7:47 AM
To: Multiple recipients of list ORACLE-L


Yup, they want you to pay for it, because it is an additional x number of
processors.  They don't care that it's not really "on" or being accessed.
At filefrenzy, this policy actually led us to turn off a few of our
processors.  ;-)

Diana

-Original Message-
Sent: Friday, March 09, 2001 9:55 AM
To: Multiple recipients of list ORACLE-L


If we put together a standby db (SUN 4500) is Oracle going to want more
license money?

Our thinking is, the license(s) we already own on the production server
(also a 4500) cover us to keep the standby db going.  We will not use the
stand-by server for anything else.  There will be no user access at all.
Our (hungry?) Oracle rep is telling us that this is a clear case of
"multiply by existing license(s) by 2", doubling our license costs.  (Let's
ignore all of the issues of power unit, named users, etc. for this
conversation.)

What has your experience been on this license issue for a standby db?


Thx

  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don Dealy, II
  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: Diana Duncan
  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: Kimberly Smith
  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-claiming the space from Table after deleteion

2001-03-09 Thread SHAIBAL TALUKDER

 Raghu,
If you go with compress = y you will end up with one big initial extent which is not desirable specifically if you are talking about real big tables.
just my $0.02
Shaibal
  Raghu Kota <[EMAIL PROTECTED]> wrote: 
Hi RafiThis is the problem many big databases facing!!If you clean up the database every year and reorganizing the database You would't have see this scenario. For the matter fact iam also facing same problem, My one table grown like 22G, I simply can't do any thing?? Iam doing just for Indexes Rebuild for getting what ever space I can avail. As you said you deleted 40% of data!! You can reorganize your Indexes to avail some space.Other wise Export to Tape and reimport it, But here again problem when you say compress=y, due to heavy data Its another big headche??May be our friends give some ideas???ThanksRaghu.>From: [EMAIL PROTECTED]>Reply-To: [EMAIL PROTECTED]>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>>Subject: Re-claiming the space from Table after deleteion!
!
>Date: Fri, 09 Mar 2001 01:56:07 -0800>>Dear All,>> Platform: Solaris 2.6, Oracle: 7.3.4.0>>We have a few tables which are growing very fast due to large no of>insertions. But the data gets obselete after a month and we use a>procedure to delete the obselete data from the tables.>> The problem is that the table does not free the space even after the >deletion of 40% of the data.>>How can we re-claim the unused space which got created due to deletion?>>How do we ensure that future inserts are done in this unused space?>>> [We can not try exp/imp or truncate option> due to the huge size & high activity and> online use of the tables].>>Kind Regards and thanks to all there,>>>Rafi Ahmad-->Please see the official ORACLE-L FAQ: http://www.orafaq.com>-->Author:> 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)._Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Raghu KotaINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5!
!
051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!?
Yahoo! Mail Personal Address - 
Get email at your own domain with Yahoo! Mail.

RE: Standby db license for 8.1.6

2001-03-09 Thread Ruiz, Mary A (CAP, CDI)


Don:
  This may not have any bearing on you because you are using Sun.  I attended a free 
seminar put on by Oracle and HP on "Continuity" and learned about this concept. I am 
not sure
if it is available now or soon to be available.  HP would set you up with more 
processors than you need, but only charge you for the processors in use.  Once the 
additional
processors kicked in, (business suddenly picked up, for example), you would be charged 
for them.  Somehow they would notify HP support of their activity.  And, likewise for 
Oracle
licensing.  So I would be baffled that you would have to pay for processor-based 
licenses when no usage of the database is taking place.

Mary Ruiz / Atlanta GA
-Original Message-
Sent: Friday, March 09, 2001 9:55 AM
To: Multiple recipients of list ORACLE-L


If we put together a standby db (SUN 4500) is Oracle going to want more
license money?

Our thinking is, the license(s) we already own on the production server
(also a 4500) cover us to keep the standby db going.  We will not use the
stand-by server for anything else.  There will be no user access at all.
Our (hungry?) Oracle rep is telling us that this is a clear case of
"multiply by existing license(s) by 2", doubling our license costs.  (Let's
ignore all of the issues of power unit, named users, etc. for this
conversation.)

What has your experience been on this license issue for a standby db?


Thx

  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don Dealy, II
  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: Diana Duncan
  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: Ruiz, Mary A (CAP, CDI)
  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: ScanMail Message: To Sender, sensitive content found and

2001-03-09 Thread Vinod Nagaraj


hey even i am from lakewood, colorado

vinod

"Troiano, Paul (CAP, GEFA)" wrote:

> I guess that would be me...
>
> Looks like our exchange server's address (the LAK means Lakewood, CO and I'm the 
>only one here on the list). GE does scan is done at the corporate level. I don't 
>usually pay any attention to it. This is the first time I've heard of anything like 
>this. GE Financial Assurance is no
> longer part of GE Capital.
>
> - Paul Troiano
>
> -Original Message-
> From:   John Dailey [mailto:[EMAIL PROTECTED]]
> Sent:   Thursday, March 08, 2001 4:21 PM
> To: Multiple recipients of list ORACLE-L
> Subject:RE: ScanMail Message: To Sender, sensitive content 
>found and
>
> I agree completely Joe this is pathetic.
>
> Since it's GE Capital, I wonder if they scan outgoing mail for crappy
> interest rates on new loans??  I doubt it...
>
> -Original Message-
> Testa
> Sent: Thursday, March 08, 2001 5:15 PM
> To: Multiple recipients of list ORACLE-L
>
> I don't know but i vote for them to be removed from the list, when i
> work for a compnay that starts screening my email for me, i'll quit
> thats for sure.
>
> the place i work for, i know the admins and they dont do that kind of
> garbage.
>
> joe
> [EMAIL PROTECTED] wrote:
> >
> > OK, who have we got who works at Ge Capital?
> >
> > Dick Goulet
> >
> > Reply Separator
> > Author: System Attendant <[EMAIL PROTECTED]>
> > Date:   3/8/2001 2:22 PM
> >
> > Trend SMEX Content Filter has detected sensitive content.
> >
> > Place = Multiple recipients of list ORACLE-L; ; ; 
>[EMAIL PROTECTED]
> > Sender = [EMAIL PROTECTED]
> > Subject = Re:RE: Life in New England
> > Delivery Time = March 08, 2001 (Thursday) 12:22:24
> > Policy = Sexual Discrimination
> > Action on this mail = Quarantine message
> >
> > Warning message from administrator:
> > Notice: A message you sent appears to have violated GE Financial 
>Assurance
> email
> > policies for inappropriate language or content and may not have 
>been
> received by
> > the recipient.
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> >   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).
>
> --
> Joe Testa  http://www.oracle-dba.com
> Performing Remote DBA Services, need some backup DBA support?
> For Sale: Oracle-dba.com domain, its not going cheap but feel free to
> ask :)
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joseph S. Testa
>   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
> --
>

Forgot password for "internal" , any ideeas what I can do?

2001-03-09 Thread Berindei Alex



Hi all,

I just forgot the password for internal user, do you have any ideea how I
can connect as 'SYSDBA'?
Or how I can recover the password.

Thx, alex.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Berindei Alex
  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-claiming the space from Table after deleteion

2001-03-09 Thread SHAIBAL TALUKDER

Uttam,
I think you are mixing up here. These are two different issues. You are talking about extent allocation and the thread is opened for reclaiming space from a table.
As far as I know one can not reclaim space bellow the high water mark from a table. To reclaim the space you have to reduce the high water mark and you can do that by truncating.
Thanks
Shaibal
"Majumdar, Uttam" <[EMAIL PROTECTED]> wrote:
Provided all extents of the desired table are in same size, the incomingdata should use the free space.regards;Uttam majumdar-Original Message-Sent: Friday, March 09, 2001 4:56 AMTo: Multiple recipients of list ORACLE-LDear All,Platform: Solaris 2.6, Oracle: 7.3.4.0We have a few tables which are growing very fast due to large no ofinsertions. But the data gets obselete after a month and we use aprocedure to delete the obselete data from the tables. The problem is that the table does not free the space even after thedeletion of 40% of the data. How can we re-claim the unused space which got created due to deletion?How do we ensure that future inserts are done in this unused space?[We can not try exp/imp or truncate option due to the huge size & high activity and online !
!
use of the tables].Kind Regards and thanks to all there,Rafi Ahmad-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).PG&E National Energy Group and any othercompany referenced herein that uses the PG&E name orlogo are not the same company as Pacific Gas andElectric Company, the regulated California utility. Ne!
!
itherPG&E National Energy Group nor these otherreferenced companies are regulated by the California PublicUtilities Commission. Customers of Pacific Gas and Electric Companydo not have to buy products from these companies in orderto continue to receive quality regulated services from the utility.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Majumdar, UttamINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other inform!
!
ation (like subscribing).Do You Yahoo!?
Yahoo! Mail Personal Address -
Get email at your own domain with Yahoo! Mail.

Re: Weird - unable to extend err

2001-03-09 Thread GANTI . SIVA




OK Joe,

I am taking back my suggestionCan you exactly tell me what would happen if
(maxextents unlimited ) for system tablespace

As far as i know only datadictionary  and packages(compiled code) reside in
tablespace SYSTEM.So even if i give maxextents unlimited

What would happen if no body is creating any objects or whatever in that
tablespace

I am a relatively new DBA (6 months you can say)

Cheers
Ganti



---

The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this e-mail in error
please notify us by telephone or e-mail the sender by replying to
this message, and then delete this e-mail and other copies of it
from your computer system. Thank you.

We reserve the right to monitor all e-mail communications through
our network.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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-claiming the space from Table after deleteion

2001-03-09 Thread Ron Rogers

Rafi,
Space usage has always been a problem. When you insert into a table the High Water 
Mark (HW) for the table is raised for each record inserted. The HW will remain at that 
point untill you export, truncate, import again. To manage the space you should set 
the percent free and percent used parameters on the table effectively. 
A high pctfree will only fill the block up to that point and allow for updates to the 
records to be contained in the original block. A low pctused will keep the block off 
of the free list and not allow inserts into the block untill enough data has been 
deleted from the block to reach that threshold. If you balance the thresholds properly 
the block will be placed on the free list and the new inserts will be placed on the 
blocks that have free space and not raise your HW mark. The changes you make to the 
pctfree and pctused parameters do not both take effect on the currect and future data. 
I believe the pctused will effect all blocks and the pctfree only effects new blocks.
 A more detailed decsription is found in the doc's.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 03/09/01 08:45AM >>>
Also is this really a problem. In the next month you are going to import  more rows 
which will use the deleted space anyway.

>>> "Joseph S. Testa" <[EMAIL PROTECTED]> 03/09/01 07:17AM >>>
sounds like a candidate for partitioning.

joe
[EMAIL PROTECTED] wrote:
> 
> Dear All,
> 
> Platform: Solaris 2.6, Oracle: 7.3.4.0
> 
> We have a few tables which are growing very fast due to large no of
> insertions. But the data gets obselete after a month and we use a
> procedure to delete the obselete data from the tables.
> 
> The problem is that the table does not free the space even after the 
>deletion of 40% of the data.
> 
> How can we re-claim the unused space which got created due to deletion?
> 
> How do we ensure that future inserts are done in this unused space?
> 
> [We can not try exp/imp or truncate option
> due to the huge size  & high activity and
> online use of the tables].
> 
> Kind Regards and thanks to all there,
> 
> Rafi Ahmad
>

-- 
Joe Testa  http://www.oracle-dba.com 
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Joseph S. Testa
  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: William Beilstein
  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: Ron Rogers
  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: Standby db license for 8.1.6

2001-03-09 Thread Steve Orr


> Our thinking is, the license(s) we already own on the production server
> (also a 4500) cover us to keep the standby db going.

How absurd of you to suggest that Oracle licensing should be logical,
ethical, and make common sense. :>)


-Original Message-
Sent: Friday, March 09, 2001 7:41 AM
To: Multiple recipients of list ORACLE-L


I've been told the same, but I believe the rep is just trying to increase
sales.  If you think about it, you only have 1 license running at 1 time,
installed at 1 time, therefore pay for 1 license.  Usually, when you switch
to the fail-over, the filesystems are umounted from production and then
mounted on the fail-over machine.  I don't see how this is 2 licenses, but
if you were using the fail-over for a read-only db or test db, then they got
you.

>>> [EMAIL PROTECTED] 03/09 9:55 AM >>>
If we put together a standby db (SUN 4500) is Oracle going to want more
license money?

Our thinking is, the license(s) we already own on the production server
(also a 4500) cover us to keep the standby db going.  We will not use the
stand-by server for anything else.  There will be no user access at all.
Our (hungry?) Oracle rep is telling us that this is a clear case of
"multiply by existing license(s) by 2", doubling our license costs.  (Let's
ignore all of the issues of power unit, named users, etc. for this
conversation.)

What has your experience been on this license issue for a standby db?


Thx

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Orr
  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: Weird - unable to extend error

2001-03-09 Thread Paul Baumgartel


I'm not so sure.


Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)


-Original Message-
Sent: Friday, March 09, 2001 9:55 AM
To: Multiple recipients of list ORACLE-L


Sorry Paul,

Do not pass Go and do not collect 200 quid. One of the other guys in here
had logged in as system and was creating an index, his temporary tablespace
was set to SYSTEM and therefore Joe's diagnosis below was correct.

> Lee Robertson
> Acxiom
> Tel:  0191 525 7344
> Fax:  0191 525 7007
> Email: [EMAIL PROTECTED]
> 


-Original Message-
Sent: 09 March 2001 14:26
To: Multiple recipients of list ORACLE-L


In this case the "temporary segment" was not a sort segment, but the space
allocated for an index while under construction.  I'm surprised that no one
here caught that!


Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)


-Original Message-
Sent: Friday, March 09, 2001 7:17 AM
To: Multiple recipients of list ORACLE-L


smack your fellow DBA around for logging in as system and not his own
id, and I still stand by my statement change the system userid temporary
tablespace to temp.

joe
> lerobe - Lee Robertson wrote:
> 
> Sorry Guys,
> 
> Ignore this message. One of the other DBAs had logged in from home (he
> gets in later in the morning than me so I never got a chance to speak
> to him before sending this mail) and attempted to create an index on a
> table while logged in as system
> 
> create index user.tabind blah blah ..
> 
> and thought by using the fully qualified schema name it would appear
> in the TS he wanted it in.
> 
> Ho hum
> 
> 
> Lee Robertson
> Acxiom
> Tel:0191 525 7344
> Fax:0191 525 7007
> Email: [EMAIL PROTECTED]
> 
>  -Original Message-
>  From: lerobe - Lee Robertson [mailto:[EMAIL PROTECTED]]
>  Sent: 09 March 2001 08:25
>  To: Multiple recipients of list ORACLE-L
>  Subject: Weird - unable to extend error
> 
>  Oracle 8.0.5.0.0
>  Tru64 4.0f
> 
>  Got in this morning (duh duh duh duh)
>  and found a mail from my alerting script from the DB with
>  the following
> 
>  ORA-1652: unable to extend temp segment by 27309 in
>  tablespace
>SYSTEM
> 
>  As far as I am aware there was absolutely nothing going on
>  on this system and indeed was the first entry in the alert
>  log file for about 2 hours. (Normal operations on this DB
>  stop at about 18:00 - the message appeared at 20:20.).
> 
>  Should I be worried ?? There have been no entries in the
>  alert log since. (saying that though, people don't start
>  using it until about 9am).
> 
>  Lee Robertson
>  Acxiom
>  Tel:0191 525 7344
>  Fax:0191 525 7007
>  Email: [EMAIL PROTECTED]
> 
> 
> 
>  The information contained in this communication is
>  confidential, is intended only for the use of the recipient
>  named above, and may be legally privileged. If the reader
>  of this message is not the intended recipient, you are
>  hereby notified that any dissemination, distribution or
>  copying of this communication is strictly prohibited.
>  If you have received this communication in error, please
>  re-send this communication to the sender and delete the
>  original message or any copy of it from your computer
>  system.

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  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: Paul Baumgartel
  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
-- 
Autho

RE: ScanMail Message: To Sender, sensitive content found and

2001-03-09 Thread Kimberly Smith


Why, pray tell, do you want them removed from the list.  It's
not like they are doing anything wrong.  

-Original Message-
Sent: Thursday, March 08, 2001 2:16 PM
To: Multiple recipients of list ORACLE-L


I don't know but i vote for them to be removed from the list, when i
work for a compnay that starts screening my email for me, i'll quit
thats for sure.

the place i work for, i know the admins and they dont do that kind of
garbage.

joe
[EMAIL PROTECTED] wrote:
> 
> OK, who have we got who works at Ge Capital?
> 
> Dick Goulet
> 
> Reply Separator
> Author: System Attendant <[EMAIL PROTECTED]>
> Date:   3/8/2001 2:22 PM
> 
> Trend SMEX Content Filter has detected sensitive content.
> 
> Place = Multiple recipients of list ORACLE-L; ; ; [EMAIL PROTECTED]
> Sender = [EMAIL PROTECTED]
> Subject = Re:RE: Life in New England
> Delivery Time = March 08, 2001 (Thursday) 12:22:24
> Policy = Sexual Discrimination
> Action on this mail = Quarantine message
> 
> Warning message from administrator:
> Notice: A message you sent appears to have violated GE Financial Assurance
email
> policies for inappropriate language or content and may not have been
received by
> the recipient.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   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).

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  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: Kimberly Smith
  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-claiming the space from Table after deleteion

2001-03-09 Thread Alex Hillman


First of all, as Joe Testa said - if you partitioned this table by date -
let say one partition per month - you can truncate partitions that you don't
need anymore. Second - if this option is not available - let say that you
need delete most but not all records from specific partition - you can
create temporary table, select into this table all records that should not
be deleted, truncate partition and then select into partition all records
from temporary table. And last case - if you need to delete let say 30-50%
of the recors and this table does not have a lot of deletes in everyday
activity and most deletes are batch in the end of month or some other
period - you can increase value of PCTUSED to 100-PCTFREE-5.

Alex Hillman

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
> [EMAIL PROTECTED]
> Sent: Friday, March 09, 2001 4:56 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re-claiming the space from Table after deleteion
>
>
> Dear All,
>
>   Platform: Solaris 2.6, Oracle: 7.3.4.0
>
> We have a few tables which are growing very fast due to large no of
> insertions. But the data gets obselete after a month and we use a
> procedure to delete the obselete data from the tables.
>
>   The problem is that the table does not free the space even
> after the deletion of 40% of the data.
>
> How can we re-claim the unused space which got created due to deletion?
>
> How do we ensure that future inserts are done in this unused space?
>
>
>   [We can not try exp/imp or truncate option
>   due to the huge size  & high activity and
>   online use of the tables].
>
> Kind Regards and thanks to all there,
>
>
> Rafi Ahmad
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   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: Alex Hillman
  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).

NT install problem ???

2001-03-09 Thread Leslie Lu


Hi all,

When I installed Oracle Enterprise Editon 8.1.5 to NT
4.0, I got this:  12570, 0, "TNS:packet reader
failure"

12570, 0, "TNS:packet reader failure"
// *Cause: An error occurred during a data receive.
// *Action: Not normally visible to the user. For
further details, turn
// on tracing and reexecute the operation. If error
persists, contact
// Oracle Customer Support.

I clicked ignore, Oracle run for a minute and show
that Create db assistant not installed successfully.

Anyone knows why did this happen and how to solve the
problem?  Much appreciated.

Leslie


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  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: Standby db license for 8.1.6

2001-03-09 Thread Diana Duncan


Yup, they want you to pay for it, because it is an additional x number of
processors.  They don't care that it's not really "on" or being accessed.
At filefrenzy, this policy actually led us to turn off a few of our
processors.  ;-)

Diana

-Original Message-
Sent: Friday, March 09, 2001 9:55 AM
To: Multiple recipients of list ORACLE-L


If we put together a standby db (SUN 4500) is Oracle going to want more
license money?

Our thinking is, the license(s) we already own on the production server
(also a 4500) cover us to keep the standby db going.  We will not use the
stand-by server for anything else.  There will be no user access at all.
Our (hungry?) Oracle rep is telling us that this is a clear case of
"multiply by existing license(s) by 2", doubling our license costs.  (Let's
ignore all of the issues of power unit, named users, etc. for this
conversation.)

What has your experience been on this license issue for a standby db?


Thx

  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don Dealy, II
  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: Diana Duncan
  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: Standby db license for 8.1.6

2001-03-09 Thread Rachel Carmichael



I had a similar conversation with my Oracle rep.

The conclusions were:

if you have a database running on a machine, even if it is a standby 
database that no one logs into, you need a license for that machine.

You can, however, install the Oracle binaries on a backup server, and not 
have to pay an additional license fee, if you do not have any databases open 
in any form on that machine

Rachel

>From: "Don Dealy, II" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Standby db license for 8.1.6
>Date: Fri, 09 Mar 2001 06:55:25 -0800
>
>If we put together a standby db (SUN 4500) is Oracle going to want more 
>license money?
>
>Our thinking is, the license(s) we already own on the production server 
>(also a 4500) cover us to keep the standby db going.  We will not use the 
>stand-by server for anything else.  There will be no user access at all.  
>Our (hungry?) Oracle rep is telling us that this is a clear case of 
>"multiply by existing license(s) by 2", doubling our license costs.  (Let's 
>ignore all of the issues of power unit, named users, etc. for this 
>conversation.)
>
>What has your experience been on this license issue for a standby db?
>
>
>Thx
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Don Dealy, II
>   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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Netbackup and RMAN

2001-03-09 Thread Steve Orr


Since you're on OPS I assume this is a larger database. If so then you
probably want RMAN and NetBackup. RMAN requires a "Media Management Layer,"
or 3rd party package to handle the interface to your robotic tape subsystem.
Without media management you could stage the RMAN backups to disk then use
O/S or other backup programs to backup the disk backup to tape... but then
you'd still have to manage your tapes. If you've paid big bucks for OPS then
don't scrimp on the backup solution. Veritas also has NetBackup for Oracle
BLI (Block Level Incremental) Backup Edition so you could backup raw devices
without RMAN, (I think? ...never used the BLI stuff). Did you check out the
Veritas web site? Lot's of "full color glossies" there. Also, check out the
NetBackup pages at Backup Central...
http://www.backupcentral.com/netbackup-faq.html.

HTH,
Steve Orr



-Original Message-
Basavaraja
Sent: Thursday, March 08, 2001 6:50 PM
To: Multiple recipients of list ORACLE-L


We are planning to use Veritas Netbackup to backup our Oracle Database(OPS).
I am not sure whether we need to use the combination of Netbackup and RMAN
to take the backup/recovery or just Netbackup is sufficient to take the
backup.

Can anyone tell how this combination works.

Should I have Both or just Netbackup is sufficient for the Oracle backup and
receovery.

thanks

Ravindra

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ravindra Basavaraja
  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: Steve Orr
  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).

imp (import) problem

2001-03-09 Thread Leyden, Joseph


While importing a huge table (AIX) I get this problem:
and the progam seems to hang up. Help! I'm still new
to ORACLE databases.

IMP-3: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace
DAILYCYCLE01A

TIA
Joe
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leyden, Joseph
  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-claiming the space from T

2001-03-09 Thread GANTI . SIVA



You can try

alter tablespace (where the table is lying) coalesce;

Cheers
Ganti



---

The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this e-mail in error
please notify us by telephone or e-mail the sender by replying to
this message, and then delete this e-mail and other copies of it
from your computer system. Thank you.

We reserve the right to monitor all e-mail communications through
our network.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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: Weird - unable to extend error

2001-03-09 Thread Kimberly Smith


Not only that, you should change the default tablespace of system
to something other then system.  I actually sign in as system here
all the time as I am basically to lazy to create myself my own
account.  Then again, I am the only one who touches the database
in a DBA role so you know who caused the problem if I do something
wrong.  No need to track that.  Oh wait, I got even lazier and created
an externally identified account and use that one now.  But system's
default tablespace still is not system.

-Original Message-
Sent: Friday, March 09, 2001 4:17 AM
To: Multiple recipients of list ORACLE-L


smack your fellow DBA around for logging in as system and not his own
id, and I still stand by my statement change the system userid temporary
tablespace to temp.

joe
> lerobe - Lee Robertson wrote:
> 
> Sorry Guys,
> 
> Ignore this message. One of the other DBAs had logged in from home (he
> gets in later in the morning than me so I never got a chance to speak
> to him before sending this mail) and attempted to create an index on a
> table while logged in as system
> 
> create index user.tabind blah blah ..
> 
> and thought by using the fully qualified schema name it would appear
> in the TS he wanted it in.
> 
> Ho hum
> 
> 
> Lee Robertson
> Acxiom
> Tel:0191 525 7344
> Fax:0191 525 7007
> Email: [EMAIL PROTECTED]
> 
>  -Original Message-
>  From: lerobe - Lee Robertson [mailto:[EMAIL PROTECTED]]
>  Sent: 09 March 2001 08:25
>  To: Multiple recipients of list ORACLE-L
>  Subject: Weird - unable to extend error
> 
>  Oracle 8.0.5.0.0
>  Tru64 4.0f
> 
>  Got in this morning (duh duh duh duh)
>  and found a mail from my alerting script from the DB with
>  the following
> 
>  ORA-1652: unable to extend temp segment by 27309 in
>  tablespace
>SYSTEM
> 
>  As far as I am aware there was absolutely nothing going on
>  on this system and indeed was the first entry in the alert
>  log file for about 2 hours. (Normal operations on this DB
>  stop at about 18:00 - the message appeared at 20:20.).
> 
>  Should I be worried ?? There have been no entries in the
>  alert log since. (saying that though, people don't start
>  using it until about 9am).
> 
>  Lee Robertson
>  Acxiom
>  Tel:0191 525 7344
>  Fax:0191 525 7007
>  Email: [EMAIL PROTECTED]
> 
> 
> 
>  The information contained in this communication is
>  confidential, is intended only for the use of the recipient
>  named above, and may be legally privileged. If the reader
>  of this message is not the intended recipient, you are
>  hereby notified that any dissemination, distribution or
>  copying of this communication is strictly prohibited.
>  If you have received this communication in error, please
>  re-send this communication to the sender and delete the
>  original message or any copy of it from your computer
>  system.

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  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: Kimberly Smith
  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).

blob space problem

2001-03-09 Thread Joan Hsieh


Hi Dear List,

Does anyone can tell me how oracle manage the blob space?

I have a table with a blob column in it. The contents of the blob columns
are stored in a different tablespace. my question is what happens to the
"space occupied" by blob in the tablespace when it is deleted. Looks like we
are very fragment on this tablespace. Right now the tablespace has 75
datafiles (4g each) and filled up very quickly. The problem is we can't
continue to buy the disk. How we can reused the space?

OWNER
--
SEGMENT_NAME


PARTITION_NAME SEGMENT_TYPE   TABLESPACE_NAME
-- -- --

HEADER_FILE HEADER_BLOCK  BYTES BLOCKSEXTENTS INITIAL_EXTENT
---  -- -- -- --
NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE  FREELISTS FREELIST_GROUPS
--- --- ---  -- ---
RELATIVE_FNO BUFFER_
 ---
XPC
SYS_IL002887C3$$
   LOBINDEX   XPC_OBJ_LOB
  931877 4699987968 573729 18  261095424
  261095424   1  21474836450 99   2
   9 DEFAULT

XPC
OBJECTS_BLOB
   LOBSEGMENT XPC_OBJ_LOB
  92 2.9350E+11   35827300   1124  261095424
  261095424   1  21474836450 99   2
   9 DEFAULT

SQL:(mii1)>desc objects
 Name  Null?Type
 -  

 OBJ_HASH  NOT NULL CHAR(16)
 OBJ_ENT_COUNT  NUMBER
 OBJ_BLOB   BLOB

SQL:(mii1)>select count(*) from dba_data_files where
tablespace_name='XPC_OBJ_LOB';

  COUNT(*)
--
74


Thanks,

Joan

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joan Hsieh
  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-claiming the space from Table after deleteion

2001-03-09 Thread cameron_michelis



Rafi,

You could be deleting data, but not adjusting disk space due to your block
level storage parameters.  Have you considered increasing your pctused
parameters?  This could help place blocks back on the freelist after you
run your purge routines.

Cameron Michelis
OCP/OCM DBA


   

"Raghu Kota"   

   <[EMAIL PROTECTED]>

Sent by: cc:   

root@fatcity.Subject: Re: Re-claiming the space from 
Table 
com  after deleteion   

   

   

03/09/2001 

10:15 AM   

Please 

respond to 

ORACLE-L   

   

   





Hi Rafi

This is the problem many big databases facing!!If you clean up the database

every year and reorganizing the database You would't have see this
scenario.
For the matter fact iam also facing same problem, My one table grown like
22G, I simply can't do any thing?? Iam doing just for Indexes Rebuild for
getting what ever space I can avail. As you said you deleted 40% of data!!
You can reorganize your Indexes to avail some space.

Other wise Export to Tape and reimport it, But here again problem when you
say compress=y, due to heavy data Its another big headche??

May be our friends give some ideas???

Thanks
Raghu.


>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re-claiming the space from Table after deleteion
>Date: Fri, 09 Mar 2001 01:56:07 -0800
>
>Dear All,
>
>  Platform: Solaris 2.6, Oracle: 7.3.4.0
>
>We have a few tables which are growing very fast due to large no of
>insertions. But the data gets obselete after a month and we use a
>procedure to delete the obselete data from the tables.
>
>  The problem is that the table does not free the space even after
the
>deletion of 40% of the data.
>
>How can we re-claim the unused space which got created due to deletion?
>
>How do we ensure that future inserts are done in this unused space?
>
>
>[We can not try exp/imp or truncate option
>due to the huge size  & high activity and
>online use of the tables].
>
>Kind Regards and thanks to all there,
>
>
>Rafi Ahmad
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>   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).

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Raghu Kota
  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: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
---

HELP on how WebLogic works with ASD

2001-03-09 Thread Long Tang


Hi there,

I am investigating the different database backup strategies. It seems
that Automated Standby Database is a simple and effective way which may
fits into our needs. 

We are using EJB (WebLogic 5.1) at the server side and the bankend is
Oracle. My questions are:

The database information(login, password, sid) is configured in the
weblogic.properties and the deployment descriptor file, and it's looked
up through JDNI ( in the entity bean case, it's all handled
automatically by WebLogic ). So how would the Weblogic works with ASD if
the primary database fails? 

Is it congigurable in the property and descriptor file that using the
standby database if the primary database fails? How does the WebLogic
server in a clustering environment know the switching happens? 

If the SD can be used for read-only operations, how can we achieve that
by using WebLogic?

It seems to me that the activation of ASD to serve as the primary
database involves manul human operation. Is this true? Can this be done
automatically?

Your reply will be appreciated.

Long Tang
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Long Tang
  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: Standby db license for 8.1.6

2001-03-09 Thread Gene Sais


I've been told the same, but I believe the rep is just trying to increase sales.  If 
you think about it, you only have 1 license running at 1 time, installed at 1 time, 
therefore pay for 1 license.  Usually, when you switch to the fail-over, the 
filesystems are umounted from production and then mounted on the fail-over machine.  I 
don't see how this is 2 licenses, but if you were using the fail-over for a read-only 
db or test db, then they got you.

>>> [EMAIL PROTECTED] 03/09 9:55 AM >>>
If we put together a standby db (SUN 4500) is Oracle going to want more license money?

Our thinking is, the license(s) we already own on the production server (also a 4500) 
cover us to keep the standby db going.  We will not use the stand-by server for 
anything else.  There will be no user access at all.  Our (hungry?) Oracle rep is 
telling us that this is a clear case of "multiply by existing license(s) by 2", 
doubling our license costs.  (Let's ignore all of the issues of power unit, named 
users, etc. for this conversation.)

What has your experience been on this license issue for a standby db?


Thx



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Don Dealy, II
  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: Gene Sais
  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: Weird - unable to extend error

2001-03-09 Thread Raghu Kota


Oh man, You did't change using SYSTEM temp to TEMP tablespace, You to assing 
what ever users from system to temp as default temporary tablespace, Other 
wise you have big problem. Only sys and system can use SYSTEM temp segments.

Raghu.


>From: lerobe - Lee Robertson <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Weird - unable to extend error
>Date: Fri, 09 Mar 2001 00:25:27 -0800
>
>Oracle 8.0.5.0.0
>Tru64 4.0f
>
>Got in this morning (duh duh duh duh)
>and found a mail from my alerting script from the DB with the following
>
>ORA-1652: unable to extend temp segment by 27309 in tablespace
>   SYSTEM
>
>As far as I am aware there was absolutely nothing going on on this system
>and indeed was the first entry in the alert log file for about 2 hours.
>(Normal operations on this DB stop at about 18:00 - the message appeared at
>20:20.).
>
>Should I be worried ?? There have been no entries in the alert log since.
>(saying that though, people don't start using it until about 9am).
>
>Lee Robertson
>Acxiom
>Tel:0191 525 7344
>Fax:0191 525 7007
>Email: [EMAIL PROTECTED]
>
>
>
>
>The information contained in this communication is
>confidential, is intended only for the use of the recipient
>named above, and may be legally privileged. If the reader
>of this message is not the intended recipient, you are
>hereby notified that any dissemination, distribution or
>copying of this communication is strictly prohibited.
>If you have received this communication in error, please
>re-send this communication to the sender and delete the
>original message or any copy of it from your computer
>system.

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raghu Kota
  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-claiming the space from Table after deleteion

2001-03-09 Thread Raghu Kota


Hi Rafi

This is the problem many big databases facing!!If you clean up the database 
every year and reorganizing the database You would't have see this scenario. 
For the matter fact iam also facing same problem, My one table grown like 
22G, I simply can't do any thing?? Iam doing just for Indexes Rebuild for 
getting what ever space I can avail. As you said you deleted 40% of data!! 
You can reorganize your Indexes to avail some space.

Other wise Export to Tape and reimport it, But here again problem when you 
say compress=y, due to heavy data Its another big headche??

May be our friends give some ideas???

Thanks
Raghu.


>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re-claiming the space from Table after deleteion
>Date: Fri, 09 Mar 2001 01:56:07 -0800
>
>Dear All,
>
>   Platform: Solaris 2.6, Oracle: 7.3.4.0
>
>We have a few tables which are growing very fast due to large no of
>insertions. But the data gets obselete after a month and we use a
>procedure to delete the obselete data from the tables.
>
>   The problem is that the table does not free the space even after the 
>deletion of 40% of the data.
>
>How can we re-claim the unused space which got created due to deletion?
>
>How do we ensure that future inserts are done in this unused space?
>
>
>   [We can not try exp/imp or truncate option
>   due to the huge size  & high activity and
>   online use of the tables].
>
>Kind Regards and thanks to all there,
>
>
>Rafi Ahmad
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>   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).

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raghu Kota
  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).

FWD:Scam ALert

2001-03-09 Thread dgoulet


To all,

The attached was received from our HelpDesk this morning.  Looks like a
bunch of crooks trying to make a buck off of the unwary.  Oh well, Happy
Weekend, I've got to go warm up the snow blower again!!

Dick Goulet


Forward Header_
Author: HelpDesk
Date:   3/8/2001 5:26 PM




Do you have a pager or an E-Mail address?BEWARE!
One of the newer scams involves pagers and E-Mail.

Pager Scam

You get a page and you notice a number with an area code different from your
own.must be important. So you return the call only to find it's a recording.
In reality, you've just been SCAMMED! The call probably went to one of several
new area codes in the Caribbean, is billed at an international rate, and the
longer you stay on the line, the more it costs. What you'll hear is a lengthy
recording, and the meter starts running as soon as you make the connection. The
page is generated by a computer dialer, and the cost goes to the return caller,
you! 

E-Mail Scam

A company has been sending unsolicited and elegantly worded e-mail messages
threatening legal action unless the recipient pays an unspecified overdue
account. The message then gives a name and number in the 809 area code to call
for further information. Callers are then led to believe they are talking to a
live person, but in fact it is a clever recording that responds to the caller's
voice. The call is designed to keep the caller on the line for as long as
possible. The call can accumulate a high bill. (Source: CFCA 10-25-96) 

Listed below are some other area codes mentioned. One good rule of protection
is: If you don't recognize a number do not respond, be wary. 

Also, check the front of your local telephone book for area code verification.
The new area codes in the Caribbean: 
Anguilla264 Grenada 473 
Antigua 268 Jamaica 664 
Barbuda 268 Monserrat   473 
Bahamas 242 Nevis   869 
Barbados246 Puerto Rico 787 
Bermuda 441 St. Kitts   869 
Brit. Virgin Islands284 St. Lucia   758 
Caicos Islands  649 St. Vincent 784 
Cayman Islands  345 Trinidad & Tobago   868 
Dominica767 Turks Island649 
You can read more about this scam at the web sites listed below.

http://www.scambusters.org/809Scam.html

http://www.truthorfiction.com/rumors/area809.htm  
 Untitled

RE: Weird - unable to extend error

2001-03-09 Thread lerobe - Lee Robertson


Sorry Paul,

Do not pass Go and do not collect 200 quid. One of the other guys in here
had logged in as system and was creating an index, his temporary tablespace
was set to SYSTEM and therefore Joe's diagnosis below was correct.

> Lee Robertson
> Acxiom
> Tel:  0191 525 7344
> Fax:  0191 525 7007
> Email: [EMAIL PROTECTED]
> 


-Original Message-
Sent: 09 March 2001 14:26
To: Multiple recipients of list ORACLE-L


In this case the "temporary segment" was not a sort segment, but the space
allocated for an index while under construction.  I'm surprised that no one
here caught that!


Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)


-Original Message-
Sent: Friday, March 09, 2001 7:17 AM
To: Multiple recipients of list ORACLE-L


smack your fellow DBA around for logging in as system and not his own
id, and I still stand by my statement change the system userid temporary
tablespace to temp.

joe
> lerobe - Lee Robertson wrote:
> 
> Sorry Guys,
> 
> Ignore this message. One of the other DBAs had logged in from home (he
> gets in later in the morning than me so I never got a chance to speak
> to him before sending this mail) and attempted to create an index on a
> table while logged in as system
> 
> create index user.tabind blah blah ..
> 
> and thought by using the fully qualified schema name it would appear
> in the TS he wanted it in.
> 
> Ho hum
> 
> 
> Lee Robertson
> Acxiom
> Tel:0191 525 7344
> Fax:0191 525 7007
> Email: [EMAIL PROTECTED]
> 
>  -Original Message-
>  From: lerobe - Lee Robertson [mailto:[EMAIL PROTECTED]]
>  Sent: 09 March 2001 08:25
>  To: Multiple recipients of list ORACLE-L
>  Subject: Weird - unable to extend error
> 
>  Oracle 8.0.5.0.0
>  Tru64 4.0f
> 
>  Got in this morning (duh duh duh duh)
>  and found a mail from my alerting script from the DB with
>  the following
> 
>  ORA-1652: unable to extend temp segment by 27309 in
>  tablespace
>SYSTEM
> 
>  As far as I am aware there was absolutely nothing going on
>  on this system and indeed was the first entry in the alert
>  log file for about 2 hours. (Normal operations on this DB
>  stop at about 18:00 - the message appeared at 20:20.).
> 
>  Should I be worried ?? There have been no entries in the
>  alert log since. (saying that though, people don't start
>  using it until about 9am).
> 
>  Lee Robertson
>  Acxiom
>  Tel:0191 525 7344
>  Fax:0191 525 7007
>  Email: [EMAIL PROTECTED]
> 
> 
> 
>  The information contained in this communication is
>  confidential, is intended only for the use of the recipient
>  named above, and may be legally privileged. If the reader
>  of this message is not the intended recipient, you are
>  hereby notified that any dissemination, distribution or
>  copying of this communication is strictly prohibited.
>  If you have received this communication in error, please
>  re-send this communication to the sender and delete the
>  original message or any copy of it from your computer
>  system.

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  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: Paul Baumgartel
  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: lerobe - Lee Robertson
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--

RE: Can't copy DB-create controlfile fails

2001-03-09 Thread Ruiz, Mary A (CAP, CDI)


Connie:
  I perform this same activity once a month.  
I use CREATE CONTROLFILE REUSE SET DATABASE "DEV" RESETLOGS NOARCHIVELOG
etc

hth
Mary Ruiz / Atlanta GA

-Original Message-
Sent: Friday, March 09, 2001 9:45 AM
To: Multiple recipients of list ORACLE-L


I keep getting this error while trying to make a copy of a prod db to a
dev environment (which are on two separate boxes):  ORA-01697 invalid
option for create controlfile.  Controlfile is for a clone database.
Oracle 8.0.6 on NT.  Any ideas on why this is happening?  These are the
procedures I am following:


>From Dev env.
1. Shutdown current dev and remove all datafiles and controlfiles (but
leave initDEV).

>From Prod:

1. Shutdown and do cold backup
2. Move datafiles from prod to dev environment
3. Do 'Alter database backup controlfile to trace'.  Take the trace file
and make a sql script changing SID name from PROD to DEV, etc. as
follows:
STARTUP NOMOUNT;
CREATE CONTROLFILE SET DATABASE "DEV" RESETLOGS NOARCHIVELOG
 MAXLOGFILES 32
 MAXLOGMEMBERS 5
 MAXDATAFILES 1022
 MAXINSTANCES 1
 MAXLOGHISTORY 1815
LOGFILE
 GROUP 1 (
   '/prod01/oradata/redo_01a.rdo',
   '/prod01/oradata/redo_01b.rdo'
 ) SIZE 20M,
 GROUP 2 (
   '/prod02/oradata/redo_02a.rdo',
   '/prod02/oradata/redo_02b.rdo'
 ) SIZE 20M,
 GROUP 3 (
   '/prod03/oradata/redo_03a.rdo',
   '/prod03/oradata/redo_03b.rdo'
 ) SIZE 20M
DATAFILE
 '/prod01/oradata/system_01.dbf',
 '/prod01/oradata/rbs_01.dbf',
 '/prod01/oradata/temp_01.dbf',
 '/prod01/oradata/tools_01.dbf',
 '/prod01/oradata/users_01.dbf',
 '/prod02/oradata/DEV_01.dbf',






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Connie Milliken
  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: Ruiz, Mary A (CAP, CDI)
  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: Weird - unable to extend error

2001-03-09 Thread SHAIBAL TALUKDER

Right Joe, you surely can raise your eyebrows when someone suggest to make system tablespace use max extents unlimited instead of suggesting not to use the sytem tablespace as temp for any user.
Shaibal
 
  "Joseph S. Testa" <[EMAIL PROTECTED]> wrote: 
this is a bad move, NO ONE should be using system as their temptablespace, INCLUDING SYS, make everyone use temp.why would you tell someone to go and change system to use max extentsunlimited, this just complicates the problem.Out of curiosity, Ganit how long have you been a DBA?Joe[EMAIL PROTECTED] wrote:> > Hi lee,> > Some temporary sorting kind of thing takes place in SYSTEM tablespace while> you create ome indexes or rebuild indexes.> So> > alter tablespace system default storage(maxextents unlimited)> > you revert back after work is finished.> > Cheers> Ganti> > ---> > The contents of this e-mail are confidential to the ordinary user> of the e-mail a!
!
ddress to which it was addressed and may also be> privileged. If you are not the addressee of this e-mail you should> not copy, forward, disclose or otherwise use it or any part of it> in any form whatsoever. If you have received this e-mail in error> please notify us by telephone or e-mail the sender by replying to-- Joe Testa http://www.oracle-dba.comPerforming Remote DBA Services, need some backup DBA support?For Sale: Oracle-dba.com domain, its not going cheap but feel free toask :)-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Joseph S. TestaINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (no!
!
te EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!?
Yahoo! Mail Personal Address - 
Get email at your own domain with Yahoo! Mail.

RE: Re-claiming the space from Table after deleteion

Only some of the space will be available, remember some of the blocks may
not have made it back onto the free list.

It could be minor, I don't really know, but don't expect to get back all the
space you want to see.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

-Original Message-
From:   William Beilstein [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, March 09, 2001 9:45 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Re-claiming the space from Table after deleteion

Also is this really a problem. In the next month you are going to
import  more rows which will use the deleted space anyway.

>>> "Joseph S. Testa" <[EMAIL PROTECTED]> 03/09/01 07:17AM >>>
sounds like a candidate for partitioning.

joe
[EMAIL PROTECTED] wrote:
> 
> Dear All,
> 
> Platform: Solaris 2.6, Oracle: 7.3.4.0
> 
> We have a few tables which are growing very fast due to large no
of
> insertions. But the data gets obselete after a month and we use a
> procedure to delete the obselete data from the tables.
> 
> The problem is that the table does not free the space even
after the deletion of 40% of the data.
> 
> How can we re-claim the unused space which got created due to
deletion?
> 
> How do we ensure that future inserts are done in this unused
space?
> 
> [We can not try exp/imp or truncate option
> due to the huge size  & high activity and
> online use of the tables].
> 
> Kind Regards and thanks to all there,
> 
> Rafi Ahmad
>

-- 
Joe Testa  http://www.oracle-dba.com 
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free
to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Joseph S. Testa
  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: William Beilstein
  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: Boivin, Patrice J
  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:Standby db license for 8.1.6

2001-03-09 Thread dgoulet



Don,

Given Oracle's revenue projections, I'd say "Absolutely".

Dick Goulet

Reply Separator
Author: "Don Dealy; II" <[EMAIL PROTECTED]>
Date:   3/9/2001 6:55 AM

If we put together a standby db (SUN 4500) is Oracle going to want more license
money?

Our thinking is, the license(s) we already own on the production server (also a
4500) cover us to keep the standby db going.  We will not use the stand-by
server for anything else.  There will be no user access at all.  Our (hungry?)
Oracle rep is telling us that this is a clear case of "multiply by existing
license(s) by 2", doubling our license costs.  (Let's ignore all of the issues
of power unit, named users, etc. for this conversation.)

What has your experience been on this license issue for a standby db?


Thx

  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don Dealy, II
  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: 
  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: Weird - unable to extend error

2001-03-09 Thread Rachel Carmichael


actually, the problem is that the SYSTEM account still has the system 
tablespace as the default tablespace.

Should be changed asap.


>From: Paul Baumgartel <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Weird - unable to extend error
>Date: Fri, 09 Mar 2001 06:25:43 -0800
>
>In this case the "temporary segment" was not a sort segment, but the space
>allocated for an index while under construction.  I'm surprised that no one
>here caught that!
>
>
>Paul Baumgartel
>InstiPro, Inc.
>[EMAIL PROTECTED]
>212 813-0829 x103 (office)
>917 549-4717 (mobile)
>
>
>-Original Message-
>Sent: Friday, March 09, 2001 7:17 AM
>To: Multiple recipients of list ORACLE-L
>
>
>smack your fellow DBA around for logging in as system and not his own
>id, and I still stand by my statement change the system userid temporary
>tablespace to temp.
>
>joe
> > lerobe - Lee Robertson wrote:
> >
> > Sorry Guys,
> >
> > Ignore this message. One of the other DBAs had logged in from home (he
> > gets in later in the morning than me so I never got a chance to speak
> > to him before sending this mail) and attempted to create an index on a
> > table while logged in as system
> >
> > create index user.tabind blah blah ..
> >
> > and thought by using the fully qualified schema name it would appear
> > in the TS he wanted it in.
> >
> > Ho hum
> >
> >
> > Lee Robertson
> > Acxiom
> > Tel:0191 525 7344
> > Fax:0191 525 7007
> > Email: [EMAIL PROTECTED]
> >
> >  -Original Message-
> >  From: lerobe - Lee Robertson [mailto:[EMAIL PROTECTED]]
> >  Sent: 09 March 2001 08:25
> >  To: Multiple recipients of list ORACLE-L
> >  Subject: Weird - unable to extend error
> >
> >  Oracle 8.0.5.0.0
> >  Tru64 4.0f
> >
> >  Got in this morning (duh duh duh duh)
> >  and found a mail from my alerting script from the DB with
> >  the following
> >
> >  ORA-1652: unable to extend temp segment by 27309 in
> >  tablespace
> >SYSTEM
> >
> >  As far as I am aware there was absolutely nothing going on
> >  on this system and indeed was the first entry in the alert
> >  log file for about 2 hours. (Normal operations on this DB
> >  stop at about 18:00 - the message appeared at 20:20.).
> >
> >  Should I be worried ?? There have been no entries in the
> >  alert log since. (saying that though, people don't start
> >  using it until about 9am).
> >
> >  Lee Robertson
> >  Acxiom
> >  Tel:0191 525 7344
> >  Fax:0191 525 7007
> >  Email: [EMAIL PROTECTED]
> >
> >
> >
> >  The information contained in this communication is
> >  confidential, is intended only for the use of the recipient
> >  named above, and may be legally privileged. If the reader
> >  of this message is not the intended recipient, you are
> >  hereby notified that any dissemination, distribution or
> >  copying of this communication is strictly prohibited.
> >  If you have received this communication in error, please
> >  re-send this communication to the sender and delete the
> >  original message or any copy of it from your computer
> >  system.
>
>--
>Joe Testa  http://www.oracle-dba.com
>Performing Remote DBA Services, need some backup DBA support?
>For Sale: Oracle-dba.com domain, its not going cheap but feel free to
>ask :)
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Joseph S. Testa
>   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: Paul Baumgartel
>   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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author:

RE: Re-claiming the space from Table after deleteion

2001-03-09 Thread Johan [EMAIL PROTECTED] Services

TRUNCATE the table by using:

TRUNCATE TABLE ;

Just remember that this command falls under ddl, ie.
- An implicit commit is fired (no rolling back)

Everything is deleted, and the high water mark reset

Cheers
JL

-Original Message-
Sent: Friday, March 09, 2001 2:17 PM
To: Multiple recipients of list ORACLE-L

 If we delete data from a table, tables highwater mark doesnot come down.
That's why u cannot reclaim the freespace after deletion from a table.

This FYI&A
--

On Fri, 09 Mar 2001 01:56:07  
 rafi wrote:
>Dear All,
>
>   Platform: Solaris 2.6, Oracle: 7.3.4.0
>
>We have a few tables which are growing very fast due to large no of
>insertions. But the data gets obselete after a month and we use a
>procedure to delete the obselete data from the tables. 
>
>   The problem is that the table does not free the space even after the
deletion of 40% of the data. 
>
>How can we re-claim the unused space which got created due to deletion?
>
>How do we ensure that future inserts are done in this unused space?
>
>
>   [We can not try exp/imp or truncate option 
>   due to the huge size  & high activity and 
>   online use of the tables].
>
>Kind Regards and thanks to all there,
>
>
>Rafi Ahmad
>
>
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: 
>  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).
>

Get 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  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).

**

The information in this e-mail is confidential and is legally privileged.
It is intended solely for the addressee.  If this email is not intended for
you, you cannot copy, distribute, or disclose the included information
to any-one

If you are not the intended recipient please delete the mail. Whilst
all reasonable steps have been taken to ensure the accuracy and
integrity of all data transmitted electronically, no liability is accepted
if the data, for whatever reason, is corrupt or does not reach it's
intended destination.
All business is undertaken, subject to our standard trading conditions
which are available on request.

***
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johan Locke@i-Commerce Services
  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: Weird - unable to extend error

2001-03-09 Thread Paul Baumgartel


In this case the "temporary segment" was not a sort segment, but the space
allocated for an index while under construction.  I'm surprised that no one
here caught that!


Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)


-Original Message-
Sent: Friday, March 09, 2001 7:17 AM
To: Multiple recipients of list ORACLE-L


smack your fellow DBA around for logging in as system and not his own
id, and I still stand by my statement change the system userid temporary
tablespace to temp.

joe
> lerobe - Lee Robertson wrote:
> 
> Sorry Guys,
> 
> Ignore this message. One of the other DBAs had logged in from home (he
> gets in later in the morning than me so I never got a chance to speak
> to him before sending this mail) and attempted to create an index on a
> table while logged in as system
> 
> create index user.tabind blah blah ..
> 
> and thought by using the fully qualified schema name it would appear
> in the TS he wanted it in.
> 
> Ho hum
> 
> 
> Lee Robertson
> Acxiom
> Tel:0191 525 7344
> Fax:0191 525 7007
> Email: [EMAIL PROTECTED]
> 
>  -Original Message-
>  From: lerobe - Lee Robertson [mailto:[EMAIL PROTECTED]]
>  Sent: 09 March 2001 08:25
>  To: Multiple recipients of list ORACLE-L
>  Subject: Weird - unable to extend error
> 
>  Oracle 8.0.5.0.0
>  Tru64 4.0f
> 
>  Got in this morning (duh duh duh duh)
>  and found a mail from my alerting script from the DB with
>  the following
> 
>  ORA-1652: unable to extend temp segment by 27309 in
>  tablespace
>SYSTEM
> 
>  As far as I am aware there was absolutely nothing going on
>  on this system and indeed was the first entry in the alert
>  log file for about 2 hours. (Normal operations on this DB
>  stop at about 18:00 - the message appeared at 20:20.).
> 
>  Should I be worried ?? There have been no entries in the
>  alert log since. (saying that though, people don't start
>  using it until about 9am).
> 
>  Lee Robertson
>  Acxiom
>  Tel:0191 525 7344
>  Fax:0191 525 7007
>  Email: [EMAIL PROTECTED]
> 
> 
> 
>  The information contained in this communication is
>  confidential, is intended only for the use of the recipient
>  named above, and may be legally privileged. If the reader
>  of this message is not the intended recipient, you are
>  hereby notified that any dissemination, distribution or
>  copying of this communication is strictly prohibited.
>  If you have received this communication in error, please
>  re-send this communication to the sender and delete the
>  original message or any copy of it from your computer
>  system.

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  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: Paul Baumgartel
  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: ORA-12154

2001-03-09 Thread Kevin Kostyszyn


TIA,
What OS is this?  If it is NT, which db where you trying to log onto?  You
did create two oracle homes correct?  You also need to know which home is
your "default home".  As far as my experiences go, I would set the newer
Oracle version as the default home, then I make sure that both tnsnames
files have all db's in them, then it worked just fine.
Kev

-Original Message-
Sent: Friday, March 09, 2001 9:20 AM
To: Multiple recipients of list ORACLE-L




Hi, Guru,

I installed Orcle 8.0.5 EE and 8.1.7 EE on my laptop, now I received
ORA-12154:
TNS: counld not resolve service name.  I used Orcl817 as my orcle home for
8.1.7
DB.  I used two different names for two different databases.

What should I do to resolve this?

TIA!

Matt



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  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: Kevin Kostyszyn
  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: Netbackup and RMAN

2001-03-09 Thread Jack C. Applewhite


Ravindra,

Veritas distributes RMan scripts with NetBackup that work
nicely.  We've been using the combo for a while on Oracle
8.1.6 under Windows 2000.  IMHO RMan is wonderful in that it
does hot backups with minimal impact on database
performance - at least less redo impact than putting
tablespaces in hot backup mode, which must be done for
"traditional" scripted hot backups.

With Oracle Enterprise Edition RMan can also do incremental
backups, which is very nice.  A full Level 0 hot backup of
our production db takes almost 14 hours, while a Level 1
incremental backup takes only about 2 hours.

RMan also handles backing up, then deleting the archived
redo logs very nicely.

I'd recommend using RMan, with or without NetBackup.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]


-Original Message-
Ravindra
Basavaraja
Sent: Thursday, March 08, 2001 8:50 PM
To: Multiple recipients of list ORACLE-L


We are planning to use Veritas Netbackup to backup our
Oracle Database(OPS).
I am not sure whether we need to use the combination of
Netbackup and RMAN
to take the backup/recovery or just Netbackup is sufficient
to take the
backup.

Can anyone tell how this combination works.

Should I have Both or just Netbackup is sufficient for the
Oracle backup and
receovery.

thanks

Ravindra

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  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).

ORA-12154

2001-03-09 Thread mke




Hi, Guru,

I installed Orcle 8.0.5 EE and 8.1.7 EE on my laptop, now I received ORA-12154:
TNS: counld not resolve service name.  I used Orcl817 as my orcle home for 8.1.7
DB.  I used two different names for two different databases.

What should I do to resolve this?

TIA!

Matt



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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: Netbackup and RMAN

2001-03-09 Thread Vadim Gorbounov


Hi, Ravindra,
Positively, RMAN will be valuable improvement to your backup
strategy.
RMAN has many advantages over OS level backups, especially if you need
maximium system availability and want to minimize backup affect to system
performance. RMAN coming with 8.1.6 is stable and mature. Disadvantage - if
you're  loosing catalog - all backups are useless. You need to take double
care about catalog.
Vadim Gorbounov
Oracle DBA

-Original Message-
Sent: Thursday, March 08, 2001 9:50 PM
To: Multiple recipients of list ORACLE-L


We are planning to use Veritas Netbackup to backup our Oracle Database(OPS).
I am not sure whether we need to use the combination of Netbackup and RMAN
to take the backup/recovery or just Netbackup is sufficient to take the
backup.

Can anyone tell how this combination works.

Should I have Both or just Netbackup is sufficient for the Oracle backup and
receovery.

thanks

Ravindra

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ravindra Basavaraja
  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: Vadim Gorbounov
  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).

Standby db license for 8.1.6

2001-03-09 Thread Don Dealy, II


If we put together a standby db (SUN 4500) is Oracle going to want more license money?

Our thinking is, the license(s) we already own on the production server (also a 4500) 
cover us to keep the standby db going.  We will not use the stand-by server for 
anything else.  There will be no user access at all.  Our (hungry?) Oracle rep is 
telling us that this is a clear case of "multiply by existing license(s) by 2", 
doubling our license costs.  (Let's ignore all of the issues of power unit, named 
users, etc. for this conversation.)

What has your experience been on this license issue for a standby db?


Thx



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Don Dealy, II
  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-claiming the space from Table after deleteion


Also because your database blocks end up looking like Swiss cheese.  

Pctfree and pctused come to play, I know, but you still lose some space.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

-Original Message-
From:   C.S.Venkata Subramanian [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, March 09, 2001 8:17 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Re-claiming the space from Table after deleteion

 If we delete data from a table, tables highwater mark doesnot come
down. That's why u cannot reclaim the freespace after deletion from a table.

This FYI&A
--

On Fri, 09 Mar 2001 01:56:07  
 rafi wrote:
>Dear All,
>
>   Platform: Solaris 2.6, Oracle: 7.3.4.0
>
>We have a few tables which are growing very fast due to large no of
>insertions. But the data gets obselete after a month and we use a
>procedure to delete the obselete data from the tables. 
>
>   The problem is that the table does not free the space even
after the deletion of 40% of the data. 
>
>How can we re-claim the unused space which got created due to
deletion?
>
>How do we ensure that future inserts are done in this unused space?
>
>
>   [We can not try exp/imp or truncate option 
>   due to the huge size  & high activity and 
>   online use of the tables].
>
>Kind Regards and thanks to all there,
>
>
>Rafi Ahmad
>
>
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: 
>  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).
>


Get 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  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: Boivin, Patrice J
  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).

Can't copy DB-create controlfile fails

2001-03-09 Thread Connie Milliken


I keep getting this error while trying to make a copy of a prod db to a
dev environment (which are on two separate boxes):  ORA-01697 invalid
option for create controlfile.  Controlfile is for a clone database.
Oracle 8.0.6 on NT.  Any ideas on why this is happening?  These are the
procedures I am following:


>From Dev env.
1. Shutdown current dev and remove all datafiles and controlfiles (but
leave initDEV).

>From Prod:

1. Shutdown and do cold backup
2. Move datafiles from prod to dev environment
3. Do Alter database backup controlfile to trace.  Take the trace file
and make a sql script changing SID name from PROD to DEV, etc. as
follows:
STARTUP NOMOUNT;
CREATE CONTROLFILE SET DATABASE "DEV" RESETLOGS NOARCHIVELOG
 MAXLOGFILES 32
 MAXLOGMEMBERS 5
 MAXDATAFILES 1022
 MAXINSTANCES 1
 MAXLOGHISTORY 1815
LOGFILE
 GROUP 1 (
   '/prod01/oradata/redo_01a.rdo',
   '/prod01/oradata/redo_01b.rdo'
 ) SIZE 20M,
 GROUP 2 (
   '/prod02/oradata/redo_02a.rdo',
   '/prod02/oradata/redo_02b.rdo'
 ) SIZE 20M,
 GROUP 3 (
   '/prod03/oradata/redo_03a.rdo',
   '/prod03/oradata/redo_03b.rdo'
 ) SIZE 20M
DATAFILE
 '/prod01/oradata/system_01.dbf',
 '/prod01/oradata/rbs_01.dbf',
 '/prod01/oradata/temp_01.dbf',
 '/prod01/oradata/tools_01.dbf',
 '/prod01/oradata/users_01.dbf',
 '/prod02/oradata/DEV_01.dbf',






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Connie Milliken
  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-claiming the space from Table after deleteion

Also is this really a problem. In the next month you are going to import  more rows 
which will use the deleted space anyway.

>>> "Joseph S. Testa" <[EMAIL PROTECTED]> 03/09/01 07:17AM >>>
sounds like a candidate for partitioning.

joe
[EMAIL PROTECTED] wrote:
> 
> Dear All,
> 
> Platform: Solaris 2.6, Oracle: 7.3.4.0
> 
> We have a few tables which are growing very fast due to large no of
> insertions. But the data gets obselete after a month and we use a
> procedure to delete the obselete data from the tables.
> 
> The problem is that the table does not free the space even after the 
>deletion of 40% of the data.
> 
> How can we re-claim the unused space which got created due to deletion?
> 
> How do we ensure that future inserts are done in this unused space?
> 
> [We can not try exp/imp or truncate option
> due to the huge size  & high activity and
> online use of the tables].
> 
> Kind Regards and thanks to all there,
> 
> Rafi Ahmad
>

-- 
Joe Testa  http://www.oracle-dba.com 
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Joseph S. Testa
  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: William Beilstein
  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-claiming the space from Table after deleteion

2001-03-09 Thread Majumdar, Uttam


Provided all extents of the desired table are in same size, the incoming
data should use the free space.
regards;
Uttam majumdar

-Original Message-
Sent: Friday, March 09, 2001 4:56 AM
To: Multiple recipients of list ORACLE-L


Dear All,

Platform: Solaris 2.6, Oracle: 7.3.4.0

We have a few tables which are growing very fast due to large no of
insertions. But the data gets obselete after a month and we use a
procedure to delete the obselete data from the tables. 

The problem is that the table does not free the space even after the
deletion of 40% of the data. 

How can we re-claim the unused space which got created due to deletion?

How do we ensure that future inserts are done in this unused space?


[We can not try exp/imp or truncate option 
due to the huge size  & high activity and 
online use of the tables].

Kind Regards and thanks to all there,


Rafi Ahmad



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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).


PG&E National Energy Group and any other
company referenced herein that uses the PG&E name or
logo are not the same company as Pacific Gas and
Electric Company, the regulated California utility.  Neither
PG&E National Energy Group nor these other
referenced companies are regulated by the California Public
Utilities Commission.  Customers of Pacific Gas and Electric Company
do not have to buy products from these companies in order
to continue to receive quality regulated services from the utility.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Majumdar, Uttam
  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).

Read Only View Constraint Question

2001-03-09 Thread Ruiz, Mary A (CAP, CDI)


Hi List,

I have been creating linked views using the "with read only" clause.  I recently 
became aware that for each read only view, an Oracle-named constraint (starting with 
SYS_C00)
exists with constraint type 'O' and the constraint is disabled in every case.  Is this 
normal ?  The database is Oracle 7.3.4 on Sun Solaris 2.6   I tried to find something 
in the
docs but it was not obvious.

Thanks in advance,

Mary Ruiz / Atlanta GA
p.s I am with GE Capital but not GEFA.  I think I have been receiving all of the posts 
from the list, in uncensored form .

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruiz, Mary A (CAP, CDI)
  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: Netbackup and RMAN

2001-03-09 Thread Majumdar, Uttam


Netbackup is a media management tool. Once you install netbackup, it will
give you some sample online and offline DB management scripts using oracle
RMAN utility. We use combination of Netbackup and RMAN in our environment.
You can use your own RMAN scripts that can point to netbackup controlled
channels. 
regards:
Uttam Majumdar

-Original Message-
Sent: Thursday, March 08, 2001 9:50 PM
To: Multiple recipients of list ORACLE-L


We are planning to use Veritas Netbackup to backup our Oracle Database(OPS).
I am not sure whether we need to use the combination of Netbackup and RMAN
to take the backup/recovery or just Netbackup is sufficient to take the
backup.

Can anyone tell how this combination works.

Should I have Both or just Netbackup is sufficient for the Oracle backup and
receovery.

thanks

Ravindra

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ravindra Basavaraja
  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).


PG&E National Energy Group and any other
company referenced herein that uses the PG&E name or
logo are not the same company as Pacific Gas and
Electric Company, the regulated California utility.  Neither
PG&E National Energy Group nor these other
referenced companies are regulated by the California Public
Utilities Commission.  Customers of Pacific Gas and Electric Company
do not have to buy products from these companies in order
to continue to receive quality regulated services from the utility.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Majumdar, Uttam
  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).

developing Oracle applications

2001-03-09 Thread John Dunn


Hi...we are trying to come up with a strategy with regard to our software
development. We want to write applications that access the Oracle database
in a non-proprietry language...sucha s C or Java...

Does anyone have any recomendations?

John 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Dunn
  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-claiming the space from Table after deleteion

2001-03-09 Thread C.S.Venkata Subramanian


 If we delete data from a table, tables highwater mark doesnot come down. That's why u 
cannot reclaim the freespace after deletion from a table.

This FYI&A
--

On Fri, 09 Mar 2001 01:56:07  
 rafi wrote:
>Dear All,
>
>   Platform: Solaris 2.6, Oracle: 7.3.4.0
>
>We have a few tables which are growing very fast due to large no of
>insertions. But the data gets obselete after a month and we use a
>procedure to delete the obselete data from the tables. 
>
>   The problem is that the table does not free the space even after the deletion 
>of 40% of the data. 
>
>How can we re-claim the unused space which got created due to deletion?
>
>How do we ensure that future inserts are done in this unused space?
>
>
>   [We can not try exp/imp or truncate option 
>   due to the huge size  & high activity and 
>   online use of the tables].
>
>Kind Regards and thanks to all there,
>
>
>Rafi Ahmad
>
>
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: 
>  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).
>


Get 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  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: Weird - unable to extend error


smack your fellow DBA around for logging in as system and not his own
id, and I still stand by my statement change the system userid temporary
tablespace to temp.

joe
> lerobe - Lee Robertson wrote:
> 
> Sorry Guys,
> 
> Ignore this message. One of the other DBAs had logged in from home (he
> gets in later in the morning than me so I never got a chance to speak
> to him before sending this mail) and attempted to create an index on a
> table while logged in as system
> 
> create index user.tabind blah blah ..
> 
> and thought by using the fully qualified schema name it would appear
> in the TS he wanted it in.
> 
> Ho hum
> 
> 
> Lee Robertson
> Acxiom
> Tel:0191 525 7344
> Fax:0191 525 7007
> Email: [EMAIL PROTECTED]
> 
>  -Original Message-
>  From: lerobe - Lee Robertson [mailto:[EMAIL PROTECTED]]
>  Sent: 09 March 2001 08:25
>  To: Multiple recipients of list ORACLE-L
>  Subject: Weird - unable to extend error
> 
>  Oracle 8.0.5.0.0
>  Tru64 4.0f
> 
>  Got in this morning (duh duh duh duh)
>  and found a mail from my alerting script from the DB with
>  the following
> 
>  ORA-1652: unable to extend temp segment by 27309 in
>  tablespace
>SYSTEM
> 
>  As far as I am aware there was absolutely nothing going on
>  on this system and indeed was the first entry in the alert
>  log file for about 2 hours. (Normal operations on this DB
>  stop at about 18:00 - the message appeared at 20:20.).
> 
>  Should I be worried ?? There have been no entries in the
>  alert log since. (saying that though, people don't start
>  using it until about 9am).
> 
>  Lee Robertson
>  Acxiom
>  Tel:0191 525 7344
>  Fax:0191 525 7007
>  Email: [EMAIL PROTECTED]
> 
> 
> 
>  The information contained in this communication is
>  confidential, is intended only for the use of the recipient
>  named above, and may be legally privileged. If the reader
>  of this message is not the intended recipient, you are
>  hereby notified that any dissemination, distribution or
>  copying of this communication is strictly prohibited.
>  If you have received this communication in error, please
>  re-send this communication to the sender and delete the
>  original message or any copy of it from your computer
>  system.

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  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-claiming the space from Table after deleteion


sounds like a candidate for partitioning.

joe
[EMAIL PROTECTED] wrote:
> 
> Dear All,
> 
> Platform: Solaris 2.6, Oracle: 7.3.4.0
> 
> We have a few tables which are growing very fast due to large no of
> insertions. But the data gets obselete after a month and we use a
> procedure to delete the obselete data from the tables.
> 
> The problem is that the table does not free the space even after the 
>deletion of 40% of the data.
> 
> How can we re-claim the unused space which got created due to deletion?
> 
> How do we ensure that future inserts are done in this unused space?
> 
> [We can not try exp/imp or truncate option
> due to the huge size  & high activity and
> online use of the tables].
> 
> Kind Regards and thanks to all there,
> 
> Rafi Ahmad
>

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  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: Weird - unable to extend error

this is a bad move, NO ONE should be using system as their temp
tablespace, INCLUDING SYS, make everyone use temp.

why would you tell someone to go and change system to use max extents
unlimited, this just complicates the problem.

Out of curiosity, Ganit how long have you been a DBA?

Joe

[EMAIL PROTECTED] wrote:
> 
> Hi lee,
> 
> Some temporary sorting kind of thing takes place in SYSTEM tablespace while
> you create ome indexes or rebuild indexes.
> So
> 
> alter tablespace system default storage(maxextents unlimited)
> 
> you revert back after work is finished.
> 
> Cheers
> Ganti
> 
> ---
> 
> The contents of this e-mail are confidential to the ordinary user
> of the e-mail address to which it was addressed and may also be
> privileged. If you are not the addressee of this e-mail you should
> not copy, forward, disclose or otherwise use it or any part of it
> in any form whatsoever. If you have received this e-mail in error
> please notify us by telephone or e-mail the sender by replying to

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  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: Weird - unable to extend error