Funny story from earlier this week. I've been pestered by a recruiter making
cold calls who is trying to get me to hire an Oracle Developer. I told her
we had a hiring freeze, but she claimed he walked on water, and we couldn't
pass him up. I asked her to fax a resume and told her I would look at
I was just so curious how this whole disaster started?
-Original Message-
Waleed
Sent: Friday, May 18, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L
I hope the original poster found the answer for his question.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
I thought the freedom to wear clown pants was the supreme freedom.
Dan Momentarily really irked at Ross but I got over it
-Original Message-
Sent: Friday, May 18, 2001 3:17 PM
To: Multiple recipients of list ORACLE-L
... and hide good 'cause we're gonna getcha.
What's going on here?
That sounds great! So far it's me, you, and Kevin. I think the three of
us can take the island. I drive a Land Rover, so I'll bring it. Once we
have raised our flag at HQ and have all the locals assimilated, we can send
for our families. I like the idea of naming the natives with
Linda,
you should be using dbms_sql instead, which incidentally is *very* stable.
What feature of dbms_sys_sql you need but isn't provided by dbms_sql? I am
just curious ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot
Title: RedHat and Oracle
Funny
how this is going since Oracle invested in Red Hat a few years
ago.
Remember
-http://news.cnet.com/news/0,1,0-1003-200-339689,00.html
-Original Message-From: Marianne Brooks
[mailto:[EMAIL PROTECTED]]Sent: Friday, May 18,
2001 10:21 AMTo:
Alter tablespace move...
-Original Message-
Sent: Friday, May 18, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L
Hello All,
I just inherited an Oracle database which runs Lawson
CRM application. The database is extremely slow
because there is high insert/delete activity in the
Hello Loren,
Which version of Oracle is this Lawson beast running on? If its 8.x, I
wouldn't be overly concerned with amount of extents (unless 1000), as much
as I would be with indexes. See if they are being rebuilt on regular basis,
and if not - its a great place to start. Of course, knowing
I am not sure, but I think originally he didn't mean that I, Kevin, was the
criminal. I think he met that people in his country would be considered
criminals for having a concealed weapon, just like they pretty much would
here in the good'ol US of A. No harm No foul, it's all just opinions ,
Oh wow what a terrible spelling mistakeoh well
-Original Message-
Kostyszyn
Sent: Friday, May 18, 2001 4:31 PM
To: Multiple recipients of list ORACLE-L
I am not sure, but I think originally he didn't mean that I, Kevin, was the
criminal. I think he met that people in his country
I love it ..I drive a Land Rover, so I'll bring it.
All right, but I still get to drive the hum-vee, you boys are in charge of
all of the important stuff since you are smarter and wittier than me. I'll
be in charge of patrolling for locals trying to make off with more than
their share of the
hahahah
I wanna drive a hum-vee, first dibs!
-Original Message-
Sent: Friday, May 18, 2001 3:11 PM
To: Multiple recipients of list ORACLE-L
LoL!! I like the idea of airlifting in our Urban
Assault Vehicles. We can establish a beachhead at 0600.
Recon should take the better part of
Yep, i did!
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, May 18, 2001 3:15 PM
Did you run catproc? Just a thotrbg
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 17,
I have used it to write an installer for database objects (used dbms_sys_sql
to add the proper grants to another user's objects). Worked without issue.
The parameters were all the same except the added parameter on
parse_as_user.
Just be careful about who you grant access to the package. Any
Sam,
Yes it is there. I didn't work much on the configurations , but I used to
access a Progress database
through Gateway in my prevoius assignment.
Thanks
Suren
Oracle DBA
Sony Electronics Ltd.
-Original Message-
Sent: Thursday, May 17, 2001 1:56 PM
To: Multiple recipients of list
Ah, good point. Thank you!
Linda
-Original Message-
Sent: Friday, May 18, 2001 2:37 PM
To: Multiple recipients of list ORACLE-L
I have used it to write an installer for database objects (used dbms_sys_sql
to add the proper grants to another user's objects). Worked without issue.
The
I imagine you'll be drilling for Oil in your Island refuge national
park so you can drive your Hum-vee and Land Rover around without a
care.
:)
- Brian
--- Kevin Kostyszyn [EMAIL PROTECTED] wrote:
I love it ..I drive a Land Rover, so I'll bring it.
All right, but I still get to drive the
Hi, Gurus,
One of my colleagues killed ora_pmon and other background processes. If we log
into svrmgrl, then the messge connect to idle instance show up. We are trying
to bring the instance back online. How should we do it? This is a test
database, and we have two instances on this HP
I am working on scripts that will create tables and users, grant
permissions, etc. every night on a clean copy of our db. Without
dbms_sys_sql, I would have to connect to other users to do the grants. I
don't want passwords anywhere in my scripts, I want to connect once then run
everything from
Title: RE: Hi need some please
Is what your trying to do as simple as?...
delete from TAB_B B
where exists (select 'x'
from TAB_A A
where A.col1 = B.col1
and A.col2 = B.col2
and A.etc = B.etc
);
-Original Message-
From: Bill Conner [mailto:[EMAIL PROTECTED]]
Sent: Friday,
Of course not, they will coopt some other nearby island and drill and
refine there! After all, with those amphibious SUV's it should be easy
enough to get over there to pick up the gasoline.
At 02:11 PM 5/18/01 -0800, you wrote:
I imagine you'll be drilling for Oil in your Island refuge
I'm trying to do an import into a database. I've done this before, and it's
always worked. Now it's failing with an error 1658 on a particular table.
Teh error text includes this:
pctfree 10 pctused 40 initrans 1 maxtrans 255 storage (initial 1274224640
next 637075456 minextents 1 maxextents 121
Title: RE: dbms_sys_sql
-Original Message-
From: Seley, Linda [mailto:[EMAIL PROTECTED]]
Sent: vendredi, 18. mai 2001 15:11
To: Multiple recipients of list ORACLE-L
Subject: RE: dbms_sys_sql
I am working on scripts that will create tables and users, grant
Title: RE: dbms_sys_sql
I do
understand, but I don't want to. When this code goes live we'll be
creating approx 1000 user ids. Right now we're a small company.
Hopefully we'll grow (soon!). I don't want to have 1000+ copies of the
procedure. Hence the reluctance to go that way.
Thanks!
Title: RE: A drop schema script ??
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
I've found that when dropping a schema owner, it's much easier
to drop their objects individually, then drop the user.
I hope Mr. Still won't mind if I post another script
you can create the table in the database before the import with the size
parameters you want and then import with ignore=y to ignore errors. Note
that this will ignore ALL errors
From: Dennis Taylor [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
Title: RE: import oddity
-Original Message-
From: Dennis Taylor [mailto:[EMAIL PROTECTED]]
I'm trying to do an import into a database. I've done this
before, and it's
always worked. Now it's failing with an error 1658 on a
particular table.
Teh error text includes this:
Title: RE: ADMIN: 2nd Beta of web-based ODTUG archives now available
-Original Message-
From: Bruce Bergman [mailto:[EMAIL PROTECTED]]
I have just finished making some changes to the ListGuru
web-based archive
facility (http://www.fatcity.com/ListGuru), if anyone would
like
Hei ..
I'm running Oracle 8.1.6. and using Sqlplus 3.2.2.
I got a artical from internet is about setting the spool file to output as
html
here is the example
SQLset markup html on spool on
SQLspool c:\temp\x.html
SQLselect * from emp where rownum =2;
SQLspool off
SQLset markup html off spool
Title: RE: Export only users, roles, grants etc
-Original Message-
From: Browett, Darren [mailto:[EMAIL PROTECTED]]
I have a small datawarehouse that I would like to re-design
and re-build.
All the scripts are in place to recreate the
snapshots, tables and associated
You could also use indexfile=filename option during import. This will not import any data but will write DDL to the index file. Create table statments will be REM med in the index file. Just remove those REM from the index file, change the storage parameter for the tables and indexes and run the
Title: RE: Hei
-Original Message-
From: Raymond Lee Meng Hong [mailto:[EMAIL PROTECTED]]
I'm running Oracle 8.1.6. and using Sqlplus 3.2.2.
I got a artical from internet is about setting the spool file
to output as
html
here is the example
SQLset markup html on spool
Title: OT: RE: job offer from SAUDI ARABIA
-Original Message-
From: Gene Sais [mailto:[EMAIL PROTECTED]]
Statistically, states where handguns are legal are the states
where violent crimes are less. Criminals prefer easy
victims. Outlaw handguns and only Outlaws will have
Yes...
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 18 May 2001 14:17:42 -0800
Hi, Gurus,
One of my colleagues killed ora_pmon and other background processes. If we
log
into svrmgrl, then the messge connect to idle instance show up. We
101 - 134 of 134 matches
Mail list logo