Hi
Thx all those that replied.
I've decided to create a procedure to truncate the table and grant execute
to the user.
Jack
Ron
for procedure source you could query user_source
to describe the procedure you could use SQL desc procedure_name
--
From: Alaa Mostafa[SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 3:37 PM
To: LazyDBA.com Discussion
Subject: How to display a
List,
Does anyone know of some good resources about gathering statistics on Hash
Clusters. I am particularly interested in finding out how full our buckets
are and any chained links we have currently.
Thanks before hand for you help.
Tim Boles
DBA
Lockheed Martin Information Systems
[EMAIL
Hi Experts,
Oracle interMedia enables Oracle8i to manage image, audio, video
in an integrated fashion with other enterprise information. This
means that complex multimedia data can be stored, retrieved,
and manipulated by Oracle8i in the same fashion as traditional
relational data using data
Thanks for posting the results, Robert.
I like the new feature. At least, I don't see how it hurts anyone.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, September 24, 2002 5:58 PM
To: Multiple recipients of list ORACLE-L
9i backup results. Note
Your current session's DB has been gone out.
Here is the scanario,
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL SET SERVEROUT ON
SQL BEGIN
2 dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD
Seems like not a network then. Have you read a note 1020463.6 (mind you, it is a bit
dated)?
inka
-Original Message-
Sent: Tuesday, September 24, 2002 11:08 PM
To: Multiple recipients of list ORACLE-L
I will try that.
The confusing part is I can run :
select TO_CHAR(SYSDATE, 'DY,
Hi Friends
Is there any way to point at the first line of openned cursor ?
For example :
After apply the for ... loop
at the finished i would like to set the first line , but i don't want to
open it again
Regards
Eriovaldo Andrietta
[EMAIL PROTECTED]
--
Please see the official ORACLE-L
Hi DBAs,
WinNT service pack 6. Oracle 8.1.6.
On several of the servers I am getting Initialzation of c:
\winnt\system32\DLL user32.dll failed. Notes on MetaLink are not
applicable. The only thing
added to these servers was TrendMicro server protect 5.31. I do not know
if coincidence or
Hey all,
I want to make changes to the ONAMES region database (8.0.5.0.1 on OpenVMS)
entries because I didn't fully qualify the host names in the network
aliases. And now that I can VPN in to work (thanks to DirecTV DSL!), I
can't use ONAMES because my machine at home is in a different IP
Does anyone know of a way to modify existing tablespaces to use the Auto SEGMENT SPACE
MANAGEMENT in a 8i dbs upgraded to 9i ?
thanks
vikas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kawatra V (Vikas) at Aera
INET: [EMAIL PROTECTED]
Fat City Network
SET SERVEROUTPUT ON
BEGIN
dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY'));
END;
/
WED, SEP 25 10:20:10002
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 25, 2002 8:38 AM
Your current session's DB
First, try a simple reinstall of your current service pack.
If that fails to solve the problem then see if this link applies:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q142676;
Is another virus protect product running at the same time as TrendMicro
server protect?
If so then try
Let me clarify my original question.
I do not expect the FreeList for a table to get updated instantaneously
after I change the PCTFREE/PCTUSED.
What I meant by is the effect ... immediate is that do the
new values come into play immediately -- even for existing blocks.
Suppose I have a table
Hemant,
If I understand your question correctly, trying using the alter table move command and
specify new values for pctfree and pctused. This should affect existing blocks. Make
sure to rebuild any indicies.
HTH,
--
Alan Davey
[EMAIL PROTECTED]
On 9/25/2002 11:38 AM, Hemant K Chitale
Okay, I'm about to create some locally managed tablespaces for some
large partitioned tables. I plan on making each datafile 2GB, with an
extent of 20M.
What I've done other times when I use LMTs is add 64K to the file size,
for the bitmap header, so that I don't waste most of an extent. But in
Hemant wrote
Therefore, to reduce the contention for the hot blocks, I decide
to have only 1 row in each block. Normally, with a *NEW* table,
PCTFRE 99 and PCTUSED 1 would ensure that I have only 1 row per block.
But if I have a large number of blocks in a few extents created when
PCTFREE was
Hi Rachel,
I know the guy who creates the warehouses here uses 4Gb datafiles (I believe
he creates them at 4050Mb).
We are on Tru64 Unix
He is on his honeymoon at the moment so I cannot ask him his reasoning.
Regards
Lee
-Original Message-
Sent: 25 September 2002 17:33
To: Multiple
On a system with ASYNC IO Enabled, have you seen any benefits from
enabling multiple DBWR processes, and if so how much of an impact
did you see? I've experimented with this before and didn't see much
improvement, but I'm curious what others experiences are.
RF
Robert G. Freeman - Oracle OCP
Google search leads to Gates of 'hell'
Type go to hell (using the quotation marks) into Google's search engine, and
the first result served up is Microsoft.com.
http://computerworld.com/newsletter/0%2C4902%2C74566%2C0.html?nlid=AM
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
Hello all
I am trying to debug a mysterious sporadic error that a Visual Basic
program using ADO is hitting. In reviewing the trace file, we see an odd
series of SQL statements. Before performing a 3 table join, a select * from
table is issued for each of the tables to be joined. The developer
Hi
Gurus
We customize
pharmaceutical processing industry applications. One of our client is going
global. The client needs to change NLS_LANGUAGE setting to
NLS_LANG="american_america.utf8".
I would like
to know how to change this and
what impacts
will it have on reports and forms
See Note:199416.1 and the Bug No.2410612 CONVENTIONAL EXPORT HAS WRONG DATA ON IMPORT
on metalink. I recently had problem while reorganizing some tables in our Baan
production database using export and import. The import was failing with duplicate key
s in table errors.
Manmohan.
Yes, of course. If, like last night, I needed to dial in from home for 2
hours then I get compensated by coming in early the next day to answer
questions about what happened.
-Original Message-
Sent: Tuesday, September 24, 2002 11:08 AM
To: Multiple recipients of list ORACLE-L
I know that wuth 64 bit HP-UX and 64 bit Oracle RDBMS,
I have no problems with 1 8GB file. I don't know much
about Solaris, but I suppose the following will work:
nm $ORACLE_HOME/lib/libclntsh.so|grep lseek64
Results should be nonempty and look something like
this:
__lseek64 |
You want to use compressed table? Just do a quick ALTER TABLE
and everything will be cool.
-Original Message-
From: Kawatra V (Vikas) at Aera [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 11:28 AM
To: Multiple recipients of list ORACLE-L
Subject: 9i : Segment space
The interMedia Text option certainly handles PDF, DOC PPT. I believe
JDeveloper is pretty well integrated with interMedia Text, so I suspect
that it does what you're looking for.
At 06:33 AM 9/25/2002, Omar Khalid/IT/LotusCert/Pk wrote:
Hi Experts,
Oracle interMedia enables Oracle8i to
Are you going with 2048M or the traditional 2000m?
A quick dirty way to not waste the space is to use 2001m or 2041m. You
'waste' a little space, but not much.
Dan Fink
-Original Message-
Sent: Wednesday, September 25, 2002 10:33 AM
To: Multiple recipients of list ORACLE-L
Okay, I'm
What version of the database? What version of forms/reports? What platform? What is
the current
characterset of the database?
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
We currently are creating partitions of a given table in individual
tablespaces (1 partition = one tablespace). To me, this seems like a
reasonable practice. Anyone have any thoughts about this they would like the
share?
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier
Okay, I think I answered my own question. If you look at the Fetch line on
the select * calls, it is zero. My guess is that ADO is just checking for
the existence of each table before it makes the real SQL call.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
The Japanese eat very little fat and suffer fewer heart attacks than the
British or Americans.
The French eat a lot of fat and also suffer fewer heart attacks than the
British or Americans.
from a friend,,,
The Japanese drink very little red wine and suffer fewer heart attacks than
the
Title: RE: datafile sizing question
We created two datafiles of 16GB+64K all LMT autoallocate ... never gave a problem. A basic testing concluded that fixed size allocation of 128M caused unnecessary delays whereas autoallocate was much faster. I don't know the full details yet, but I'll know
AHA!I was going to go with 2000M so that's beautiful, 2001M would work
perfectly without going over. I don't mind wasting less than a meg.
I love the logic everyone here at work has. disk is cheap, don't
worry about it. Except every time I ask for more disk, I hear it's too
expensive
Rachel
---
On VMS, I believe the I/O is async by default (probably via $QIO calls), so
there's no benefit there. This is from memory, as I'm not able to confirm
or deny that with a quick search.
On HP/UX, you can't use async with a cooked volume, and in MetaLink 139272.1
it says not to use multiple DBWRs
Dennis,
I've seen ADO do some pretty strange stuff under the covers on my project
also. Ny guess is that ADO is sending these sql statements kinda like a
prepare statement, just to see if the query will pass muster - like basic
security checks - does the table exists, etc. My guess is that it
That's one way to get a 99.99% buffer cache hit ratio for the statement!
-Original Message-
Sent: Wednesday, September 25, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L
Hello all
I am trying to debug a mysterious sporadic error that a Visual Basic
program using ADO is
I'm betting that it's not 64-bit Oracle. See, I am the development DBA.
As an employee, I get to create the scripts, but I don't get to run
them or even get access as oracle to the servers.
In other words, all the grunt work, all the responsibility for problems
(production is managed by a
Title: RE: Best Practice - Partitioned object, one partition per tablespace,
BTW, moving partitions from one tablespace to another is quick and easy so if later you have a real reason to have more tablespaces you can create them - our I/O configuration and access path did not warrant it at
Robert - That is how I've generally done it. If you are partitioning because
the table is very large, then separate tablespaces gives you the flexibility
to place these partitions on separate devices so you can get some parallel
I/O going.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
I believe that the OS filesystem has to be configured for large file
support (on HP-UX, it's a kernel parameter) to allow files 2 GB.
I usually just add 1 MB to the file size to allow for the header.
Personally, I'd play it safe and go with however many 2001 MB files you
need to accommodate
OK, maybe adequate was the wrong word.
It *can* be done with ksh. But it's rather ungainly.
In Perl:
my $dbh = '';
eval {
local $SIG{ALRM} = sub { die };
alarm 60;
my $dbh = DBI-connect(
'dbi:Oracle:' . $db,
'scott','tiger',
);
};
alarm
That's the way I've done it.
It let's you drop a partition and drop the tablespace
so nothing is left.
--- Freeman, Robert [EMAIL PROTECTED] a
écrit : We currently are creating partitions of a
given
table in individual
tablespaces (1 partition = one tablespace). To me,
this seems like a
it's what I'm planning on doing... seems to me that when we decide to
remove partitions, we can easily do so and retrieve the disk space this
way
--- Freeman, Robert [EMAIL PROTECTED] wrote:
We currently are creating partitions of a given table in individual
tablespaces (1 partition = one
-Original Message-
Sent: Wednesday, September 25, 2002 1:04 PM
To: Multiple recipients of list ORACLE-L
Yes, of course. If, like last night, I needed to dial in from home for 2
hours then I get compensated by coming in early the next day to answer
questions about what happened.
Hi,
We have a strange behavior on our Oracle 8.1.7.x Db
on Solaris.
We have an update that 'probably' update all rows from
a table.
But when we check the v$sql_area view we have 0 rows
affected and 1 execution.
How is it possible ?
// W.B
__
Got a couple of questions for those of you dealing with SAP:
1) Has anyone heard of a timeline as to when (or if) SAP R3 will support
Oracle 9.x? And,
2) Has anyone implemented table partitions as a method of space management
in conjunction
SAP archiving? The table dependencies within SAP
It is your own fault. You should have called all interested parties with details as
soon as that problem was resolved. And remember: if by any chance the problem
resolution takes all night, call hourly with the progress report.
-Original Message-
Sent: Wednesday, September 25, 2002
Title: RE: Best Practice - Partitioned object, one partition per tablespace,
What if working on limited I/O so that striping is done at the OS level mostly. In this case there is no advantage to one partition - one tablespace and if there are many partitions it just gets hard to maintain.
Boy, I go to a new job and I don't have any of my old notebooks. I remember
something like this from the past from a third-party app. The first three
queries would just be verifying the existance of the object. Can't remember
if it was via a SELECT * (I don't think so) or some other similar
No habla Ingles.
-Original Message-
From: Regina Harter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L
Subject: Fwd: Diets
The Japanese eat very little fat and suffer fewer heart
attacks than the
British or
That's the strategy I have followed in my databases. Each table partition
and each index partition is in its own tablespace. Helps me a lot when I do
any maintenance operations. Partitioning is by 4 digit calendar year.
- Kirti
-Original Message-
Sent: Wednesday, September 25, 2002
Rachel, that is the same thing as with money itself. Everybody
keeps telling me that money isn't everything and that there are
many things in life which are more important then money, but when
I ask for a check to $10,000 nobody wants to give it to me.
Humans are so hard to comprehend for us
Rachel, if you can execute sqlplus, you can do the nm thing.
You don't need to log in as oracle.
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: datafile sizing
Hello guys,
I am trying to figure out the mystery of Patch 380665, which allows Forms 3.0 to be
used with Oracle 8.1.7
I have a few questions
1. Does this patch exist or is it just a myth?
2. Is this a Database patch or Forms patch?
3. How to get this patch?
I would really appreciate if any
Sorry Gurus
The database version is: 8.1.6.0.0
Reports: 6.0.5.28.0
Forms: 6.0.5.2
Current NLS_LANGUAGE: AMERICAN
Current NLS_NCHAR_CHARACTERSET: WE8ISO8859P1
Current NLS_CHARACTERSET: WE8ISO8859P1
Current NLS_CALENDAR: GREGORIAN
Appreciate your response
Shiva
-Original Message-
After having little success with registering and
dropping using the namesctl commands. I have used
direct insert, update to the ONRS_REGION table as the
peferred method to tp update the region database. No
problems so far. make sure you have no space in any
descriptions.
I even have script to do
Exactly the way we do it as well.
Each table and index partition are in their own tablespaces (indexes are
local and not global)
Regards
Lee
-Original Message-
Sent: 25 September 2002 20:54
To: Multiple recipients of list ORACLE-L
tablespace,
it's what I'm planning on doing... seems
In Perl:
my $dbh = '';
eval {
local $SIG{ALRM} = sub { die };
alarm 60;
my $dbh = DBI-connect(
'dbi:Oracle:' . $db,
'scott','tiger',
);
};
alarm 0;
unless ($dbh) {
print db $db is down;
}
Humm do you know
Dennis,
Ask Anjo about his Magic utility. Using that utility one has to set an environment
variable on the client which would tune and avoid extra parse sql before they are sent
to Oracle. Infact Cary mentions about this in his emails.
btw we use delphi 3rd party ODAC component instead of
Hi,
Is it possible to write a BLOB as a file on the OS through a Java stored
procedure?
Regards,
Manav.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Manavendra Gupta
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
I think it's automatic on Solaris 2.8 but I don't know for sure so I'd
rather not rely on it.
I'm going with 2001M and creating about a year's worth of
tablespaces/partitions. 101 datafiles and tablespaces. Just to
START.
my aching typing fingers!
--- Paul Baumgartel [EMAIL PROTECTED]
We have a database which stores 5 years data with most
of the tables partitioned on year_month. We have three
tablespces each for each table, with tablespace_1
having 01,04,07,10 months and tablespace_2 having
2,5,8,11 and tablespace_3 having 3,6,9,12
--- Rachel Carmichael [EMAIL PROTECTED]
Excellent! Glag to see I won't exactly be a guinea pig for this.
One question: Do you issue an ONAMES RELOAD after this is done? I'm not
sure how else the Names Server would be made aware of the change, except
after it's daily (by default) region DB refresh.
Thanks!
Rich Jesse
That sounds about right! You can get back to your boss
with a little sleep deprivation tactics. Beep him hourly
with the progress report and he'll trust you much more
the next time. You can even beep you bosses boss and tell
him that your boss told you to beep him hourly with a progress
report.
It's backup day today so I'm pissed off. Being the BDBAFH, however, does
have it's advantages. I reassign null to be the tape device - it's so much
more economical on my time as I don't have to keep getting up to change
tapes every 5 minutes. And it speeds up RMAN too, so it can't be all bad can
Yes, you need a reload so that it takes immediate
effect.
--- Jesse, Rich [EMAIL PROTECTED] wrote:
Excellent! Glag to see I won't exactly be a guinea
pig for this.
One question: Do you issue an ONAMES RELOAD after
this is done? I'm not
sure how else the Names Server would be made aware
Not on raw, but occasionally on filesystem-based async
IO (Solaris) especially when using massive caches
But generally - I'm in agreement with your observation
hth
connor
--- Freeman, Robert [EMAIL PROTECTED] wrote:
On a system with ASYNC IO Enabled, have you seen any
benefits from
Unless you've got lots and lots on concurrent
transactions on tables, I wouldn't touch ASSM if I
were you. I've been told of some horror stories
hth
connor
--- Kawatra V (Vikas) at Aera
[EMAIL PROTECTED] wrote: Does anyone know of
a way to modify existing
tablespaces to use the Auto SEGMENT
How does ASSM relate to compressed tables?
--- Gogala, Mladen [EMAIL PROTECTED] wrote: You
want to use compressed table? Just do a quick
ALTER TABLE
and everything will be cool.
-Original Message-
From: Kawatra V (Vikas) at Aera
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday,
I need to write a pl/sql procedure to produce a form via the pl-sql cartridge. Not a
problem- been
doing this kinda thing now for a couple of years.
Now I need to handle a INPUT TYPE=FILE tag in the form. Anyone know how to process
the result via
pl/sql or am I going to need to write a cgi
Hi All,
Please give me
inputs on this hint and the affect of having a large
HASH_AREA.
Thanks,
Rajesh
Unfortunately, this is one of those things that *doesn't*
work on Windoze, no support in the kernel.
Jared
Bob Metelsky [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/25/2002 01:48 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Title: OT: MIcrosoft Blackmail
This came to our DBA team today. I'd appreciate your thoughts. I'm not a business
guy, just a plain old Apps DBA, but this really pisses me off. Is it common practice
by MS?
It is important from an Architecture point of view that we understand all the
Since WE8ISO8859P1 is not a strict subset of UTF8, you will need to recreate the
database. Since
you need to recreate, take to opportunity to upgrade to 8.1.7.4 or 9.0.2
Also, I would suggest upgrading to at least Dev 6i, patchset 6 (6.0.8.15), but
preferable patchset
10 (6.0.8.19). This
I am in the process of upgrading our databases from 8.0.5 to 8.1.7,
possibly 9i depending on application
certifications.
I currently have a tablespace that is made up of 4 - 200mb datafiles, my
first thought would be to
create a 800mb datafile and move all the data into it,
The growth of this
Is anyone using this
new init.ora parameter? Does it really seam to help recovery
times? Does anyone have any good or bad stories about this?
Thanks!!
Nick
It's ODBC, I think. The MS ODBC driver (are they using ODBC? If so, is it
an MS driver or an Oracle driver?) tends to do SELECTs like this in lieu of
a DESCRIBE. They don't fetch from the cursors; they just read the
select-column information returned in order to perform a crude DESCRIBE of
Steve, this is great! I must bow to the master!
-Original Message-
From: STEVE OLLIG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 5:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DBA work load - BDBAFH #1
It's backup day today so I'm pissed off.
Hi Ron,
In short (as I am hitting the bed)
What I have here is done via 9ias.
It (ias) requiers that you define a document table with some specifick
column (you can add your own ) (look in the documentation)
The script I am sending you requiers some other scripts and access
diffrent kind of
Is there a reason you can't just resize the existing file?
-Original Message-
Sent: Wednesday, September 25, 2002 7:43 PM
To: Multiple recipients of list ORACLE-L
I am in the process of upgrading our databases from 8.0.5 to 8.1.7,
possibly 9i depending on application
certifications.
Darren - My advice would be to read up on Locally Managed Tablespaces (LMT)
and uniform extents. This is a new feature that will ease your management
work.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, September 25, 2002 6:43 PM
To: Multiple
It's late at night maybe that's why I do not
understand your answer but I do not see the link
between LMT and the number/size of datafiles.
One reason of multiple datafiles id to spread IO but
since nowadays a majority of sites goes on huge disk
box using raid 5 (that's what we have, the unix
Hi,
We're investigating the use of Advanced Queues as a way of transferring information
between OSI's PI and Oracle.
The data will originate on the Oracle side and end up in PI.
We were thinking of using Oracle's Heterogeneous services and PI's ODBC driver, but
ran into 2 phase commit errors
Mladen,
I'd love to hear your poetry -- but only if you are reciting it at the
December NYOUG meeting as the keynote speaker.
I still need a keynote speaker for that meeting...
Rachel
--- Gogala, Mladen [EMAIL PROTECTED] wrote:
Rachel, that is the same thing as with money itself.
I can't with the account they have given me. At least, not yet :(
this is so well planned I will be amazed if it goes live on time. and I
(and my boss) are living by two mottos failure to plan on your part
does not constitute an emergency on mine and if it fails, it will NOT
be because of
For more information see
$ perldoc perlport
Not much more information, mind you, but at least a positive statement
that alarm is not implemented on Win32. This document also describes all
the other stuff without which I can't believe an operating system can
survive commercially...
NOMAIL ORACLE-L
__
Do you Yahoo!?
New DSL Internet Access from SBC Yahoo!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services--
Title: migrating 8.x-9i and charsets
Ron I was reading your response about converting to UTF8 and it has risen some curiosity with my situation and recent upgrade of a DB from 8.1.7.2 to 9.1.0.3. A snippet from the migration manual states:If the old National Character Set is UTF8, then the
Title: RE: migrating 8.x-9i and charsets
what I found odd after reading the migration manual is that the 9i
upgrade database is still showing:
NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET WE8ISO8859P1
I haven't found any issues with functionality, keeping in mind this
two tier
Ooops!!!
Got tired of us, eh!
Now, you're sure going to miss Mladen's poetry !! ;)
- Kirti
-Original Message-
Sent: Wednesday, September 25, 2002 10:43 PM
To: Multiple recipients of list ORACLE-L
NOMAIL ORACLE-L
__
Do you Yahoo!?
placing them in different tablespaces also allows you to place older
tablespaces into READ ONLY mode and reduce the volume of backups. also
permits moving less-frequently accessed tablespaces to near-line storage,
such as tape-based file-systems or CDROM...
- Original Message -
To:
It's backup day today so I'm pissed off. Being the BDBAFH, however, does
have it's advantages. I reassign null to be the tape device - it's so much
more economical on my time as I don't have to keep getting up to change
tapes every 5 minutes. And it speeds up RMAN too, so it can't be all bad
Another approach is to partition according to your load strategy, but make
them reside in tablespaces according to how you want to set them to READ
ONLY.
For example, if you load daily, partition daily. But if you want to set the
data into READ ONLY to reduce backup volumes on a quarterly
94 matches
Mail list logo