Dear all,
I have a text file of 70 rows. After
using sql*loader to load it into my table, I select * from my table it only
show 802 rows.
Some people told me that's because of buffer. Who
would like to show me how I ought to do? Thanks you and sorry for my bad
english.
BaoDuy
u must mount the database in exclusive mode, before putting the cmd for
alter database.
just give.
shutdown immediate
startup mount exclusive
alter database archivelog;
alter database open;
or do another
shutdown immediate
startup
will do the problem solved.
i've done it several times.
-
Hi,
install.pdf reads
Operating System:
Oracle9i is certified on SuSe 7.1, Kernel 2.4.4 and the
operating system library GNU Lib C
2.2.
I have Redhat 7.0 with kernel
2.2.16--22
I think I need to upgrade my kernel to 2.4.4 but
don't know how to, redhat site doesn't give great info nor di
Well there is no need to specify the alter system archive log start as
you have already done this by specifying the log_archive_start=true in the
init.ora. Try 'alter system switch logfile' command a couple of times and
see if anything is written to disk. Check using 'archive log list' comman
Hi Gaja and thanks also to Riyaj,
If I didn't make it clear before we were having a major performance problem.
A package call that should (ie "normally" / used to) take less than 1 second
starting taking between 20 - 60 seconds.
I appreciate your comments on logical IO and will look into that a
Hi Johnson,
I think you may be "reading just a tad bit too much"
into what I wrote regarding the "SORT_AREA_SIZE
increase" recommendation. The rationale for that was
not based on "disk sorts are always faster than memory
sorts or vice versa". It was based on the fact that
data for "global tempora
Dear Ravindra ,
You can use this output itself. Just select the fixed width
option instead of the delimited option. Then put you own column lines where
you want them to be.
Regards
Thanks for giving the solution.
Regards,
Anand.
-Original Message-
Brian
Sent: Thursday, June 21, 2001 9:03 PM
To: Multiple recipients of list ORACLE-L
aud$ is one of the few system tables that can have an owner other than sys.
You can create it under another schema (like system) and gi
Yes, the statement is different, but just based on the words in the
sentence. "Playing a role in inventing"!= "inventing". Odd thing
about words: they mean something.
Hell, I play a role in the community on this listserv.
I am certain Jared and Esteemed Company would make the
semantic mistake
I'm the owner of the table also, becoz I create it and I drop it before ?
-Original Message-
Sent: Thursday, June 21, 2001 10:01 PM
To: Multiple recipients of list ORACLE-L
You are right on this to a certain extent, you either have to be the schema
owner, or you need to have been grant
Ravindra,
Yep its possible to transform your o/p from spool into excel, but you will need to
format your data before extraction.
you can do this by select fieldname||chr(32)||fieldname from blah;
where chr(32) represents the space character, which will help you to print in a
different column
Is this command avaiable in Oracle 7 ???
I got this error in TOAD.
The following error has occurred:
ORA-06550: line 6, column 11:
PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the
following:
:= . ( @ % ;
-Original Message-
Sent: Thursday, June 21, 2001 10
Another thing is I can do a delete from ln01 in PL/SQL , but why don't
truncate ?
-Original Message-
Sent: Thursday, June 21, 2001 10:50 PM
To: Multiple recipients of list ORACLE-L
All,
that's because there are special security rules attached to stored
procedures and packages.
from s
I have a sql script to generate a dialy report like this.
01-JUN-200107 84
17 18 11
*** -
MAXIMUM No. 11
TOTAL 15
04-JUN-200108
SYS objects could be a good starting point for clustered objects.
-Original Message-
Sent: Thursday, June 21, 2001 8:17 PM
To: Multiple recipients of list ORACLE-L
Stephane and Ivan,
I've never experimented with clusters, mainly because of the reputation
problems Stephane referred to.
Stephane and Ivan,
I've never experimented with clusters, mainly because of the reputation
problems Stephane referred to.
It seems like I remember, and it was quite some time ago, that someone
mentioned clustering, the traditional method, a single table and saw some
benefit data retrieval wise.
My sig is the least of my problems here.
For someone who is working 100 hours a week, I feel like I am accomplishing
absolutely nothing. Considering I get dragged into everything as they know
I can get it done, I have absolutely no say in anything, even though I am
the only dba type out of about
Kevin,
I don't have the answer. And my Celko book has variations on doing this.
But, the first thought off the top of my head was that we might be able to
make this real easy via some of the analytical functions that first came to
be in 8.1.6. Anyway, I struggled with it a bit and decided to do a
What about this:
SQL> create table median ( c1 number );
Table created.
SQL> insert into median values (1);
1 row created.
SQL> insert into median values (1);
1 row created.
SQL> insert into median values (3);
1 row created.
SQL> insert into median values (5);
1 row created.
SQL> insert
Red Hat to play in Oracle's arenaJune 19,
2001, 5:50 p.m. PThttp://news.cnet.com/news/0-1003-200-6325676.html?tag=st.ne.1003.saslnk.sasemlThe
Linux seller will announce new database software next week, hoping towhittle
away at Oracle the same way it has with
Microsoft.
Is anyone using Oracle Label Security? If so, does it offer a more
secure environment or just cost and overhead?
Pete Barnett
Oracle Database Administrator
Regence BlueCross BlueShield
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Peter Barnett
Laura,
New to Oracle, but not databases. (Laura and I worked together years back).
There are products out on the market that will do this, Quest Software's
Schema Manager comes to mind.
What exactly are you looking for when you say differences? Columns? Column
sizes? Ordering of the columns i
And to get their values:
select KSPPINM, KSPPSTVL ,KSPPDESC
from sys.x_$ksppi ksppi, sys.x_$ksppcv ksppcv
where substr(KSPPINM,1,1) ='_' and ksppi.indx = ksppcv.indx;
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Figured life is hard enough!
-Original Message-
Sent: Thursday, June 21, 2001 6:13 PM
To: Multiple recipients of list ORACLE-L
Did someone pay you to say that?
-Original Message-
Sent: Thursday, June 21, 2001 5:27 PM
To: Multiple recipients of list ORACLE-L
Oh! I swear I me
Yea, I second that.
- Ross
p.s. Chris, looks like Ron could use some moral support
with his sig file, too.
-Original Message-
Sent: Thursday, June 21, 2001 6:23 PM
To: Multiple recipients of list ORACLE-L
Your right. What's even worse is when you post a solution (or idea) and
nev
Why not post his email address, and I'll
have a chat with him.
That should drive him from the IT business
long enough for you to recover your (sig) expressions
of creativity.
You should sponsor a service where people can put in
their suggestions for your sig file. It would be fun.
I'll get
spool holding_session.lst
column object_name justify c heading "Object|Name" format a32
column usernamejustify c heading "User|Name"format a7
column osuser justify c heading "OS|User" format a7
column pid justify c heading "Ora|Proc|ID" format 999
column serial# j
The amount of memory (Virtual) that is used is proportional to the size of
PL/SQL table.
There is no solution for this b/c it's perfectly normal except that the
amount of used memory is huge in comparison to the maximum amount of data in
the table which could be a memory leak.
You could estimate
Yes, you are . I still remember my relaxed stay for 3 years in Amsterdam
between 1984 to 1987.
Have a nice time,always
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 21 Jun 2001 06:00:50 -0800
Sounds like I'm working in one o
yea, you're on the right trackif he says
"I can't" claim you have found a guru who can
and you want to bring him in for an interview.
Then, watch the creativity unfurl from his
puckered sphincter.
As for DBMS_APPLICATION, it's a real thang. rtfm,
it's interesting even if you don't use it
Does anyone have a handy function for calculating the Median of data ?? It
seems like it should be simple ...but
-Original Message-
Sent: Thursday, June 21, 2001 5:32 PM
To: Multiple recipients of list ORACLE-L
Thank you Jeremiah
-Original Message-
Sent: Thursday, June 21, 200
Thank you Jeremiah
-Original Message-
Sent: Thursday, June 21, 2001 5:01 PM
To: Multiple recipients of list ORACLE-L
This used to work on other platforms and versions, but my HP-UX 64 bit
binary
doesn't have any interesting strings any more:
strings $ORACLE_HOME/bin/oracle | perl -ne '
Jeremiah;
First, thanks. NIce infor to have.
Second, the first line works great on Solaris and Oracle 8.0.5.
Third, the sql statement should actually be
select KSPPINM, KSPPDESC from x$ksppi where substr(KSPPINM,1,1) =
'_'
Missed the ,1 parm off the substr.
-Original Messa
Hello,
I'm fairly new to the Oracle world and have read a ton
of books on the subject (and haven't even made a dent
into the huge number of books out there). I thought I
had seen scripts out there that would compare
different database schemas for differences (such as
test and production). Does
Let's not get carried away,
here, Jim.
Even if he said something
perfectly reasonable in context, you
can't deny people the right to
obscure his words in a damaging
way. That just wouldn't be
right!
It's like: "I opened a socket,
but didn't accept any packets" from
the networking cla
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Thursday, June 21, 2001 5:36 PM
To: Multiple recipients of list ORACLE-L
Does anyone have any script that will help me fi
And this statement is ANY better??? I use "Software that Powers the
Internet" therefore I guess I, in a way, run the darn thing. :) God bless
the electoral college!
Chuck Speaks, MCSE
Database Administrator
Lithonia Lighting
770-922-9000 x3450
http://www.lithonia.com
-Original Message
Title: RE: TRUNCATE IN PL/SQL
Heh,
you should have saw the post on LazyDBA.
"Christopher is on the other
list, and all he is doing is promoting his website, how annoying".
I got a kick out of that one. Most of them I laugh off
though.
"Walking on water and developing software from a
s
At 01:21 PM 6/21/01 -0800, you wrote:
>get an idea of how fast they drove and how wreckless based on number of
If reckless is a measure of bad driving, then wreckless must be a measure
of good driving :-)
Dennis Taylor
Moral victories don't count
--
Please see
Your right. What's even worse is when you post a solution (or idea) and never get any
response
back.
Oh well. If some people don't like it, tough.
Ron
Hypercom.
Hai Friends,
I have a small query.
I need formulae for calculating
the
SGA.
TABLESPACE SIZE
TABLE SIZE
INDEX SIZE
ROLLBACK SEGMENT SIZE.
It would be really kind enough to help me on this
issue.
Thanks
Regards
Saravana.
I'm also happy to report that my favorite parameter is still there:
Name Description
-
_nested_loop_fudgenested loop fudge
--
Jeremiah Wilton
http://w
All right, I am not DBASTUD, you're using big words!!:) I am all over the
idea of having him split up the code. I recommended doing it with script
files that way we could end the session after the first run, free up the ram
and the vm and then start the process again. But he says he can't do it
Hai friends,
Here is a interesting question.
My database is behind a firewall,the user access the db thru a web logic server
residing
in a different m/c in the same domain where
the db resides.I would like to get hold of the
My boss yelled at me for rotating the message in my sig. As it offended
someone one time. So I just stopped my sig total, I recently brought it
back but I am not going to bother changing it, I would like to as I got some
good ones. Somedays the sun doesn't shine, some days it pours, somedays yo
This one showed up on the list a couple of weeks ago. It has heaps
of good diagnostic info.
set linesize 132 pagesize 66
break on Kill on username on terminal
column Kill heading 'Kill String' format a13
column res heading 'Resource Type' format 999
column id1 format 990
column id2 format 99
This used to work on other platforms and versions, but my HP-UX 64 bit binary
doesn't have any interesting strings any more:
strings $ORACLE_HOME/bin/oracle | perl -ne 'print if /^_[a-z]+_[a-z]/' | sort | uniq
The typical location for underscore parameters is x$ksppi:
(as SYS:)
select KSPPINM,
He also included something like "in the
Congress" in his statement, so it was pretty clear he was speaking about
providing political support as opposed to technological innovation. If you
read the transcript there's not much confusion. But it does make for some
good jokes.
Jim
>>> [EMAIL
Title: RE: RMAN - Veritas NETBackup
Are you using Quick I/O or do any of your datafiles fronted by a link? If so, RMAN is not backing up the links, just the data in the datafiles. When restoring, you will have to precreate the links and/or the QIO files, if they have been lost. That was a l
Maybe he was one of the first users or he knows someone that used it or he
saw it being used or he heard that it was used or invented!!
-Original Message-
Sent: Thursday, June 21, 2001 5:47 PM
To: Multiple recipients of list ORACLE-L
nope, he said
"I played a role in inventing the Inte
Did someone pay you to say that?
-Original Message-
Sent: Thursday, June 21, 2001 5:27 PM
To: Multiple recipients of list ORACLE-L
Oh! I swear I meant nothing except sending a 'hello'!
Regards,
Waleed
-Original Message-
Sent: Thursday, June 21, 2001 4:12 PM
To: Multiple rec
On Thu, 21 Jun 2001,Kevin Kostyszyn scribbled on the wall in glitter crayon:
->I would love to speak more of this mythical code, but that would require me
->to understand the cryptic inner sanctum of the code of P.Dorsey and his
->developers!! I will speak to the developer, see what I can squeez
We do donuts around here at very high speed.
It's called "The Capital Beltway".
-Original Message-
Sent: Thursday, June 21, 2001 5:21 PM
To: Multiple recipients of list ORACLE-L
Hey, donuts your not speeding,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Auth
Can't..control.laughter...stomach in.pain:)
-Original Message-
Sent: Thursday, June 21, 2001 5:20 PM
To: Multiple recipients of list ORACLE-L
I think Rachel has these.
Also, Chris Spence has recently completed reverse-engineering
the entire oracle binary set into assemb
Does anyone have any script that will help me find out the locks that are
held in the database.
We are facing a problem related to lock.One of the transaction is holding a
lock on a table and
there is another transaction wanting a lock on that table but waits for long
time .Is there
any lock time
yea, have him break his code into modules and
try to track it down that way.
or, do it the right way and use dbms_application.
-Original Message-
Sent: Thursday, June 21, 2001 5:27 PM
To: Multiple recipients of list ORACLE-L
I would love to speak more of this mythical code, but tha
nope, he said
"I played a role in inventing the Internet"
-Original Message-
Sent: Thursday, June 21, 2001 5:27 PM
To: Multiple recipients of list ORACLE-L
I thought he invented the internet. Just ask him. The best line was "I
knew Jack Kennedy and You are no Jack Kennedy" said by Lo
Or flush the rows to a real table when you hit a certain threshold?
Scott Shafer
San Antonio, TX
210-581-6217
"I hate the country, all those animals walking around un-cooked."
> -Original Message-
> From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, June 21, 2001 4:03 PM
> To:
I thought he invented the internet. Just ask him. The best line was "I knew Jack
Kennedy and You are no Jack Kennedy" said by Loyd Benson to Dan Quayle.
>>> [EMAIL PROTECTED] 06/21/01 05:13PM >>>
:), actually if you parrot Gore, it would be
"I played a role in inventing certifications".
Th
I would love to speak more of this mythical code, but that would require me
to understand the cryptic inner sanctum of the code of P.Dorsey and his
developers!! I will speak to the developer, see what I can squeeze out of
him without getting shot!!
KK
-Original Message-
Sent: Thursday, J
Title: RE: TRUNCATE IN PL/SQL
I
personally notice a bunch of peole giving Chris their two cents on
a
fairly frequent basis.
-Original Message-From: Bowes, Chris
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June 21, 2001 4:36
PMTo: Multiple recipients of list ORACLE-LSubject: R
I think Rachel has these.
Also, Chris Spence has recently completed reverse-engineering
the entire oracle binary set into assembler, C, and Sanskrit.
You can get his results (including the cross compiler code )
at www.rosetta_stone.com .
Also, aside from the "undocumented" parameters, maybe
Oh! I swear I meant nothing except sending a 'hello'!
Regards,
Waleed
-Original Message-
Sent: Thursday, June 21, 2001 4:12 PM
To: Multiple recipients of list ORACLE-L
Oh boy, not this again.
I left the last list because people complained I posted too much, and didn't
like my view on
> [EMAIL PROTECTED] wrote:
>
> Greetings to all.
> I have to teach a small dba class tonight and we will be covering
> clusters and index organized tables. I am a young dba and have never
> used or managed either on. Can some one please give me some real
> world examples of when its ideal to u
Brian:
Why don't you do what us "ubergeeks" do? Test. in a loop, try run each
version, say 1000 times and tell us how long they take to run in your
environment.
(I want to know, but am too lazy to do this for myself right now!)
Kevin
-Original Message-
Sent: Thursday, June 21, 2001 4:3
Hey, donuts your not speeding, and considering even goverment GPS can't
detirmine anything within 3 feet because of the garbage purposely put in the
air to make it harder for foreign countries to use our GPS for targeting
they won't know. But you can tell from the tire wear. That is always the
b
Chris,
Don't even respond to Ethan's post. Keep running. Let the
baton remain in your grip.
But how about a rotating message in the sig file? ;->
Ross
-Original Message-
Sent: Thursday, June 21, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L
Keep posting Chris, I think most
Aye I took it the wrong way, we have talked in private mail. Still a little
stung from Lazydba list. Not to mention this 100 hour / week stuff just
running around patching things. Little edgy right now, my bad.
"Walking on water and developing software from a specification are easy if
both are
Actually, I really like this idea. Just tried it out (works, of course), and
it does provide better security. thanks for the tip!
lc
-Original Message-
Tim
Sent: Thursday, June 21, 2001 3:06 PM
To: Multiple recipients of list ORACLE-L
If possible, I prefer to create the procedure in th
Did you ftp the export file while not in Binary Mode?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike J Kurth
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access /
soa PL/SQL table?.can you say more
about the code in question without violating
the cryptic inner sanctum of Dulcian?
-Original Message-
Sent: Thursday, June 21, 2001 3:55 PM
To: Multiple recipients of list ORACLE-L
DBMS_PIPE.down('Ross');,
Thanks for not destroying me w
I would say that (A) will be the most performant
because you are giving Oracle the EXTRA information
that you only want one row. (b) and (c) could
possibly produce a massive result set of which you
only then fetch 1 row.
hth
connor
--- "Norrell, Brian" <[EMAIL PROTECTED]> wrote: >
I have seen c
:), actually if you parrot Gore, it would be
"I played a role in inventing certifications".
The devil is in forgetting the details!
-Original Message-
Sent: Thursday, June 21, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L
Or as Gore would say..."I invented certifications"
C
Hey gang;
Is there any place that has a list of ALL the things you can put into the
Init file and what they do ?? Not just the regular option strings I
can get a list of these from a couple of web sites , but all of the hidden ,
and as far as I know, undocumented EVENT strings as well??
The sequence number is the number of commads in history I believe.
-Original Message-
Sent: Thursday, June 21, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L
What do you use the sequence number at the end for?
Ron
-Original Message-
Sent: Thursday, June 21, 2001 11:07
Easy, Chris. Back away from the ledge slowly. That's it. Just a little
further...
I'm sure Waleed meant that in jest. Just remember, its hard to determine
"tone" via email. Believe me, your contributions are noted and appreciated.
Scott Shafer
San Antonio, TX
210-581-6217
"I hate the cou
I agree, Chris brings the goods!! Keep Posting!
KK
-Original Message-
Sent: Thursday, June 21, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L
Keep posting Chris, I think most of us greatly appreciate the work you do
both on the list and at home with your servers. I suggest you j
Hi Bruce
You need to find what blocks are hanging from the particular latch. You could get this information by joining x$bh and v$session_wait tables while the sessions are waiting for this latch.
select distinct ts#, file#, dbarfil,dbablk from x$bh
where hladdr in
(select p1raw from v$
Title: RE: TRUNCATE IN PL/SQL
Yes, he does. His pay for the incredible amount of help he provides is the simple thank you that the recipients of the help send him and he doesn't even ask for that...
-Original Message-
Sent: Thursday, June 21, 2001 3:16 PM
To: Multiple recipients of
Keep posting Chris, I think most of us greatly appreciate the work you do
both on the list and at home with your servers. I suggest you just let
comments like that go to "/dev/null" and just keep doing what your doing,
don't even break stride to comment.
Thanks,
Ethan
-Original Message-
Hi,
I need to export data from one db and import it into
another db. The table name, structure in both db are
exactly the same. It's Oracle815 on Sun Solaris.
I got error in index file. How does that happen? And
what will be the possible solution? Thanks.
Export file created by EXPORT:V08
I have seen code that depends on the 8.1 behavior. It does bring up a
question I have always wondered about. The question for the internals
ubergeeks is: which of the following is best to use? (All should have the
same result, so which one has the best performance and why?)
A)
declare
y numb
Greetings to all.
I have to teach a small dba class tonight and we will be covering clusters and
index organized tables. I am a young dba and have never used or managed either
on. Can some one please give me some real world examples of when its ideal
to use these. Also which tends to be
Hi Gaja,
I notice that you have advised Bruce to increase
SORT_AREA_SIZE to gain proformance lost due to
frequent allocation of temp segments. I too belived in
the theory that disk sorts are always faster than
memory sorts untill I stumbled on my own problem
which leaves me a little confused.
Thanks Anita. I have just not thought much of it since then so I stayed
away from it. Now that I am at a new job that is still on 8.0.5, I have not
reason to look back into things.
-Original Message-
Sent: Thursday, June 21, 2001 9:35 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Kevi
Thanks Rodd. Forgot that one.
-Original Message-
Sent: Thursday, June 21, 2001 9:22 AM
To: Multiple recipients of list ORACLE-L
Also need an entry in the /etc/oratab file for the new SID.
>> Original Message <<
On 6/20/01, 8:10:19 PM, Kevin Lange <[EM
If possible, I prefer to create the procedure in the table owners schema and
then grant execute to the user that needs to perform the truncate... That
way you don't have to grant privileges like "DROP ANY TABLE"...
Tim
-Original Message-
Sent: Thursday, June 21, 2001 2:44 PM
To: Multipl
Oh boy, not this again.
I left the last list because people complained I posted too much, and didn't
like my view on things. Yet they never complained when I helped everyone
with many many problems. I answered 20% of the posts on the list, and I
always got flak for them.
You cannot win.
"Wal
I have been asked to consider installing iAS as a "2-node", i.e. put most of
iAS on one server and the application cartridges on the back end server.
The course book for OAS mentions that this can be done, but I can't find any
references to this in the iAS installation manual.
In the meantime he
Or as Gore would say..."I invented certifications"
Chuck Speaks, MCSE
Database Administrator
Lithonia Lighting
770-922-9000 x3450
http://www.lithonia.com
-Original Message-
Sent: Thursday, June 21, 2001 2:44 PM
To: Multiple recipients of list ORACLE-L
Or dubya would say ... "certific
DBMS_PIPE.down('Ross');,
Thanks for not destroying me with your mental powers:) I am concerned
about the size because it is completely hosing the machine. The worst part
is, it is ONE connection that is doing it. No one else is connected to the
db, but once this migration begins, POW, t
this is what happens when I post with insufficient blood levels of caffeine.
take what I said and reverse it. You need DROP any table privilege, not
delete any table.
Early editions of the docs said you needed DELETE any table, they were
wrong. Latest editions of the docs have been amended and
> What is itrprof?
You can find out about it ... go to www.google.com and search for itrprof.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Californi
We noticed a different behavior with too_many_rows exception in v7 and v8i.
Is this a bug or that's the way it should work in 8i?
I really appreciate your feedback on this.
Thanks & Regards,
Prasad
declare
v_table_nameuser_tables.table_name%TYPE;
begin
v_table_name := null;
select table_na
Kevin,
Note 46001.1 "Oracle Database and the Windows NT
memory architecture, Technical Bulletin" is an
excellent resource.
ORA_WORKINGSETMAX is set to a value in MB (complete
details in the note).
Do you have QSLICE (part of the NT resource kit) or
another tool that will let you view the indivi
Do you get paid for your daily number of posts?
Waleed
-Original Message-
Sent: Thursday, June 21, 2001 2:44 PM
To: Multiple recipients of list ORACLE-L
It should only be drop any table.
"Walking on water and developing software from a specification are easy if
both are frozen."
Chri
There are two problems.
1. You must have permissions (Not via a role)
2. Must use Dynamic SQL (DBMS_SQL/Execute Immediate)
PL/SQL has had these restrictions for a long time, privileges will not work
through roles and cannot execute DDL without using Dynamic SQL options.
"Walking on water and de
Thanks Tom & Kirti---
As an experiment I revoked the delete any table and granted the drop any
table, and it worked. The drop any table is the key
thanks to all!
lc
-Original Message-
Thomas F
Sent: Thursday, June 21, 2001 2:10 PM
To: Multiple recipients of list ORACLE-L
Lisa,
J
Qio does not increase performance of reads, it is mainly for writes.
Although Cached quick io will give read performance boost in some areas due
to the pre-fetch
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
It should only be drop any table.
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Thursday, June 21, 2001 2:10 PM
To: Multiple recipients of list ORACLE-L
Lisa,
Just tri
1 - 100 of 227 matches
Mail list logo
