Guys,
The paper How to stop defragmenting and start living has
some SAFE rules for extent management in dictionary
managed tablespaces (in oracle 8 and 8i) as below:
--
Segments smaller than 128M should be placed in 128K
Hi Pomin,
This is syntax error, why don't
you check your create database syntax including init.ora file and system
environment variable.
Just my
speculation.
Sinardy
-Original Message-From: pomin
[mailto:[EMAIL PROTECTED]Sent: 19 March 2003 09:49To:
Multiple recipients
Hi All,
Apologies if this question is naive.
How to restrict the size of a BLOB column? I mean the column is defined as
BLOB, and I want data not more than lets say 100KB to be in it, how to
achieve this?
Regards,
Naveen
DISCLAIMER:
This message (including attachment if any) is confidential
Hallo,
I get this errormessage while inserting to this table. How can I check this constraint
problem? Any wrong with the table definition
9.03.2003 09:46:38 Db_Transfil.AVSTEM - ORA-2: db_filtype_ik.AVS
TEM: - ORA-2: db_filtype_ik:OVERFOR_TIL_KUN:
Am Die, 2003-03-18 um 15.58 schrieb Schwerdtfeger, Christoph:
Am Mon, 2003-03-17 um 18.32 schrieb Ray Stell:
On Mon, Mar 17, 2003 at 07:03:43AM -0800, Joe Johnson wrote:
Hi,
This site has a good description of how to use the ipcs and ipcrm commands to
clean up these left-over
Treat dictionary managed tablespaces as being
obsolete. Use LMT's for everything.
On an unrelated note, if you can, go for 9.2 not 9.0,
its streets ahead.
hth
connor
--- Prem Khanna J [EMAIL PROTECTED] wrote: Guys,
The paper How to stop defragmenting and start
living has
some SAFE
Go to LMT asap. Whether you want to use uniform sized extents in LMTs or
system managed (or whatever it's called) is a matter of dispute. My
personal opinion is for uniformed sizing.
Mogens
Prem Khanna J wrote:
Guys,
The paper How to stop defragmenting and start living has
some SAFE rules for
Hello list,
I wanted to know
the concept of Rownum.. Is it similar to Row Id ?
Thanks and Regards,
Santosh
Am Mit, 2003-03-19 um 09.23 schrieb Sinardy Xing:
Hi Pomin,
This is syntax error, why don't you check your create database syntax
including init.ora file and system environment variable.
Just my speculation.
Sinardy
-Original Message-
From: pomin
Commit;
Mogens Nrgaard wrote:
Money, sex and power. No exceptions to my knowledge (read: so far in
my life).
Connor McDonald wrote:
Stepping back into reality briefly:
With great power comes great licensing fees, great
amounts of advertising literature, great
Thanks Mogens.
but any thumb of rule to fix the UNIFORM SIZE in LMTs.
how do u go about fixing the size ?!
Regards,
Jp.
2003/03/19 18:15:52, Mogens N?rgaard [EMAIL PROTECTED] wrote:
Go to LMT asap. Whether you want to use uniform sized extents in LMTs or
system managed (or whatever it's called)
Guys,
CREATE TABLE NAO.MSG (
MEMNO NUMBER(10, 0),
PROFNO NUMBER(10, 0),
NAME VARCHAR2(20),
AGE VARCHAR2(10),
SEX NUMBER(1, 0),
JANLNO NUMBER(5, 0),
SUBJECT VARCHAR2(50),
CONTENT VARCHAR2(500),
DELFLAG NUMBER(1, 0) DEFAULT 0,
POSTDATE DATE DEFAULT SYSDATE,
EXPDATE DATE,
POSTNO
Funny this came up. I had just finished doing research on this for a
potential 9iRAC implemenation.
What I came up with from reading the docs and from experimentation is to
keep the number of extents of each table and each indexes to less than 1024.
1024 seemed to be a majic number. Performance
Hellolist,
I am in a project
where the client wants a data capture program without any validation in any
fields..
the back-end is Oracle 8.1.7. what is the
best way to give the user the data capture program ?
please provide me any solution as soon as
possible.
Thanks and
regards,
just do
select rownum, col1,col2, from
table1
-Message d'origine-De: Santosh Varma
[mailto:[EMAIL PROTECTED]Envoyé: mercredi 19 mars 2003
09:44À: Multiple recipients of list
ORACLE-LObjet: Rownum
Hello list,
I wanted to know
the concept of Rownum.. Is it
Hallo,
anyone who knows how to force a table to use a special tablespace?
Thanks in advance.
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego,
Santosh,
Good question. Actually these 2 are not related.
Rowid is an actual attribute assigned to each row of a table and is unique.
Rownum is logically assigned to rows returned in a query (nothing to do with the
table). It is assigned sequentially as rows are returned (meaning if you can't
Hi All,
do like this example:
CREATE TABLE TABLE_NAME
(COL1 TYPE1,
COL2 TYPE2,
...
)
PCTFREE 10 PCTUSED 40
INITRANS 1 MAXTRANS 255
TABLESPACE TABLE_SPACE_NAME
STORAGE (INITIAL 20K NEXT 372K PCTINCREASE 50
MINEXTENTS 1 MAXEXTENTS 249 );
-Message d'origine-
De :
Hi Roland,
What do you mean by special tablespace?
When a segment is created (table or partition) you can specify a particular tablespace.
Let us know if more information is needed,
Darrell
[EMAIL PROTECTED] 03/19/03 05:53AM
Hallo,
anyone who knows how to force a table to use a special
Title: RE: ERWIN vs Designer
Check out Total Access Analyzer at
http://www.fmsinc.com/Products/access.asp
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: IT - Database (Do Not Use) [SMTP:[EMAIL PROTECTED]
I
no,
rownum is a sequential number whereas rowid
is a pointer to the row of the table within the database.
-Original
Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On
Behalf Of Santosh VarmaSent: Wednesday, March 19, 2003 4:44
AMTo: Multiple recipients of list
Any recommendations on a good UNIX o/s more specifically focusing on tuning scenarios and examples.
Thanks
Menon
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
Prem
(B What do you mean by "fixing" the size? Is it broke? In your earlier
(Bmessage you mention the sizes that Oracle recommends for the extent sizes,
(Bso I assume that isn't what you mean.
(B
(BDennis Williams
(BDBA, 40%OCP, 100% DBA
(BLifetouch, Inc.
(B[EMAIL PROTECTED]
(B
(B
create table table_name column_list tablespace tablespace_name;
babu
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 19, 2003 6:53 AM
Hallo,
anyone who knows how to force a table to use a special tablespace?
Thanks in
Dice had a job somewhere in Ohio yesterday.
--- Kevin Lange [EMAIL PROTECTED] wrote:
I hear the job of Prime Minister in England will
probably be open soon. Any
political ambitions ?
-Original Message-
Sent: Tuesday, March 18, 2003 12:09 PM
To: Multiple recipients of list
Hi All,
Anybody knows what this wait event is casued by??
TIA
Jacob A. van Zanen
Oracle DBA
Quant Systems Europe b.v.
Tel : +31 (0) 251 - 268 268
Mobile: +31 (0) 6 51308813
Fax: +31 (0) 251 - 268 269
E-mail: mailto:[EMAIL PROTECTED]
Visit our web site at http://www.quantsystems.nl/
--
There was an issue in 9.0.1.0 with BLOB and ASSM feature. It was rectified in 9.0.1.2.
Are you sure the Oracle version is *exactly* the same? And that the machine B, is not
missing any Oracle patches applied to machine A?
- Kirti
-Original Message-
Sent: Wednesday, March 19, 2003
Darrell Landrum,ÄúºÃ£¡
thanx for your explaination.
I wonder :whether i can judge the select return.
I find the rowNUM is not 0, is right?
=== 2003-03-19 05:03:00 ÄúÔÚÀ´ÐÅÖÐдµÀ£º===
Santosh,
Good question. Actually these 2 are not related.
Rowid is an actual attribute
[/begin rant]
We ran into a bit of a puzzle here.
It started innocently enough, with someone asking whether Oracle tablespaces
that are largely empty are really being compressed before they are written
to tape.
We use Veritas Enterprise NetBackup with a StorageTek tape silo. Our
backups are
Roland,
Don't know if I understand you correctly, my english is not good, but
what if you specify the tbs to use at the moment of the creation of the
table
CREATE TABLE mitabla
( CODE NUMBER(4))
TABLESPACE mitbs
Suerte
Ramon
-Original Message-
[EMAIL PROTECTED]
Sent:
Jack
I did a quick search on Google and this seems to be related to using RAC.
Do you have that implemented?
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, March 19, 2003 8:14 AM
To: Multiple recipients of list ORACLE-L
Should not be a problem:
sqlldr control=your_ctl_file data=your_data_file
userid=login/pwd@remote_machine
where remote_machine is an entry in your local/client tnsnames file.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
You are trying to insert a row that contains values that already exist in
the table, and there is a constraint on the table that says the values for
the row(s) must be unique.
Now about that column BONGID ... What are you smoking?
-Original Message-
Hallo,
I get this
Menon
Do you mean tuning Unix itself or Oracle on Unix? Which Unix?
The only book for tuning Oracle on Unix that I am aware of is Oracle and
Unix Performance Tuning by Ahmed Alomari. I have difficulty reading it, but
others on the list whom I respect have recommended it highly.
Dennis
Santosh,
As one who has written a pile of these, you've left out a lot of details.
The first question I would have is where is the data coming from and how is it
being written. If the data is flat ASCII text, and is from a batch process
SQL*Loader or an external table (9i V2) would be
No. It is not similar to a rowid.
It is just a pseudo sequential number assigned to the rows in the result set (after
the result set is prepared) from the query.
- Kirti
-Original Message-
Sent: Wednesday, March 19, 2003 3:44 AM
To: Multiple recipients of list ORACLE-L
Hello list,
create table tbl_name (col data_type) tablespace tablespace_name ;
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2003 6:54 AM
To: Multiple recipients of list ORACLE-L
Hallo,
anyone who knows how to force a table to use a special tablespace?
Thanks in advance.
We have met just your requirement using Visio Professional. Easy, minimal
learning curve. But it is not a case tool. In passing, we also use the
Oracle tool for design work. And it is a significant learning curve.
peter
edinburgh
-Original Message-
From: IT - Database (Do Not Use)
Title: Gather_system_stats
Hi everyone
I was trying to migrate one of our applications to 9.2 and put in cost at the same time
I came across Gather_system_stats and was wondering if anyone had used it?
Did it improve the executions plan choice at all?
Thanks
David Hill
DBA
sqlldr username/[EMAIL PROTECTED] control=controlfilename
I do it all the time
sqlnet works for all Oracle utilities (sqlldr, exp, imp)
--- [EMAIL PROTECTED] wrote:
Hi All,
The 'create table foobar (foo number) tablespace special_tablespace;' syntax would do
it.
Check the SQL Reference Guide for more info.
- Kirti
-Original Message-
Sent: Wednesday, March 19, 2003 5:54 AM
To: Multiple recipients of list ORACLE-L
Hallo,
anyone who knows how to force a
Can you tell us a bit more about this requirement?
Does this data need to be loaded into the database?
Or captured from (as in extracted) from the database?
- Kirti
-Original Message-
Sent: Wednesday, March 19, 2003 5:54 AM
To: Multiple recipients of list ORACLE-L
Hello list,
That's correct, there's no rownum of 0.
ex.
SQL select rownum, username from dba_users;
ROWNUM USERNAME
-- --
1 SYS
2 SYSTEM
3 OUTLN
4 OEM_DLAND
5 DBSNMP
6 HR
7 PM
8 DLANDRUM
9
In my hot backup script, should I be using alter system archive log
current;
instead of alter system switch logfile;?
At present this is what I am doing:
For each tablespace:
sqlplus internal EOF
alter tablespace ERGO_USR begin backup;
exit
EOF
#
cp $DIR3/ERGO_USR.dbf $BACKUP_DIR$DIR3
#
1. Has anyone ever used Ab Initio? Is it some kind of data conversion tool?
What is the the learning curve on it? Is there online documentation and do they
have a freeware version to download? I want to learn it. Dont want to use it
for development.
2. What is a good Unix scripting book for
Sure, you can do it.
Just use Oracle Net8 connect string to connect to the remote database when specifying
userid for sqlldr.
- Kirti
-Original Message-
Sent: Wednesday, March 19, 2003 7:24 AM
To: Multiple recipients of list ORACLE-L
Hi All,
I've used Designer but never used Erwin.
Designer has a medium to big learning curve.
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 925-7187
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
An instance lock that protects a buffer is being downgraded or upgrade,
while that is in process the buffer can't be accessed so sessions have to
wait on this event.
Anjo.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 19, 2003
Rick, am i missing something in the picture here??, why not use
sqlloader(you'll need it on your local PC) and send it across sql*net?
joe
Hi All,
Patrice
Just be sure and do a test restore to make sure Veritas restores the file
identically to the original :-0
There have been problems where systems see unused space in Oracle data
files and eliminate it to save you some space. Oracle doesn't see the humor
;-)
Dennis Williams
DBA,
This message is telling you that your insert violates the
primary key constraint for the table. This means that the
primary key, KUNHOD_TMP1_ID, value in your inserted record already
exists in the table.
HTH,
Peter Schauss
-Original Message-
Sent: Wednesday, March 19, 2003 4:16 AM
To:
Rick
You sure can -- as long as you can establish SQL*Net connection to the
instance on the remote machine. All you have to do is specify
[EMAIL PROTECTED] either on the command line or in your parameter
file.
If the OSs are exectly the same, you can even use direct path inserts
Kevin
Hello Peter,
If you are going to backup the archive logs, I would recommend '.. archive
log current;' because it ensures that the current logfile gets archived
first before you do the backup. The problem with the other command is it
will switch but Oracle may not archive the file immediately.
Title: RE: How to calculate the working hours?
What about holydays?
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Jacques Kilchoer
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, March 18, 2003 9:53
PM
Subject: RE: How to calculate
Rick,
Assuming sqlldr is installed on your client machine, you should
be able to run it locally.
HTH,
Peter Schauss
-Original Message-
Sent: Wednesday, March 19, 2003 8:24 AM
To: Multiple recipients of list ORACLE-L
Hi All,
A switch logfile isn't mandatory and an archive log current is highly
recommended.
The switch logfile command would return immdiately and would not
wait for the archiver to complete archiving the log. The archive log current
would return only after the archiver has completed it's job.
You must
Darrell,
Pretty damn close. Rowid is the actual absolute address of a row in the
database. It use to come in the format of .. up to version 8.0
which was decoded as the file number, block number, and row address within the
block. At version 8.0 it took on the format we see
David
Are you using RULE alone on your current system? Probably some of your
queries will run faster and some will run slower if you switch to CBO. Guess
which ones your users will complain about? My suggestion to avoid a riot at
your cubicle is to try to identify the queries that will need
Title: RE: Job Needed
Scouting report:
I don't know about any jobs but I do know that whoever hires this Kevin guy will have wisely scored a major talent acquisition... a real 1st round draft pick!
-Original Message-
From: Kevin Toepke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
We're running web applications, forms, and reports on a a 9iAS server
and we're looking at two big projects over the next year, so I'm
planning to sign up for a training class or two. Has anyone attended
any good 9iAS configuration and management courses?
Thanks!
Glenn Stauffer
--
Please
1. It's an ETL tool like Informatica. Heard it's much better than
Informatica. You need to check their website for further information.
3. You just deal with a lot of data at one time and so keep in mind to
optimize your code so that the end-to-end processing time is less.
HTH
Prakash
See Note 181272.1 on MetaLink.
The Multiblock I/O never spans Extent Boundaries even if the Extents
are continuous and also if using Locally Managed Tablespaces.
Hemant
At 07:44 AM 17-03-03 -0800, you wrote:
How can you tell that DB_FILE_MULTIBLOCK_READ will not span extents?
I was unable to
Roland,
If the table is already established and you want the next extents to
be in a different datafile then you can force that situation. Onca a
table was been created in a perticular tablespace I don't know of a way
to split the table across multiple tablespaces other that partitioning.
To
I wonder if you could run a backup, then start dd-ing stuff off the tape
until you run out of stuff to dd. The problem is, this is an after-the-fact
count. For what it's worth Legato Networker (which I'm not particularly
fond of) reports the bytes it has written to a tape.
--
Please see the
-Original Message-
2. What is a good Unix scripting book for Oracle Developers?
There is more than one good scripting language for Unix. I suspect others
with chime in with Perl, Python, etc.; so I'll throw in some comments on
Korn shell programming. If you want a good book for ksh
Title: What happened ... no email?
Hey ... anyone out there ??
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!
Your issue really relates to Thin JDBC and IPC. I'm not sure that Thin
JDBC can use IPC.
See Note 70154.1 on MetaLink.
The JDBC Thin driver connects to any Oracle database of version 7.2 and
higher, although at the time of this writing the lowest level of Oracle
server
supported is 8.1.7.
RG
1. I don't recognize Ab Initio.
2. For Unix scripting, there are several alternatives. You should first
decide what you should learn (this list can help), before you spend a lot of
time learning it. For example, I wasted a lot of time learning csh only to
find it isn't a very good
At 01:53 AM 3/19/2003, Naveen Nahata wrote:
Hi All,
Apologies if this question is naive.
How to restrict the size of a BLOB column? I mean the column is defined as
BLOB, and I want data not more than lets say 100KB to be in it, how to
achieve this?
I believe you should be able to put a check
Foote Partners surveys the value of certifications. They support that over
the past two years, the OCP pay premium increased by nearly 40%. In the same
period, the value of Microsoft MCP declined by nearly 60%.
A good article on the value of certifications.
Perhaps the most telling statement about the state of the economy today.
Job, singular. On DICE.
~brian
-Original Message-
Sent: Wednesday, March 19, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L
Dice had a job somewhere in Ohio yesterday.
--- Kevin Lange [EMAIL PROTECTED]
been to their website and cant find the free download. Any idea what the learning
curve is on Ab Initio? I constantly try to improve my skills and Im trying to decide
whether this is worth the time at the moment.
From: BALA,PRAKASH (HP-USA,ex1) [EMAIL PROTECTED]
Date: 2003/03/19 Wed PM
Title: RE: How to calculate the working hours?
(re-sending because my e-mail from yesterday never made it to the list)
see answer below
-Original Message-
From: Andrea Oracle [mailto:[EMAIL PROTECTED]]
We have open Time for every order, ef:
Open Time
--
--MS_Mac_OE_3130916029_1658585_MIME_Part
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7bit
Well
...I know most folks in Denver aren't at work today. We've got four feet of
snow and still coming down. I'm stuck in Salt Lake City, missing the best
blizzard in a
I use switch logfile exclusively within my hot backups (because at the time
I wrote the scripts I was unaware of the difference) but also check V$LOG to
make sure the archive write is complete before proceeding with the backup.
I has worked fine on my 8.x production database for the last 4+ years
Title: Re: Gather_system_stats
DO understand the implications of gathering system statistics. Once you
have system statistics, the cbo adds a cpu cost element to the plan costs.
In my experience it is largely marginal, especially if you have fast cpus.
The bulk cost is still coming from
ROWNUM is the order in which a row is returned to the result set after
all predicates (WHERE clause) are applied. It can be affected by
implicit sorts (i.e. DISTINCT) and access paths (i.e. INDEX v. TABLE).
An ORDER BY will preserve the rownum, but will not display it in
sequential order.
Dang, I gotta get a copy of that report to my manager! After going
through the 7.3, 8, 8i and 9i OCP AND the OCM, I don't think any of them
got me a pay increase! ;)
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not. It's much harder than that!
delete from oracle-l where subscriber = 'Gene Sais';
commit;
select count(*) from oracle-l
where subscriber = 'Gene Sais';
COUNT(*)
--
0
--
Daniel W. Fink
http://www.optimaldba.com
IOUG-A Live! April 27 - May 1, 2003 Orlando, FL
Sunday, April 27 8:30am - 4:30pm - Problem
If you have worked on any other ETL tools, picking this one up should be
relatively easy.
-Original Message-
Sent: Wednesday, March 19, 2003 12:50
To: Multiple recipients of list ORACLE-L
been to their website and cant find the free download. Any idea what the
learning curve is on Ab
Title: What happened ... no email?
Yup! Ruth
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, March 19, 2003 11:49
AM
Subject: What happened ... no
email?
Hey ... anyone out there ??
Raj
a small technical mistake :-)
delete from
"oracle-l" where subscriber = 'Gene Sais';
^
"-" is not
allowed in identifiers ;-)
Regards
Naveen
-Original Message-From: Daniel W. Fink
[mailto:[EMAIL PROTECTED]Sent: Wednesday, March 19, 2003 11:57
PMTo: Multiple recipients of
Know what... OCP didn't get me one, either... but Mine is just ocp and just
8 and 8i (9i in a few weeks)
ajw
-Original Message-
Sent: Wednesday, March 19, 2003 12:36 PM
To: Multiple recipients of list ORACLE-L
Dang, I gotta get a copy of that report to my manager! After going
Same with me for 7.3 to 9i OCP , no increment even no reimbursement of test
fees either.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 19 Mar 2003 10:35:32 -0800
Dang, I gotta get a copy of that report to my manager!
Depends on the orginazation.
Some organizations are rigid seniority based traditionaly managed
where it does not matter if you have a PhD or not. If you've been with
the company 10 years, then you get a raise and get to do neat things.
--
Lyndon Tiu
Quoting Pete Sharman [EMAIL PROTECTED]:
This can also happen during creating a consisten version of the
block with cache fusion enabled.
-Original Message-
Sent: Wednesday, March 19, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L
An instance lock that protects a buffer is being downgraded or upgrade,
while that is in
RG
This tool will only be worth it if your prospective employer purchased
this particular tool. Another approach is to find what most DW sites use
again and again. Like ksh. Like SQL*Loader. You could even write some useful
utilities and scripts to impress a prospective employer. Like a ksh
Certifications are good for self marketing just like a degree from a
prestigious school. Does a certification mean
anything? It means the person took time to study and pass a test. It shows
a little dedication. A certification by itself means the individual
is competent enough for an entry level
Hi,
I am wondering if there is any way to achieve horizontal partitioning in Oracle.
Assuming that I have about 8 partitions for a table.When there is INSERT onto this
table I want one record
to be inserted into each partition i.e
1st record goes into partition 1
2nd record goes into
I already know that stuff. Im seeing AB Initio posted on the job sites. Sometimes you
gotta pick up the buzzwords enough to talk about them.
I would assume its not that big of a deal though. Market is just really tight. I only
have 3.5 years experience and Im competing aganst guys with 10
Ive noticed that in consulting these things matter more. Makes it easier to sell you.
Ive been on projects where people have said so and so has an OCP so they know what
they are doing.
Ive also seen some jobs that require OCPs. Not tons, but a few.
From: Lyndon Tiu [EMAIL PROTECTED]
I don't think that getting OCP certification is any guarantee of a pay
raise unless it is in the initial requirements for the particular job or
in the yearly review requirements.
I hold my OCP certifications for my own satisfaction and well being
not for the advantage of my employer. It is some
read about hash partitioning
-Original Message-
Sent: Wednesday, March 19, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L
Hi,
I am wondering if there is any way to achieve horizontal partitioning in
Oracle.
Assuming that I have about 8 partitions for a table.When there is
I'm not sure what your trying to accomplish. You get one insert for one
record. Which partition is used depends on how you set them up. If your
wanting the partitions to be used in a circular fashion I believe that is
accomplished with a hash partition and you get to create the hashing method.
Title: RE: partitioning
You could accomplish this with a before insert trigger and a partitioning column that contains the value 0 through 7.
e.g.
create trigger
before insert
for each row
begin
select mod (sequence.nextval, 8) into :new.partition_column
from dual ;
end ;
/
Something
Because the instance locks are now called Global Cache Services .. ;-)
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 19, 2003 7:59 PM
This can also happen during creating a consisten version of the
block with cache fusion
At what point do you insert the sleep command and how many seconds
do you specify?
Why exclude the last archive log?
Thanks,
Peter Schauss
Northrop Grumman Corporation
-Original Message-
Sent: Wednesday, March 19, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L
A switch
1 - 100 of 142 matches
Mail list logo