e, it must be observed from the outside. As such, from this observation point, it contains no rows. Thus, the method is irrelevant as the answer will always be 'NONE'.
-Original Message-
From: Whittle Jerome Contr NCI [mailto:[EMAIL PROTECTED]]
If the room is dark, you may need t
Title: RE: Count rows in textfile
If the room is dark, you may need to step on tails and count the YRss you hear. Of course, duplicates could still be a problem.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Mess
Title: RE: Things to do when writing scripts in the Korn Shell
Tell Korny jokes.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
Just some humor to pass the day. Top things you can do while writing
scripts in the Kor
Title: RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..
After a few spy scandals, it has become VERY difficult and time consuming to get a TS security clearance. It might even be cheaper and faster to get someone with a TS and train them to become a DBA. I know of one instance wh
Title: RE: Difference Between DBMS/RDBMS
Alexandre,
CP/M. That brings back fond memories. Just last night I was looking for something in my attic and stumbled upon my first computer - an Amstrad PCW8256. If I remember correctly the 8 was for the Z80 chip and the 256 was the memory in KB. It
Title: RE: Difference Between DBMS/RDBMS
That's nothing. I use to bang the rocks together to make the sand from which the silicon was extracted that was used to create the first memory chips
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
Title: RE: GNU or [G]NU (Pronunciation of...)
I wish I knew since we do have a new problem with gnats on the gnus at our local zoo.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: mkb [SMTP:[EMAIL PROTECTED]]
Title: RE: Unique constraint
Armando,
I certainly would not want the enabling of a unique constraint to delete records even if they are duplicated in a column or two!
Exception helps you identify which records are duplicates so you can then handle the problem as you feel best.
Jerry Wh
Title: RE: Design question.
Chris,
Is there a unique constraint based on the two fields in the parent table? If so it might work OK. Still there are the problems of referential integrity, orphan records, etc. If there isn't a unique constraint in the parent table, you can also add in potent
Title: RE: * Certified Oracle DBAs Needed in the Dallas area..
I have a stable work history! As a teenager I worked at a race track cleaning out stables. Some of those skills and the working environment translated well into being a DBA.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc
Title: RE: So, What is a 'Production DBA'?
Pete,
In that case, Production DBAs are the people getting paid 1.5 times as much as Applications DBAs.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Peter Barn
Title: RE: ora-918
Yechiel,
"MONTH" is a reserved word in PL SQL and you have a field name "month". Could that be the problem?
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Yechiel Adar [SMTP:[EMAIL PROTECTE
Title: RE: ora-918
Yechiel,
"MONTH" is a reserved word in PL SQL and you have a field name "month". Could that be the problem?
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Yechiel Adar [SMTP:[EMAIL PROTECTE
Title: RE: Database backup question.
Paul,
There's a comic strip about office life called Dilbert. PHB stands for Pointy-Hair Boss. You can check it out at the site below. This week the PHB has been demoted back to worker-bee.
http://www.dilbert.com/
Jerry Whittle
ACIFICS DBA
NCI I
Title: RE: How to populate many-to-many
Dennis,
M2M's are ugly but a fact of life. I've done what you have suggested. I suggest that you make the combination of server_id and software_id a unique constraint to keep out dupes.
In Access drop down lists are called combo boxes. You can base t
Title: RE: Do you ever have days where you dont want to think ?
Mike,
WheretheheckisOLN-AFMC? Okie City?
Anyway, it seems to me that the non-unique index on a.f1 is a waste of space as a.f1 is the first field of the primary key index.
Have you tried a hint?
select /*+ index(table1 Table1
Title: RE: Anybody get a 1630 error when trying to add an index ?
Mike,
Does you index creation script have a storage clause? It should look something like below.
CREATE INDEX FLIGHT_LEGS_NDX1 ON
FLIGHT_LEGS(D_ACTUAL_TIME, EVENT_TYPE)
TABLESPACE ASIFNDX PCTFREE 10
STORAGE(
Title: RE: Asinine security workarounds in Oracle, Part III
Paul,
Does that mean some of the films I have at home are sequels with 29 other episodes?
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Paul
Title: RE: Oracle wants your job
You are correct about one thing - some of us will not agree with you especially about centralized information and democracy.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Danism
Title: RE: Oracle Financials Sys Admin. Needed in South Carolina
Robert,
Sounds like a Catch-22. If you take this job, the frequency of your job changes has increased therefore you can't have this job.
They want someone who doesn't change jobs to change jobs.
Jerry Whittle
ACIFICS DBA
Title: RE: Database Metrics
I use these two to show the number of tables created and tables modified by month. In our case, the number of new tables and DDLs has been climbing as the database is getting more complex. On a graph, the lines are climbing upward which is something management can
Title: RE: CPU Pegged at 100%
Raghu,
Do not depend on Performance Monitor alone for your CPU statistics. At least in NT4, it quite often reports 100% usage with nothing going on. Right now on my workstation I have one little Access database open with no activity. Performance Monitor is say
Title: RE: Ms Access user forum
Roland,
Access-L at:
http://www.lsoft.com/scripts/wl.exe?SL1=ACCESS-L&H=PEACH.EASE.LSOFT.COM
Many of the most common questions are answered at the Access-L FAQ.
http://rogersaccesslibrary.com/Access-LFAQ.htm
You can also search the archives at:
http://
Title: RE: Buffer in Import
Ramon,
Bytes. IMHO, 5 is way to low if you have a lot of data to import. Try doubling it at least.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Ramon E. Estevez [SMTP:[EMAIL
Inc.
> [EMAIL PROTECTED]
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
27;EXP_COST_CENTER_D
> IM_IDX1';
>
> COLUMN_NAME
> >
> ACCOUNT_NUMBER
> ORG_LEVEL_1_VALUE
> ORG_LEVEL_2_VALUE
> ORG_LEVEL_3_VALUE
> ORG_LEVEL_4_VALUE
> ORG_LEVEL_5_VALUE
> ORG_LEVEL
Oracle Wants Users to Hand over Apps Management = Oracle Wants Users to Hand over
Money.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
INET: [EMAIL
; more -- and no, I am not replacing Oracle, just "supplementing
> it". I thought I had seen something about this in the FAQs but
> cannot seem to find it.
>
> TIA, Wayne
> [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle
ficial ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
PROTECTED]]
>
> Hallo,
>
> anyone know knows any webpage where I can ask MsAccess questions about error
>messages?
>
> Thanks in advance
>
> Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
INET: [EMAIL PROTECTED]
* from sonusrpt where subject like '%general%';
>
> no rows selected.
>
> Thanks,
> David
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
-4145
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
if you can manage it)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--
> >
> > Either it's the privileges on the tables or
> > the tables do not have primary keys or unique keys.
> >
> > Access will put the table in read only mode if it does not
> > have PK or Unique
> > key.
> >
> > Waleed
>
--
Pleas
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: Whittle Jerome Contr NCI
INET:
ttp://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOV
thread on Oracles pricing scheme I think it is dependent on the
>day of the week, the phase of the moon, the number of salmon spawning in Alaska and
>how many days till X-mas.
>
> Dave
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome
extents_coalesced,round(percent_extents_coalesced,0)
> from dba_free_space_coalesced
> order by tablespace_name
> /
>
> HTH
> Regards
> Rafiq
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
INET: [EMAIL PROTECTED]
Fat Ci
gt; ORA-03232: unable to allocate an extent of 127 blocks from tablespace 3
> How can I know what tablespace is '3'?
> ora816 on nt.
>
> Yechiel Adar, Mehish Computer Services
> [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whi
ets above 20, I coalesce. You may chose a
different number depending on the size of your tablespaces.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
INET: [
1 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 '
;
> >does anyone know what are Microsoft's own inventions?
> >
> they have inventions?
>
>
> --
> --
> Bill "Shrek" Thater ORACLE DBA
> [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.co
website with good Access tips?
>
> Thanks in advance
>
>
> Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
cannot remember his name or URL. (I blame my
> kids for my failing memory).
>
>
> Thanks!
>
> - Jerry
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
INET: [EMAIL PROTECTED]
RACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
gt; INET: [EMAIL PROTECTED]
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lis
s encouraging me to go for it.
> The
> higher ed types seem to be impressed by pieces of paper!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
the fundamentals and then
> more in depth?
>
> Thank you!! I really appreciate your help!!
>
> Please, write to me @
>
> [EMAIL PROTECTED]
>
> thanks!!
> smiles & happy new year 2002
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Autho
101 - 148 of 148 matches
Mail list logo
