Indeed, Paul. Very good points.
Gary - you're asking us to determine the number of bags we'll need at the
supermarket without knowing what we're going to buy. If we had IO-stats for your
datafiles/tablespaces, ie reads/writes and their size, and your availability
requirements on the system, we
Hi,
I have two database instances 816SE and 817EE on WinNT. For the same query I
get different result as follows (optimizer_mode=CHOOSE).
What actually I don't understand is, that why are there resource costs in
the EE 8.1.7. version and not in the SE 8.1.6 version. Both databases are
created
Hi,
How to find allocated and used space for a table?
I required it urgently
Regds
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L
Title: How do IMP EXP - SOS
hi
I need to do the IMP of a dmp file from Oracle 8i to 8.1.5
can you guys pls help me how to go about it
with warm regards
deewaker g v
Hi,
I have two database instances 816SE and 817EE on WinNT. For the same query I
get different result as follows (optimizer_mode=CHOOSE).
What actually I don't understand is, that why are there resource costs in
the EE 8.1.7. version and not in the SE 8.1.6 version. Both databases are
created
Thanks Mark. I never had the curiosity to look at the Intermedia cartridge,
but yes, it answers the problem.
Christian (Bilou)
-Message d'origine-
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]De la part de Mark Leith
Envoyé : jeudi 7 juin 2001 11:24
À : Multiple recipients of list
Why would someone write a SQL*Plus script against sys.v_$parameter when you
want to find the value of an init parm, when instead you could code against
v$parameter?
- Greg
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City
manoj,
i have a procedure which lists the space allocated and space occuopied (and
space wasted)
for tables/indexes... making use of the dbms_space package...(mail me
privately)
Also, a while back someone else (Jared ?) posted a similar procedure.. you
might
find it on his website
Regards
Hallo you DBA's:
How can I modify in this script to make it handle also null values. This script only
handles 0-values.
Hope anyone can help me with this.
vOWNERSHIP_NO:= rpad(to_char(nvl(recCursor.OWNERSHIP_NO,' 0')),2,' ');
Thanks in advance
Roland Sköldblom
--
Please see the official
On Jun 10, 2001 at 11:30:23PM, Szecsy Tamas wrote:
Hi,
I have two database instances 816SE and 817EE on WinNT. For the same query I
get different result as follows (optimizer_mode=CHOOSE).
Did you analyze the tables?
--
Vladimir Begun | Stability is often more correct than
Hi Soman
Use one of thies selects
SELECT
SEGMENT_NAME,
TABLESPACE_NAME,
FILE_ID,
BYTES
FROM
DBA_EXTENTS
WHERE
OWNER = 'OWNER'
AND
SEGMENT_NAME = 'SEGMENT_NAME';
SELECT
SEGMENT_NAME,
SUM(BYTES)
FROM
DBA_EXTENTS
WHERE
OWNER = 'OWNER'
On Jun 10, 2001 at 11:55:45PM, Soman Manoj wrote:
Hi,
How to find allocated and used space for a table?
SELECT SUM(blocks) blocks
, SUM(bytes) bytes
FROM dba_extents
WHERE segment_name = 'table_name'
/
...
SELECT SUM(VSIZE(colA))
+ SUM(VSIZE(colB))
+ ...
+
On Jun 11, 2001 at 12:25:22AM, Greg Moore wrote:
Why would someone write a SQL*Plus script against sys.v_$parameter when you
want to find the value of an init parm, when instead you could code against
v$parameter?
In fact you'll get the same result.
v$parameter is a synonym for v_$parameter:
On Jun 10, 2001 at 08:56:12PM, Amar Kumar Padhi wrote:
Hi,
I need some info regarding if there are any limitations in using index
organised tables compared to normal tables. Moreover, what is the deciding
factor to be considered to give preference to an index organised table over
a normal
If you can afford to analyze the Table(for latest statistics) then
1. Analyze Table tablename compute statistics.
2. select blocks Used Blocks ,
blocks + empty_blocks Allocated Blocks
from dba_tables where table_name = 'tablename';
hth,
Rajesh
-Original Message-
Sent: Monday,
Jared,
I tried again and got the same result.
on oracle 8.1.7 (RBO).
session1 : delete from emp where deptno = 10;
session2 : delete from dept where deptno = 30;
session 2 hanged and waited till transaction in session one was committed.
the max_trans on both tab is set to 255, incase this
If you're obsessive about performance - its avoiding
the synonym lookup I suppose..
Cheers
Connor
--- Greg Moore [EMAIL PROTECTED] wrote: Why
would someone write a SQL*Plus script against
sys.v_$parameter when you
want to find the value of an init parm, when instead
you could code against
if on 8i, use dbms_space utility
rgds
amar
-Original Message-
Sent: Monday, June 11, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L
Hi,
How to find allocated and used space for a table?
I required it urgently
Regds
__
Do
Hi,
In fact, in your case, adding larger TEMP is not the solution. Solution
is the adding TEMP with larger extent size.
Because, Oracle cleans up segments extent-by-extent. If you have more
extents, cleaning-up them will make more dictionary look-up and this will
eat CPU.
regards...
Charlie
Hi,
The results from previous mail's query would
differ( by 1) from following
SELECT SUM(blocks) Allocated Blocks
FROM dba_extents
WHERE segment_name = 'table_name'
/
The reason for this is that one block is reserved for the
segment header. DBA_SEGMENTS.BLOCKS holds the total number
Exactly. If you don't have stats on the tables, CHOOSE means RULE, ie no COST.
If, on the other hand, you have stats on at least one of the involved tables,
CHOOSE means cost-based, and more specifically it means ALL_ROWS, which is usually
not what you want.
Vladimir Begun wrote:
On Jun 10,
On Jun 08, 2001 at 05:30:29AM, novicedba wrote:
Hi,
Database 8.1.5
OS - NT
On my test database I deleted certain tablespaces and then shutdown the databases,
deleted the datafiles (still in recycle bin) and restarted the database . The
database started fine no errors.
When I check the
Hi all,
Is anyone using 2 Ultra 10 and Sun Cluster 2.2 as test environment ?
Is this achievable ?
Thank you..
Best Regards
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Dear Gurus.
Icreated a procedure and this procedure takes
parameters and then makes and alter table DDL on the database.
Butwhen I write
exec
pp(table_name1,field,table_name2);
Gives error.
ERROR at line 1:ORA-06550: line 1, column
10:PLS-00357: Table,View Or Sequence reference
Jared has a point. Is there an index on the foreign key?
Another minor detail: You should of course never update a primary key column, of
course :-)
Amar Kumar Padhi wrote:
Jared,
I tried again and got the same result.
on oracle 8.1.7 (RBO).
session1 : delete from emp where deptno = 10;
What's more interesting is of course a query against v$fixed_view_definition to
show how v$parameter (or v_$parameter) is defined. This will point you to
x$ksppi and other x$-tables where you can also see the un-documented parameters
(those starting with an _).
Greg Moore wrote:
Why would
There is only one case when you should use V_$something instead of V$SOMETHING, which
is when connected as SYS (or INTERNAL) to grant SELECT to a user who needs to create a
stored procedure or view involving the said V$something.
As Vladimir said, V$xxx is a synonym for V_$xxx, which is a
Explicitly no. Perhaps Oracle did on his own, while I imported the dump
files.
-Original Message-
Sent: Monday, June 11, 2001 10:31 AM
To: Multiple recipients of list ORACLE-L
On Jun 10, 2001 at 11:30:23PM, Szecsy Tamas wrote:
Hi,
I have two database instances 816SE and 817EE on
hi bunyamin
you have forgot to open the cusror before the start of the programme.
excute the dbms_sql.open_cursor function to get the curosr id.
cursor_name:=dbms_sql.open_cursor;
Venkata Ramana
Sierra Optima Limited,
SVR Towers, 8-2-1/B/1, Panjagutta,
Hyderabad 500082, India.
Ph: (91-40) -
Hi
You have already seen many post with the answer to this, but if you use
connect glogin.sql will not be run again.
I created a very basic script with a very short name and put it in the
directory where my SQL_PATH registry key points to. This script
does the connect (after prompting for the
Check out this link ..it is of 8.1.5
www.akadia.com/services/ora815nf.html
Azhar
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, June 09, 2001 3:35 PM
http://technet.oracle.com
-Original Message-
Sent: Friday, June 08, 2001
FYI,
I saw a link to this Yahoo news item on a Canadian news website
(www.bourque.com): http://www.bourque.com):
Monday, June 11 5:42 PM SGT
SAP, IBM to unveil e-commerce alliance in next few days: report
FRANKFURT, June 11 (AFP) -
German software giant SAP and US computer giant IBM are
On Sun, 10 Jun 2001, George Schlossnagle wrote:
Hmmm so it's a pci only interface, so I can't use it with my
Enterprise Sun systems, and drivers for Tru64 don't yet exist, so unless
you're running Windoze, AIX or Linux, you're out of luck. That's a real
bummer.
But there WOULD be the
Jared wrote:
I just *had* to point this out. Had too many damagers want to solve
everything by buying HW when they have no idea what the problem is.
how about Sun E650, 26 CPUs (yes, I said 26), 9GB RAM
made the application fly. Until we hit THE ultimate peak stress day and
they died. I
to create them as private, the syntax is:
create rollback segment ...
you don't need the work private in there.
for the ones that are offline try:
alter rollback segment segment name online;
and see if the status changes.
From: Saurabh Sharma [EMAIL PROTECTED]
Reply-To: [EMAIL
We
have installed iSQLPlus on our development box, and it seems to work fairly
well. The nice thing about it is you don't have to install the client on
the user's PC, it just uses a browser. It does have a bug or two - for
example, if the user does not click on the "Logoff" button and just
Title: How do IMP & EXP - SOS
Deewaker,
You
did not mention what is the version of Oracle 8i. I am assuming it is
higher than Oracle 815. In this case do the following
steps.
1.
Take export of the schema using exp from Oracle 815. To do this , you can
connect to your source database
I got some Ultra 1's that run Oracle 9i that I haven't posted on ebay yet.
We haven't got them all configured yet.
128-256Mb (possibly more), 167MHz cpu, 9-72Gb drive, 20 monitor, keyboard,
mouse.
Solaris 8, Oracle 9i
Walking on water and developing software from a specification are easy if
Hi,
yes I have tried working with
isqlplus.
It gets installed fine and works fine too. There is
a proper installation doc following which it could be installed.
It is buggy as you can expect it to
be.
everyone who used it at our place liked it (though
I had the headache of killing the
I believe that they have already made the tie up here in Australia, I am
surprised that we might have been first or nearly first with something like
this.
Oh well
Peter
At 03:51 AM 11/06/2001 -0800, you wrote:
FYI,
I saw a link to this Yahoo news item on a Canadian news website
Title: How do IMP & EXP - SOS
technet.oracle.com should give you everything you need under
documentation.
"Walking on water and developing software from a
specification are easy if both are frozen."
Christopher R. Spence Oracle DBA Fuelspot
-Original Message-From: Deewaker G.V.
oops Sun E6500
From: Rachel Carmichael [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
Date: Mon, 11 Jun 2001 04:50:19 -0800
Jared wrote:
I just *had* to point this out. Had
Title: RE: Re: OT - Wrap-up of 'Serious Question ' - now book idea - high
I haven't written it yet :), but Don G. and I have talked
about writing it together a couple of times.
The only thing stopping me from the attempt is
the how much time it'll take me away from
my kids.
R. Matt
What's wrong with that picture?
You are telling them what they do not wish/want to listen ;)
And I am making the same 'mistake'
- Kirti
-Original Message-
From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 7:50 AM
To: Multiple
The Gartner group just released a RDBMS market share analysis.
Their report showed Oracle's market share was still growing.
-Original Message-
From: Murali Vallath [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 10, 2001 11:15 AM
To: Multiple recipients of list ORACLE-L
Subject:
If its a PL/SQL procedure you could actually commit after 'N' records have
been processed, that may help, as you will be processing in smaller chunks
as opposed to a big bang approach..
Lee
-Original Message-
Sent: 11 June 2001 14:30
To: Multiple recipients of list ORACLE-L
I got
Mogens, the super-market analogy does not apply - this is for SQL Server
database. I'm not sure how far I'll be able to tweak that rdbms, hence my
question did not contain many details - it was simply a request for
opinions.
Btw, to sum up current responses:
Option 1: split 9 drives to separate
To bypass the view? Is it in a huge script? Could be to glean every bit of
performance from the script..
Mark
-Original Message-
Sent: Monday, June 11, 2001 09:25
To: Multiple recipients of list ORACLE-L
Why would someone write a SQL*Plus script against sys.v_$parameter when you
want
yep -- and as soon as I realized what I'd written I corrected it.
I've been running sleep-deprived for several weeks (months?) now. I'm
surprised that's all I wrote incorrectly!
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
This actually depends on the drives, if they are cheetahs, yeah you will be
pinched. But if it is anything but perhaps not.
I would hope they would be, but very possible they are not.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R.
Yeah , I think that family is the most sacrificed part.
If I would write a book , I would have to do it in my free times ( evenings
, nights , weekends ) , and usually this is the time that I have to spend
with my wife and kid.
Regards,
Antonio Belloni
Adams, Matthew (GEA, 088130) [EMAIL
On Mon, 11 Jun 2001, Rachel Carmichael wrote:
how about Sun E650, 26 CPUs (yes, I said 26), 9GB RAM
I assume you mean a Sun E6500 (since E650's don't exist). :)
--
Larry Herzog Jr.Do nothing out of selfish ambition or vain
ZRXOA #1029 conceit, but in humility consider
Raghu !
Normally ORA-600s are bugs or because of some
unhandled expectations. The arguements are split up
between various kernel layers.
This note will help you in understanding the layers
and your 17302 falls under KGL (library cache
component). So this is probably a bug or something
related
But there WOULD be the possibility of using them with Sun E250s and E450s.
Sure. Except that the drivers aren't available. Besides, these are really
tiny, unscaleable boxes.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: George Schlossnagle
INET: [EMAIL
Hello,
There are about 4 cases for ora-1555. Add following event to init.ora:
event = "1555 trace name errorstack, level 3"
After that, whenever Oracle encounteres ora-1555, a trace file will be
generated. Send trace file, let's look at what is happenning.
regards...
"Farnsworth, Dave"
Got it working at home on Windows 2000 with 8.1.7.0.0.
Works just fine, but .sql files are not able to read SQL*Plus commands
(i.e. column xxx format a10).
As I recall the install was fairly simple.
Jon Baker
Database Engineer (1/5)
[EMAIL PROTECTED]
www.netsec.net
Saurabh Sharma
Anyone using MTS with java applications with weblogic servers and JDBC
drivers.
We are not using this at the moment, but I am unable to track any
information about this configuration and the architecture of MTS with JDBC,
NET8 etc.
Regards,
Murali Vallath
Post the pic! :-P
Scott Shafer
San Antonio, TX
210-581-6217
And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Grâce via your Ninja
Death Touch, you
Hi Gurus
I have one question.
Create table tbl2 as select * from tbl1;
will above query use the rollback segment or not? and why?
Thx
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the
management was heavily invested in making the system go live as is...
since they were heavily involved with the design. They designed it without a
DBA.
OLTP system, main order table had 23 indexes on it. Because they wanted to
be able to search by customer first name, customer last name,
First, if in tnsnames.ora file on the client alias group contains
srvr=dedicated or in sqlnet.ora there is a parameter server=dedicated (or
something like this) - you will have dedicated connection. Second if your
maximum number of shared servers in init.ora less then number of users
trying to
Larry Herzog Jr. wrote:
But there WOULD be the possibility of using them with Sun E250s and E450s.
On Mon, 11 Jun 2001, George Schlossnagle wrote:
Sure. Except that the drivers aren't available. Besides, these are really
tiny, unscaleable boxes.
I didn't say it was a GOOD solution. I
Jared,
Thanks for the summary. Any comments on where Tcl fits in to the mix?
Henry
-Original Message-
Sent: Friday, June 08, 2001 5:11 PM
To: Multiple recipients of list ORACLE-L
Let me start off by saying that I like Java. I took a class
in it from Sun, and Java is easy. Learning
All,
Awhile back, on the other list, there was a discussion regarding the
number of data files that an Oracle database might contain.
Someone posted a warning that too many data files might actually hurt
performance in that it might inflate the amount of work to be done at SCN
update time.
You are getting current SQL but you need to go thru all SQL for this session
to find out if there was alter table drop (column).
Alex Hillman
Original Message-
Sent: Wednesday, June 06, 2001 9:36 PM
To: Multiple recipients of list ORACLE-L
Obtaining the triggering statement is beyond my
Hi !
Someone posted a warning that too many data files
might actually hurt
performance in that it might inflate the amount of
work to be done at SCN
update time.
How would I test this? What wait value might be
too high to indicate that
this is taking too long?
How many is too many?
Dave,
Unfortunately that info is not currently stored
anywhere. You can find out when the refresh began, by
checking dba_snapshot_refresh_times (there's a bug
where the time in dba_snapshots is listed as some time
in 1950).
You'll be happy to know that 9i will include some new
views that will
Wow, I thought I just wasn't looking hard enough. It's seems obvious that
we'd want to see when the refreshes finished. I'll take your advice and
wrap the call.
Thanks, Dave
On Mon, Jun 11, 2001 at 10:30:25AM -0700, A. Bardeen wrote:
Dave,
Unfortunately that info is not currently stored
Hi All,
In light of the recent discussion here is an alternate view.
http://www.zdnet.com/zdnn/stories/comment/0,5859,2770541,00.html
Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dave Morgan
INET: [EMAIL PROTECTED]
Fat City Network Services--
Gopalakrishna
Thankyou for info. Yeah you are right I find there was open cursors involved
in dead lock..Thank for info again.
From: K Gopalakrishnan [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: arguments in ora-600
There is not a lot of documentation in the Oracle 8.1.5 Server
Reference Manual on this column. I know that this logging
column in DBA_TABLES view can be set to YES, NO, and NULL.
What kind of logging are we talking about? Redo logs?
We're running 8.1.5 on Sun Solaris 2.6. This is a
On Monday 11 June 2001 10:21, Henry Poras wrote:
Jared,
Thanks for the summary. Any comments on where Tcl fits in to the mix?
I've not used TCL, so I can't really say too much about it. It is generally
considered simpler than Perl, and likewise less robust.
TK is another matter. If you
I disagree wholeheartedly with this statement Alex. How can you make this
statement without knowing the situation? (You seem to be becoming the
resident troller in this group! Sorry, but it does appear that way.)
In spite of all evidence and repeated warnings, management often does not
allow
Youshouldenable client and server level
tracing get more details pertaining to this type of error. Given more
detail, we may be able to get to the bootom of the problem.
Defry
- Original Message -
From:
Helen rwulfjeq
To: Multiple recipients of list ORACLE-L
Title: RE: Sqlloader on VSAM file
Raymond,
Please
forgive me, but I am not sure now if you are asking a question or stating that
you're ok. Your control file looks ok except I 'define' my fields
differently. I am sending you an example below. I am assuming your
amount fields has 2 decimal
On Monday 11 June 2001 09:06, Rachel Carmichael wrote:
OLTP system, main order table had 23 indexes on it. Because they wanted to
?!?!?!
That's just nuts.
be able to search by customer first name, customer last name, recipient
first name, recipient last name and had foreign keys all
Title: RE: SID on sqlplus prompt?
I use this as well but it only works going through Sqlplus. If you want to change connections while you are in sqlplus by entering sql Connect username@dbname, then the sid/username will not change on the sql prompt. To make the connection change show, add a
All you need is Oracle 8.1.7 with the http server (apache) up and
running. The server comes as part of the install at least for
Enterprise Edition (never checked out Standard Edition). After you
install you will see an apache directory under the $ORACLE_HOME
directory
Jon Baker
I hoped that everybody understand that this was a joke. I use damagement
and :-) in the end. I hoped that it was grotesc. Apparently I was wrong. My
apologies for all offended. For people who do not understand humor I repeate
again that it was a joke.
Alex Hillman
-Original Message-
Alex,
I think you are trying to not be incredibly rude?
How rude of you!
grin, duck, and run like hell
|| -Original Message-
|| From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
|| Sent: Monday, June 11, 2001 3:39 PM
|| To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
|| Cc: '[EMAIL
Gopal,
How about this:
1* select owner,table_name, logging from dba_tables where logging != 'YES'
SQL /
OWNER TABLE_NAME LOG
-- -- ---
SYSATEMPTAB$
I am creating a report based on a couple tables. The report should show the
total amount sold for the current month and another field for total amount
sold Year To Date.
How can I created the report so that the month to date value for a
particular item is adjacent to the total amount for Year to
It seems sarcasm may be beyond you. Check the smileys for emphasis in
Alex's mail.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 11, 2001 4:00 PM
I disagree wholeheartedly with this statement Alex. How can you make this
statement
LOL! You got one, Alex.
|| -Original Message-
|| From: Don Granaman [mailto:[EMAIL PROTECTED]]
|| Sent: Monday, June 11, 2001 4:01 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
||
||
|| I disagree wholeheartedly with
He, he, he... forget the good beer - last week at a client get together
that happened to occur at a karaoke bar... Well, lets just say that a
microphone, feather boa, shots of whiskey, and cheap beer are a dangerous
combination in a dba's hands...
Scott Shafer
San Antonio, TX
210-581-6217
And
Let's see. What was that rule of thumb I heard from Kevin Loney? I think it
was that each index slows down DML by a factor of 3 (at least for batch jobs
where you have to worry about recursive SQL). So 23 indexes would run about
70 times slower than no indexes. Do I sense a hardware throwing
Hi List,
As the part of developing hot backup strategy, I am testing the following
piece of code
to take care of arch files to be made avaialable along with backup set.
=
SQL create or replace procedure log_switch as
2 cursor1 integer;
3 begin
4 cur1 :=
I suspect, as with most 'rules of thumb', that Kevin's
does not scale well.
|| -Original Message-
|| From: Henry Poras [mailto:[EMAIL PROTECTED]]
|| Sent: Monday, June 11, 2001 4:42 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Veritas Quick I/0 and Oracle/
Hi Mohammad !
They all are **temporary** tables and (have you
checked the definition) in the NULL tablespace. So it
is perfectly normal :)
--- Mohammad Rafiq [EMAIL PROTECTED] wrote:
Gopal,
How about this:
1* select owner,table_name, logging from dba_tables
where logging != 'YES'
SQL /
Title: RE: what's wrong with this...DBMS_SQL
Surendra, you need to execute it. Look at the spec of dbms_sql (I want to say it's dbms_sql.execute()). Either that or use EXECUTE IMMEDIATE.
Lisa Koivu
Oracle Database Administrator
954-935-4117
The information in the electronic mail message
I'd hate to argue with Anita, but I'm pretty sure that rollback
won't be used on CTAS, since it's ddl.
Somebody verify or correct please?
Thanx,
Yosi
-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 1:21 PM
To: Multiple recipients of
The DBMS_SQL is executed inside a package, so the owner of the package must
be granted the ability to switch log files directly. More than likely, he
only has this privilege through a role.
Brian Norrell
Manager, MPI Development
QuadraMed
511 E John Carpenter Frwy, Su 500
Irving, TX 75062
(972)
Title: Current Osuser
Hi,
We can know the current oracle user (the username you are using to connect
to database) by 'select user from dual';
How to know what is the current osuser (not the list of osuser) ?
Tia.
Rivaldi
Were you wearing a speedo with that feather boa?
|| -Original Message-
|| From: [EMAIL PROTECTED]
|| [mailto:[EMAIL PROTECTED]]
|| Sent: Monday, June 11, 2001 4:36 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Friday thought
||
||
|| He, he, he... forget the good beer
as I said, 26 CPUs, 9GB RAM, lots of disks..
oh, and they wanted a bitmapped index on that table too
somedays it don't pay to get out of bed
From: Henry Poras [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Veritas
SELECT USERNAME,OSUSER FROM V$SESSION
=
Have a nice day !!
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail -
My solution is to uninstall everything you can with O-installer, then delete
oracle home and the oracle subdirectory under HKEY_LOCK_MACHINE/SOFTWARE in
the registry. Perhaps there are some other things you should do but this
has always worked for me in the past. Make sure you get rid of all
This article provides clean remove.
http://allaire.com/Handlers/index.cfm?ID=18374Method=Full
-Original Message-
Sent: Monday, June 11, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L
Hi,
Is there any white papers for removing one version of Oracle from an NT
machine? I
Hi Yosi,
It's a good idea to not argue with Anita! :)
Just do a simple test to confirm. Monitor 'writes' in v$rollstat before and
after running the CTAS. Good, if you have a test db and no one but you are
the sole user.
You will never ever forget what you find.
Just do it!
:)
Regards,
-
Hi Yosi,
I'd hate to argue with Anita, but I'm pretty sure that rollback
won't be used on CTAS, since it's ddl.
CTAS or any DDL for that matter *will* need to write to SYS tables - (UET$,
FET$ in this simple case as it needs to preserve information about extents
allocated, etc.) and this
1 - 100 of 122 matches
Mail list logo