Hello Dennis
I think that you need to backup the disk files to tape A.S.A.P.
What will you do if your disk has gone to the great disk scrap yard in the
sky?
One more point: Is the disk on the same machine or in the same room?
What will you do if a fire will destroy your server farm?
To g
Hi,
I don't know if sby answered you, pls don't mind if
sby did it so.
It is a hint use it in exports, imports and loaders.
Here I enclose a note that maybe can clarify more
about it.
Problem Description
---
You are querying the sql area and keeps seeing
NESTED_TABLE_GET_REFS
Dear All,
Does Oracle confirm to all 12 Codde's Rules. Can anyone
point out the Rules violated by each version (6/7/8/9) of Oracle.
Thanks,
Vikas
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
-
Friend :
Take a look at this text below.
I think it helps you.
Begin of the text -
Bookmark Fixed font Go to End
Doc ID: Note:106513.1
Type: SCRIPT
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 25-APR-2000
Last Revision Date: 19-
Hi,
V7 confirmed to 11 rules,except for the view updation rule, i feel this was solved in
v8. Other comments from other listers are welcome.
Venkat
--
On Fri, 18 Jan 2002 02:30:29
Vikas S wrote:
>
>Dear All,
>
> Does Oracle confirm to all 12 Codde's Rules. Can anyone
>point out the Rul
Hi,
thanks for you advice.
Let me see if I've got it straight...
So what you are using is purely OS based.
No special Oracle software.
There is only one node available at a time, and if it fails, then the second
one starts up, in roughly the same state as the first (i.e. no uncommitted
transac
Hi, thanks for your advice.
Data Guard is available for 8i as well I think. I will have to look into
what exactly it does,
Jim
-Original Message-
Sent: 17 January 2002 18:51
To: Multiple recipients of list ORACLE-L
I also heard of horror stories regarding Sun Clusters. I worked w/ HP
I created a database yesterday with English and French error message files,
then switched nls_language to French.
It looks very strange at first glance, all the commands are in English but
the error messages come back in French.
I wonder what this looks like in kanji characters!
Regards,
Patric
When I failover, I bring the Oracle Home as well. Do you have special reasons for not
bringing the Oracle Home over?
*just curious*
Gene
>>> [EMAIL PROTECTED] 01/17/02 08:45PM >>>
You will always have the same issues with fail over technology. Your users
will get disconnected. My database
Yechiel,
I believe that Dennis is moving towards backing up to tape. This is just
his first step in testing and implementing RMAN. It's a pretty complex
tool to use and takes quite a while to fully implement. RMAN can be
pretty overwhelming and Dennis is trying to bite off small bits
Patrice,
I think, to get commands in other than English, you have to specify
language, when installing Oracle software, not when creating the database.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Frida
We have a number of partitioned tables in a couple of existing data
warehouses.
We are working on the design for a new warehouse and need to decide which
tables should be partitioned.
For you folks that have partitioned tables, how do you decide which tables
to
be partition? Some tables with v
Hey Jeremiah, add in something to the last paragraph about how using
LMTs will obviate the problem in truncating tables with lots of extents
:)
There really is NO reason to worry about large numbers of extents these
days. I mean, I wouldn't want to really test the "unlimited" ability
but other th
Jerry,
Tell the client that you will be HAPPY to reorg the tables and indexes
over 10 extents. It will cost X dollars and take Y hours of
downtime/slowdown. Insert inappropriately huge numbers into X and Y.
It's amazing how quickly people will change their minds when you talk
hours and dollars.
Ah but with 9i, RAC and TAF you can have the users reconnected
automagically and they will resume their transactions inflight.
--- Kimberly Smith <[EMAIL PROTECTED]> wrote:
> You will always have the same issues with fail over technology. Your
> users
> will get disconnected. My databases take
and in any case, I truly believe you should do the backup to disk and
then back that up to tape...
what happens if there is a problem with the tape drive? Will the backup
hang because it's stuck?
Just easier.
--- [EMAIL PROTECTED] wrote:
>
> Yechiel,
>
> I believe that Dennis is moving towa
Hi All,
I did a successfull export on 8.1.6 for user=
I am trying to import on same server into another user. I get following
message but no tables are created?
I have full privs.
Can someone help?
Connected to: Oracle8i Release 8.1.6.0.0 - Production
JServer Release 8.1.6.0.0 - Production
Yup. Now that being said, HP has a ServiceGuard that is compatible with
OPS but I am not familiar with its setup. I could run OPS on my setup
though. You need clustering for OPS to work as well (according to the
docs).
-Original Message-
McCann
Sent: Friday, January 18, 2002 3:21 AM
To
Hi,
I want to analyze some archive log files with
LogMiner. The logs are stored in an RMAN backup on
tape. I am trying to restore the files to a
development box but when I perform the restore I get
the error message "RMAN-20003: target database
incarnation not found in recovery catalog". The synt
I´m a brand new user in both
Linux and Oracle, so far it's been a good
experience in learning both. At the moment I'm stucked up trying to create an
instance database... Had some problems installing Oracle, but it is minor
headache comparing to create a database!!! If someone could
help
I did that, only the error messages come back in English.
This is the first time I try this, maybe I missed something.
I imagine though that SQL in anything other than English is non-standard,
though.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
S
Ethan
The database is in production and users are accesing 24x7.What will be best
approach to do?
DO u have any scripts how to find HWM?
Thanks
-Seema
>From: "Post, Ethan" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE
I have way to many f'ing Oracle Homes to deal with. When I first got here
they were all different versions as well. So it was more of a maintenance
thing. To tell you the truth someone else originally set it up that way and
I liked it so I kept it. It does mean I have to keep more in sync manu
Every night after I shutdown immediate and restart the instance I get this
same trace file in bdump, it just keeps appending. It is associated with my
Archive log process. The two entries are for the nights of the 15th and
16th. Note that it happens right at 22:18 when my instance is restarting
True but I doubt they will approve the downtime for the upgrade now:-)
-Original Message-
Carmichael
Sent: Friday, January 18, 2002 5:31 AM
To: Multiple recipients of list ORACLE-L
Ah but with 9i, RAC and TAF you can have the users reconnected
automagically and they will resume their tr
Speaking of TAF,
Does anyone know (or have tested/implemented/explored) TAF with Forms
application? Does this work??
We have another JAVA application that connects using JDBC and looks for
certain errors and whenever it detects an error (appropriate one), it
reconnects to the other side. Both si
Jerry - You could approach the issue a little more subtly. Here is an Oracle
paper where Oracle recommends locally managed tablespaces and uniform
extents. If you can point out to them that you are a modern DBA that is
keeping up with new Oracle features, I think that would be persuasive.
http:/
I am a member but I have not been to a meeting. I am in Richardson. If you
want to try to go together e-mail back and we can discuss it. thanks
David Ehresmann 972.656.1015
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Post, Ethan
> Sent: Thur
Hey all...I have to do some reorgs of some malformed IOTs (Index-
Organized Tables) in one of my databases. ALTER INDEX ... REBUILD
doesn't work, on the IOT or it's PK index.
Does anyone have an elegant method for doing a reorg on IOTs?
Thanx,
Mike
---
=
Listers,
Does anyone else see the humor in this? From the Metalink web site, the top
two New & Notes topics are this:
How to Ensure Uninterrupted MetaLink Access. 17-JAN-2002 N
Temporary Interruption in iTAR functionality: US, Canada and Latin America
Only! 14-JAN-2002 N
And topic "How to en
Title: RE: Freeable memory
Hi Mike,
I did a test on one of our 7.3 databases. It seems that some (but not all) freeable chunks get coalesced by flushing the shared pool. I tested it on a database with no other users logged in and took before/after pictures of the chunk breakdown.
SQL> se
Hi
Can I use following command to recover the space.
alter table deallocate unused;
I don't want to truncate and import.
Thx
-Seema
>From: "Ron Rogers" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: SPACE FREE HOW?
>D
Cherie - I am relatively new to partitioned tables, but I have two criteria.
1. Partition the table for performance. If you have some significant queries
that will be doing full table scans (not unusual for data warehouses), then
may partition so the full table scans just scan a selected partitio
export/drop/import.
Reply Separator
Author: "Vergara; Michael (TEM)" <[EMAIL PROTECTED]>
Date: 1/18/2002 7:30 AM
Hey all...I have to do some reorgs of some malformed IOTs (Index-
Organized Tables) in one of my databases. ALTER INDEX ... REBUILD
does
Yechiel - Thank you for your concern. Yes, in fact we back the non-database
files on the system up every night, so the RMAN file will actually get
written to several tapes. I just didn't mention it in detail.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent:
Nah, I make sure all servers have the same uid/gid for oracle but I have naming
standards for the lv's and filesystems. This allows me to failover multiple primary
servers to a single secondary. I was just curious, b/c I have seen other sites that
use your method. I prefer not having to sync
What does your imp command look like?
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Rick_Cale@team
The dba_space package has routines that will tell you wherer the hwm
mark. With
that infomration and 1.75 you can get a cup of coffee :-). Knowing
"where" the
HWM mark is, is not helpful. The only way to move it, is to truncate
the table.
I know this is difficult in a 24X7 system but frankly
I've seen a similar idea running on Silicon Graphics kit :
2 servers;
heartbeat check between them;
Drives mount on the other box when the 'live' system fails
It was nice when it worked...Testing the failover caused barely a ripple,
although it did disconnect any open sessions. A
I am converting to 9i and am thinking about using the undo tablespace rather than
rollback segments. Does anyone know if there are any performance implications in using
the undo tablespace? I tried a big import that ran 21 minutes using rollback segments
and 23 minutes using the undo tablespace
Walter,
You have restore the production database backup on the test server and
opened the database with resetlogs ...right. This has created a new
incarnation of the database.
RMAN does not recoginize the new incarnation of your test database since yu
have not done a "reset database".
HTH
-
HI Rick,
Could you share with us the export statement and the import statement
you used.
Tha will help figure out what went wrong.
John
[EMAIL PROTECTED] wrote:
>Hi All,
>
>I did a successfull export on 8.1.6 for user=
>I am trying to import on same server into another user. I get follow
Hey,
Thanks all. Who would'a figured that Metalink could actually be usefull for
researching this topic. When I sent the initial email I was actually
thinking I had already searched for help on Metalink. Anyway It is certain
that I hadn't, because there is actually a lot of helpfull info there
Thanks for sharing the laugh! Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 18, 2002 12:10 PM
> Listers,
> Does anyone else see the humor in this? From the Metalink web site, the
top
> two New & Notes topics are this:
>
>
Hello,
My 2 cents:
It does make a difference to reorg, esp. when done thoughtfully, with a
specific goal in mind. For example, if you have a order_log table that
started with first extent 1MB and next extent 1MB, and this table has grown
in size to say, 10 million rows (business is good), you wo
Hi, dear listers,
My boss has decided to switch production to a UNIX box and now he's asking
me for a recommendation between HP and SUN. I am a newbee to UNIX (to put it
the softest way). I've heard people say HP is better, but need more than
that...
The DB itself is about 40G on RAID (currently o
Hi all,
8.1.7.2.0 on HP/UX 11.0 -- A developer tested a table recreate in our test
DB. Here's the scenario:
CREATE TABLE MY_BIG_TABLE (
FISCAL_YEAR NUMBER (5),
PERIODCHAR (2),
ACCOUNTNO CHAR (12),
TRANSTYPE CHAR (2),
TRANSQTY FLOAT,
TRANSAMNT FLOAT,
Rick,
By default Oracle will import from/to the same user only.
You can do what you want by using the fromuser/touser option.
Something like imp user/pwd file=x.dmp fromuser=from touser=to
Type imp help=y for the specifics.
Hope this helps.
Tom Mercadante
Oracle Certified Professional
Title: RE: SPACE FREE HOW?
24x7... that does make it tough.. you might want to try LiveReorg from Quest Software... it allows you to reorganize those tables while users are still accessing them. It will even tell you which tables to reorg to free up the most space... without even deleting d
Sigh. I was afraid of that. Any other ideas?
---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation
(909) 914-2304
-Original Message-
Sent: Friday, January 18, 2002 9:44 AM
To: Vergara; Michael (TEM); Multiple
Deepak:
As a matter of fact I think you can find how many blocks below HWM
are unused (have no rows at all), by counting the number of blocks that are
below the HWM and hold at least one row. (check my previous mail)
SELECT COUNT(DISTINCT SUBSTR(rowid,15,4)||SUBSTR(rowid,1,8)) FROM TABLE;
Where the business use of the data is such that the applications' selects
can be satisfied by querying a known number of partitions (less than all
partitions). Also where data can be archived partition-wise. Generally
this means time sensitive data. I don't see much benefit to partitioning
data
Trace files related to arc are normal upon startup and shutdown. - E
-Original Message-
Sent: Friday, January 18, 2002 10:11 AM
To: Multiple recipients of list ORACLE-L
Every night after I shutdown immediate and restart the instance I get this
same trace file in bdump, it just keeps app
Hi i am trying to insert records into a table by selectiog from table 2, i
want to insert a sequence,, and the distinct values from table 1 but i get
an error:
Query used:
INSERT INTO contacts (cont_id,cont_contact_surname)
(SELECT seq_cont.nextval,distinct delegated_person
FROM sierras
Hi, Mike,
ALTER TABLE ... MOVE TABLESPACE ...;
rebuilds IOT's PK.
HTH
Vadim
-Original Message-
Sent: Friday, January 18, 2002 10:31 AM
To: Multiple recipients of list ORACLE-L
Hey all...I have to do some reorgs of some malformed IOTs (Index-
Organized Tables) in one of my databases. A
Steve,
I just happen to have an example script. :)
Here's a wrapper and a test.
First, the wrapper:
---
create or replace PROCEDURE sendmail (
sender IN VARCHAR2,
recipient IN VARCHAR2,
subject IN VAR
Paul,
With LMT's. uniform extents sizes and properly place objects I think you
avoid most of the situations you described. Cary's paper at hotsos.com
shows that in a system with a lot of activity your disk head is never going
to fulfill the request for a full tablescan in a single operation anyw
Hi, Jesse,
Didn't your dev use parallel insert on production to speedup things?
This may cause different segment allocation
HTH
Vadim
-Original Message-
Sent: Friday, January 18, 2002 12:41 PM
To: Multiple recipients of list ORACLE-L
Hi all,
8.1.7.2.0 on HP/UX 11.0 -- A developer tes
I'm trying to analyze some archive logs via LogMiner
and I keep getting the error ORA-03113 (end of file on
communications channel) when I query the
V$LOGMNR_CONTENTS view. I did a "new" and "start"
prior to running the query. This process that I am
going through works on some log files but not on
So I was just checking out the ixora script to look at values for hidden
parameters. And I discovered that _system_trig_enabled is FALSE on all my
databases!
If this is the default then why is it so important to specifically set it to
false during 8.1.7 upgrades? This value was FALSE not only fo
Try this
distinct(delegated_person)
Chuck Speaks
Database Administrator
Lithonia Lighting
770-860-3450
http://www.lithonia.com
-Original Message-
Sent: Friday, January 18, 2002 12:51
To: Multiple recipients of list ORACLE-L
Hi i am trying to insert records into a table by selectiog f
If you have good stats on the table just take the following and compare.
actual size of object vs. (#rows * average row size )
If actual size is much larger than #rows * average row size, you have a lot
of unused space in the table, this however does not tell you the high water
mark. There are
Try this:
INSERT INTO contacts (cont_id,cont_contact_surname)
(SELECT seq_cont.nextval, delegated_person from
(select distinct delegated_person
FROM sierras
WHERE delegated_person is not null));
-Original Message-
Sent: Friday, January 18, 2002 12:51 PM
To: Multiple recipi
No.
In fact, I don't believe that there is a database in existence that
does conform to all 12 rules.
I'll let someone else answer the hard part, just not enough time for that.
Jared
"Vikas S" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/18/02 02:30 AM
Please respond to ORACLE-L
Title: Need idea to strip tabs (chr(9) hex 9) and carriage return (chr(13) hex
0D) from fields
Linda,
I just did something like
this yesterday. You will need to use the TRANSLATE function. So you can use an
SQL statement like:
update
set fld1 =
translate(fld1,chr(09),’-‘);
Where can I find information on this parameter on the Tru64 UNIX platform?
I did a scan of the manuals for Tru64 UNIX at docs.oracle.com, but didn't
find mention of it anywhere.
I want to set db_file_multiblock_read_count properly...
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA
Stay with HP. It's a hell of a lot more reliable, and does not require
anywhere near the # of patches, and its patches work far more often that
Sun's. I've done 5 years with each, and there's no question that HP is
superior.
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 78
Are you talking about Support Magic from NAI??
Dick Goulet
Reply Separator
Author: "Shreeni" <[EMAIL PROTECTED]>
Date: 1/18/2002 10:30 AM
Hi list,
Can any body tell me about magic for oracle?
TIA,
Shreeni
Shreenivasa Rao.vcf
Description:
Seema:
Regarding the "Checkpoint not completed." message, make sure you're
checkpointing only at redo log switches.
Check loc_checkpoint_timeout and log_checkpoint_interval values.
If these values are OK and you still keep getting "Checkpoint not
completed." messages in the alert.log
Title: RE: SPACE FREE HOW?
Nick,
I have
a question regarding LiveReorg's method that prevents modifications to the
original table when it's time to switch to the newly reorged one. AS the
mechanism to prevent DML, LiveReorg creates a temporary trigger
on Insert, Update and Delete. It simp
Using both HP 11.0 and Solaris 2.8, I have a preference for HP. Just little
toolset things like SAM for a GUI SysAdmin, "top" and "GlancePlus", although
GlancePlus, a system monitor, I guess I would consider a huge advantage over
what Sun offers.
As far as the hardware, I guess I don't have a hu
Thank you, Paul, I'll forward it to my boss... Anyone else to add to it?
Thank you very much,
Sergey Babich
-Original Message-
Sent: Friday, January 18, 2002 3:55 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: HP vs SUN for a UNIX box
Stay with HP. It's a hell of
imp user/pass@service file=file.dmp log=test.log fromuser=caler
touser=newuser tables=(*)
I have also done above with charset=us7ascii no difference
Rick
If I were you I'd try to analyze both tables (prod and test), posibly on
a small sample, to check whether the average row length is identical.
The 'comment' field, which can be close enough to 60%, may be NULL in
your test database and full in most cases in prod. Something else one
could think of
can't you
create table parallel 5 nologging as select /*+ parallel(iot 5)
*/ * from iot
Then
Truncate your IOT
Then
Make sure the the IOT has nologging
insert --+ append
into IOT
select --+ enable parallel here
*
from
-Original Message-
Sent: Friday, January 18, 2002 1:21 PM
To
Thanks, it is very important to me
Regards,
Serge
-Original Message-
Sent: Friday, January 18, 2002 4:05 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: HP vs SUN for a UNIX box
Using both HP 11.0 and Solaris 2.8, I have a preference for HP. Just little
toolset th
Thanks for the response Diego. I will try running this
on my system.
Rgds
Deepak
--- Diego Cutrone <[EMAIL PROTECTED]> wrote:
> Deepak:
> As a matter of fact I think you can find how
> many blocks below HWM
> are unused (have no rows at all), by counting the
> number of blocks that are
Auditing would be more reliable, it's static.
Using v$db_object_cache would require monitoring the view, determining
the difference from the last time you checked it, etc. You would lose any
data between the last time you checked and a database shutdown.
Jared
[EMAIL PROTECTED]
Sent by: [E
Hi Guys!
Hope everyone had a good holiday. I'm back from 3 weeks off and
feeling rested. Maybe a bit too
rested.
I got a question on whether Oracle has a concept of resource
management... that is, if user X consumes too much CPU time, or the query
runs too long, whether there is s
oracle still does 64K read afaik.
so, 64K divided by block size, ceteris paribus
-Original Message-
Sent: Friday, January 18, 2002 2:56 PM
To: Multiple recipients of list ORACLE-L
Where can I find information on this parameter on the Tru64 UNIX platform?
I did a scan of the manuals fo
try
INSERT INTO contactsc (cont_id,cont_contact_surname)
(SELECT seq_cont.nextval,distinct delegated_person
FROM sierras
WHERE delegated_person is not null and
delegated_person <>c.cont_contact_surname)
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EM
Sergey - One factor you may want to consider is the timeframe of your
decision. If it is just a decision for your Lawson box, then that isn't so
critical. It is pretty easy to move Lawson from one system to another.
Last fall we were looking at making a decision for all our systems.
We are
You are not reading the value.
Try this:
select a.INDX NUM, a.KSPPINM NAME, a.KSPPITY TYPE, a.KSPPDESC
DESCRIPTION, b.KSPPSTVL VALUE, b.KSPPSTDF ISDEFAULT
from sys.X_$KSPPI a, sys.X_$KSPPCV b
where a.indx = b.indx and a.ksppinm like '%trig%'
order by 2
-Original Message-
Hi list,
Can any body tell me about magic for oracle?
TIA,
Shreeni
BEGIN:VCARD
VERSION:2.1
N:Kodikal Bhaskar Rao;Shreenivasa;R
FN:Shreenivasa Rao
NICKNAME:Seena
ORG:e-Zing Technologies Inc
TITLE:Oracle DBA
TEL;WORK;VOICE:(212) 233-9861
TEL;HOME;VOICE:(732) 326-1899
TEL;CELL;VOICE:732-670-
whats your blocksize, anything other than 2K has been know to cause all
kinds of problems.
joe
Walter K wrote:
> I'm trying to analyze some archive logs via LogMiner
> and I keep getting the error ORA-03113 (end of file on
> communications channel) when I query the
> V$LOGMNR_CONTENTS view. I
[EMAIL PROTECTED] wrote:
>
> Hi i am trying to insert records into a table by selectiog from table 2, i
> want to insert a sequence,, and the distinct values from table 1 but i get
> an error:
>
> Query used:
> INSERT INTO contacts (cont_id,cont_contact_surname)
> (SELECT seq_cont.nextval,dis
ALTER TABLE ... MOVE
HTH
Tim
-Original Message-
Sent: Friday, January 18, 2002 10:31 AM
To: Multiple recipients of list ORACLE-L
Hey all...I have to do some reorgs of some malformed IOTs (Index-
Organized Tables) in one of my databases. ALTER INDEX ... REBUILD
doesn't work, on the IOT
Sergey,
I asked my SA to add his 2 cents, guess he's not inclined. Anyway, I've
been on HP for the last 10 years, coming from VMS, & I love it. VERY stable,
easy to use, although I don't do the admin any longer it was easy with SAM even
when it was a character based tool. Rman/OmniBack int
Can I do a full export from 7.3.4 and then do a full import into 8.1.7?
Ron Smith
--
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-
IBM
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
"Babich ,
Hi Seema,
In a word NO. From the documentation:
Use the deallocate_unused_clause to explicitly deallocate unused space
at the end of the table, partition or subpartition, overflow data segment,
LOB data segment, or LOB index and makes the space available for other segments
in the tablespace.
Seema,
with alter table deallocate, you can reclaim only the space above the high
water mark in a segment.
The only way the high water mark can be moved downward is to truncate the
segment or drop and recreate the segment.
Sunil Nookala
Dell Computer Corp.
Austin, TX
-Original Message
-- "Babich , Sergey" <[EMAIL PROTECTED]>
> Hi, dear listers,
> My boss has decided to switch production to a UNIX box and now he's asking
> me for a recommendation between HP and SUN. I am a newbee to UNIX (to put
> it the softest way). I've heard people say HP is better, but need more
> than t
Hmmm...the AVG_ROW_LEN is the same for both: 72. The part that sticks out
is the production table has a NUM_FREELIST_BLOCKS of 28569, while test is at
5. Any ideas as to how this could be??? Almost like the TRUNCATE didn't
clear out the freelist??? Or am I missing/misinterpreting something her
Bambi,
Boy you ARE rested!! Yes you can, their in the user profile & they work
darn well if you set 'resource_limit=true' in the init.ora file. The only
problem is that it does not re-submit the query, it just terminates the session.
Saves my bacon more times than I care to add up.
DickG.
exp system/pass@service file=file.dmp log=exp.log user=(adtlite)
The exp.log shows all objects exported correctly.
imp system/pass@service file=file.dmp log=test.log fromuser=system
touser=caler tables=(*)
Rick
Patrice - I was unable to catch my sys admin before he left. I went to
Google and did a search for max_io_size and received several interesting
links. In one document it was referred to as the "operating system's maximum
I/O size". On the Tru64, that is a very large number, so I suspect that you
a
Ross,
IMHO Depends on Your IO subsystem. I am on HP 11.0 and
XP 256 and ORACLE 816 (ALL 64 BIT) and ORACLE gets
data in 1M chunk of data in one IO call while all the
others being the same except storage being AUTORAID we
are getting 256 MB chunks.
Steve Admas has a script and some goodies on this
Title: Need idea to strip tabs (chr(9) hex 9) and carriage return (chr(13) hex 0D) from fields
Hi,
Sometime in the past, data was loaded into tables from spreadsheets and the tabs and form feeds were included in the data. I can locate all the bad data, and am looking for a clear method t
-Original Message-
Sent: Friday, January 18, 2002 1:48 PM
To: '[EMAIL PROTECTED]'
Subject:HP vs SUN for a UNIX box
Hi, dear listers,
My boss has decided to switch production to a UNIX box and now he's asking
me for a recommendation between HP and SUN. I am a newbee to UNI
1 - 100 of 130 matches
Mail list logo