Good point but no. I'm the only one who can get into this server, the last
time I ran anything like this was when I built it in September. H, I
just checked the test environment, which is a clone, everything there is
owned by sys.
Thanks!
Linda
-Original Message-
Sent: Wednesday
With RSX and KED? May be some good, old VT100 and VT220? Oh, that makes me
nostalgic!
> -Original Message-
> From: April Wells [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 02, 2001 3:35 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: OT -- suggestions to ensure nerdin
I use RMAN to do incremental backups every day. It works great!
Have a little faith,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, August 02, 2001 12:11 PM
Lisa - I don't think there is enough beer for me to trust RMAN to do
in
Title: RE: OT -- suggestions to ensure nerdiness in potential IT staff
Thanks, Ivan.
Most
of us are probably from some 'hood. Mine was the barrio of East L.A. as a
first generation Mexican-American.
The
great equalizers are self-education, self-esteem and
self-motivation.
When
you are famo
hi;
error: ORA-06553 : PLS-213 : package STANDARD not accessible.
I believe that you must connect as sys to do
SELECT * FROM DBA_OBJECTS WHERE OWNER = 'SYS' AND
OBJECT_NAME = 'STANDARD';
If you to find the status is "INVALID" and I believe that you try to
recompile it by use command
ALTER PACK
and the incremental/cmulative options in export are only there
for backwards compatibility w/scripts, my understanding is they are not really
supported anymore.
joe
>>> [EMAIL PROTECTED] 08/02/01 10:30AM
>>>if you are running 8i, you can use a where clause on the
export.incremental expor
Matt, 8i admin guide, search for transport, in that chapter is limitations,
they are all listed there.
joe
>>> [EMAIL PROTECTED] 08/02/01 09:21AM
>>>
Rachel, Which doc did you find that in?
Matt
Matt Adams - GE Appliances -
[EMAIL PROTECTED] Doing linear scans over an
associativ
STANDARD was not invalid (there were only two things invalid, both
'acceptable'). When I tried to compile STANDARD (actually I recreated it
altogether) it wored without errors but I still got the error when logging
into SQL*Plus. This whole thing was just really odd!
Linda
-Original Messag
Toppa result
Only Villa to beat and we are in Europe..
-Original Message-
Sent: 02 August 2001 13:52
To: Multiple recipients of list ORACLE-L
Wahey,
Good result last night.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: 02 August 2001 11:50
To: Multiple recipi
Sorry I just have rpt/rpf (joking !)
--- [EMAIL PROTECTED] a écrit : > A client of mine
is moving off some ancient hardware
> (with ancient
> software) and needs for the short term to run
> SQL*Reportwriter 1.0
> for DOS, then convert those files to version 1.1 of
> the same. If
> anybody is
if you are running 8i, you can use a where clause on the export.
incremental export does not export only the changed rows but will export the
entire table if even as little as one byte in one row has changed.
>From: "Tatireddy, Shrinivas (MED, Keane)" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROT
You have to do them individually, but you can use SQL to write the script,
as follows (use SQL*Plus to log in to Oracle as the schema owner):
set pages 0 feedb off trimspool on lines 200 wrap off
select 'grant update on '||table_name||' to ;' from user_tables
spool grantem.sql
/
spool off
@grant
Privileges have to be granted one object at a time.
My preferred method is to grant the privileges to a role and then grant the role to
the user. Then if you need to do the same to another user, you just grant them the
role also.
> -Original Message-
> From: O'Neill, Sean [mailto:[EM
In 1981 my oldest child was 2 and I was working on a very primitive RDBMS
at Boeing.
As a pre-teen I was making a crystal radio and wondering why anyone would
pay for batteries or electricity to power the radio when you could get all
the energy that you needed from the broadcast itself.
As a sum
"What does APL stand for? What was very bad practice in APL that other
languages use? What was used instead?"
A Programming Language. Not sure of the other questions, but I remember
learning the greek alphabet when I was using APL. Very powerful
vector-oriented language. You could write one-li
Has anyone worked on IBM's punch card sorter? And IBM-1401 Mainframe? Talk
about un-breakable stuff. The 1401 cabinet had tumbled down 10 steps during
its move to the new computer room (we did not have lifts/elevators in the
building then). But came to life without any problems when it was hooked
I thik LOGO was based on LISP.
Steve Parker
Technical Consultant
LIS
--
Logistics & Internet Systems Ltd.
--
we called that 52 card pickup -- take deck, throw in air, run like the devil
was after us.
I learned EARLY to draw intricate designs on the top of the deck so as to
make putting it back together simpler.
When projects were due, I'd cut every class but the computer ones, and stay
in the comput
Wahey,
Good result last night.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: 02 August 2001 11:50
To: Multiple recipients of list ORACLE-L
The Geordies get everywhere
Aa The Blaydon races..
-Original Message-
Sent: 02 August 2001 08:00
To: Multiple re
Hi all,
Does anyone know the URL for the Oracle 9i Beta program. I need to
download the NT version of 9i.
Thanks in advance:)
Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin K
And the question (still yet to be properly answered) is "How many licks does it take
to get to the center of a Tootsie Pop?"
> I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Page, Bruce
INET: [E
And just think about the PC being an advanced system for some of us.
Wait until we again start talking about using paper tapes and having to use scotch
tape to put them back together to run them through. Or even the older guys that talk
about switch boards. I am not as old as them. My comput
Hope there is not an obvious answer to this. I want to grant UPDATE priv
to all objects in a schema to a user. Do I need to grant to each object or
can I somehow wildcard all the objects?. What are my option(s)?. I'd
appreciate example grant statements!
Sean :)
Rookie Data Base Administr
On Thu, 2 Aug 2001,Boivin, Patrice J scribbled on the wall in glitter crayon:
->Was CP/M the OS that Bill Gates bought just before making his big deal with
->IBM? Can't remember.
->
->Regards,
->Patrice Boivin
->Systems Analyst (Oracle Certified DBA)
->
-> -Original Message-
->
Mark,
The closest guestimate on the price is found at the Oracle Store. I do not know if
they updated it with the pricing schema talked about on the OTN home page. Call your
rep and get a price quote, wait a week and call again. The price might go down.
ROR mª¿ªm
>>> [EMAIL PROTECTED] 08/01/01
Then when the sun REALLY comes up, the ice (a plant version of a heavy
jacket) melts and keeps the cells from bursting. Added feature... the whole
field sparkles in the sunrise!
-Original Message-
Sent: Wednesday, August 01, 2001 5:44 PM
To: Multiple recipients of list ORACLE-L
On Wed,
>
> On Thu, 2 Aug 2001,Boivin, Patrice J scribbled on the wall in glitter crayon:
>
> ->Was CP/M the OS that Bill Gates bought just before making his big deal with
> ->IBM? Can't remember.
> ->
> ->Regards,
> ->Patrice Boivin
> ->Systems Analyst (Oracle Certified DBA)
> ->
> ->-Origina
A client of mine is moving off some ancient hardware (with ancient
software) and needs for the short term to run SQL*Reportwriter 1.0
for DOS, then convert those files to version 1.1 of the same. If
anybody is an antique collector and still has either the install disks
or runtime of these prog
On Wed, 1 Aug 2001,Pat Hildebrand scribbled on the wall in glitter crayon:
->When I saw the question about boot disks I figured that the answer
->would be very dependent on the computer because I know there were
->computers at that time that didn't use disks. However, the computer
->that I got in
exp help=y
look for query=
joe
"Tatireddy, Shrinivas (MED, Keane)" wrote:
>
> Hi dba's
>
> can anybody tell me how to do export part of the table..
>
> i.e. incremental data.
>
> when i exported at 10 am it has 1000 rows ( i did full exp)
>
> 100 rows newly added in the 2 hrs
>
> when i do
Hi,
that's correct. The rule of thumb is that RAID5 is usually the "Sys
Admin's choice" whereas the "DBA's choice" is more like
1-controller-per-disk-per-datafile ;)
James Howerton schrieb:
>
> I lost the battle. We have Hitachi raid 5 hooked-up to a Sun E10K and write
>performance does "SUCK"
Title: RE: transportable tablespaces
Rachel,
Which doc did you find that in?
Matt
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is like
trying to club someone to death with a loaded Uzi.
- Larry Wall (creator of Per
And they don't weigh you on the way in and the way out?
=)
-Original Message-
Sent: Thursday, August 02, 2001 5:21 AM
To: Multiple recipients of list ORACLE-L
Where I live we have many strawberry farms where the customer picks their
own berries. We picked about 50 pounds and then I mad
Shahid ,
set autotrace on, run your query, view the explain plan. It should show you exactly
what is happening with the query in question.
Make sure that you follow all of the requirements to use the command( Plan Table,
Ultxplan.sql.etc}
ROR mª¿ªm
>>> [EMAIL PROTECTED] 08/02/01 01:30AM >>>
Hi
>> From: [EMAIL PROTECTED]
>> Date: Wed, 1 Aug 2001 12:01:40 -0400
>> Subject: Help, processes won't die
>>
>>I need some assistance ASAP. Our nightly batch process seems to have hung
>>up for some strange reason (ok no biggie my boss says kill it and start it
>>again). The problem is I have ki
Tucked away in my safe I have 6 tapes for the Atari. Each tape is a different game and
you had to use a tape player to load them rather than the plugin cartridge. I tried
one of the games and the visuals were great. The tape version had more info than was
on the chip.
As far as the answers to t
yup thanks for this, I found this late last night aswell..: ) !!!
Good old oracle bugs, Life wouldn't be as exciting without them!!!
-Original Message-
Sent: 01 August 2001 19:32
To: Multiple recipients of list ORACLE-L
I found this on MetaLink which describes exactly what you are getti
I love this stuff(being a nerd wannabe), but I don't have a frickin clue
what any of you are talking about:)
KK
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-505
Was CP/M the OS that Bill Gates bought just before making his big deal with
IBM? Can't remember.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
CP/M [or is it CPM i've seen it written both ways.]
--
Please see the official ORA
The Geordies get everywhere
Aa The Blaydon races..
-Original Message-
Sent: 02 August 2001 08:00
To: Multiple recipients of list ORACLE-L
I guess thats one of the things we have going for us in little old England.
Where I live in the North East of England (Northumberlan
Title: Help Need
Are
all the columns in user repeated? I doubt it because you would just remove
duplicate records. I am assuming userid is key field.
You
could try
CREATE
TABLE usercheck AS SELECT * FROM user;
ALTER
TABLE usercheck ADD(repeated NUMBER);
UPDATE
usercheck a
SET
repeated
its called explain plan, tuning guide.
joe
"Shahid Malik(IT)" wrote:
>
> Hi friends,
> How can I find that, is my query using index or not?
>
> TIA
> Shahid .
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Shahid Malik(IT)
> INET:
Dear All,
I have some queries. How can we store non-English characters in Oracle database? e.g.)
Simplified Chinese.
I created a Oracle database with character set JA16SJIS. But it is allowing me to
enter only english and european languages.
Pl clarify.
Thanks in Advance
Regards
Venkata sub
In Larry Ellison's bio, it's explained that the name "Oracle" came from
a data storage system they were working on for the govt. It was based on
magnetic mylar strips or something. They took the name with them when
they struck out on their own. Their govt. connection got them bumped up
the waiting
>> From: "Boivin, Patrice J" <[EMAIL PROTECTED]>
>> Date: Wed, 01 Aug 2001 07:38:51 -0300
>> Subject: cleaning up oracle homes on NT
>>
>>Andrea asked about removing NT services.
>>
>>What about Oracle homes? The Oracle Universal Installer appears to be
>>doing a poor job of cleaning those up wh
Hi,
This statement will get you the userid and the number of times it is
duplicated. Then it's just a case of inserting the value at the desired
location. Although this does mean that you are either going to have a column
with lots of null values or lots of repeated values...Doesn't really make
that settles it, I'm quietly packing up my desk and leaving the list. I
don't belong here. I vaguely remember working with some of this stuff but
not all.
I either:
1)never had a memory for anything
2)was sleepwalking through most of my life
3)am not and was not a nerd
4)all of the above
I th
Title: Help Need
Hi DBA Gurus,
I have a table called user..
It has userid, firstname, lastname, city, address, telephone, email
There are some userid which have been reentered .. I would like to insert a column called repeats and take the number of times the userid is repeated
How to I
Hi dba's
can anybody tell me how to do export part of the table..
i.e. incremental data.
when i exported at 10 am it has 1000 rows ( i did full exp)
100 rows newly added in the 2 hrs
when i do exported at 12 am ( incremental) it exporting all the
rows(1100) of the table
but i need only the r
This is also by far the easiest way I have found of doing this. There are a
couple of things to bear in mind here though:
1) If you have two "large" data fields in the same table in SS, the
transformation sometimes tries to create the Oracle tables with multiple
LONG data types - which can't be d
-Original Message-
> What famous character was used to first advertise the IBM PC?
Charlie Chaplin, easy one.
correct.
> Was it possible to connect two screens to the original IBM PC?
How?
I believe I did one through a Hercules graphics card, but
I think, you can design an application that aware of those non rollback tech
things and reverse the contain back properly, quite a lot of work need to be
done here.
regards,
Sinardy
-Original Message-
Sent: Thursday, 2 August 2001 2:56 AM
To: Multiple recipients of list ORACLE-L
True,
hth=hope that helps.
joe
--
Joe Testa
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
INET: [EMAIL PROTECTED]
Fat
I'm using ksh. From the Unix prompt I do history which displays the last
170 commands I did.
I would like to re-run #55 in the list (which happens to be a rm with a lot
of arguments). How do I do it?
I tried doing ESC-K then /rm to find it but it didn't. Usually it does.
Thanks,
Ross
--
Hi Gurus,
I would like to get your recommendation for connection restriction to the
databases via tcp/ip based on ip addresses. The restriction is required
for only the databases that is served by one listener, not the other.
Any suggestions are welcome: OS, Oracle, network...
Sun Solaris 2.7
> select table_name from dba_tables where table_name like 'EDL_WORK_%'
> and I received the following
>
> TABLE_NAME
> -
> EDL_WORKSTATION_LOCATION
> EDL_WORK_AR_ENTITIES
>
> Why would I be receiving the first record (EDL_WORKSTATION) if I
> try EDL_WORK_A% I get the co
101 - 156 of 156 matches
Mail list logo