Jeff,
The 3 sessions are doing the same (or similar) queries. In this case
count(*) which is forcing a full table scan of the table in each session.
The 3 sessions are thus trying to access the same blocks from the SGA, in
the same order. Only 1 session can access a block in the SGA at a
Hi
try to remove lock_sga from init.ora file
Ivo
Nirmal Kumar
Hi
I would try to set the table to cache mode. It seams that the blocks are
aged out from buffer - which is default for FTS.
alter table BBN_SRVvignette cache;
to avoid reloading into cache.
Ivo
Ivo Libal, Bc.
Design
Title: How to read trace file
check to see whether listener
settings are done on the system.
check for tnsnames.ora and
listener.ora files on home\network\admin folder
cheers.
saurabh
- Original Message -
From:
S.Jyotinarayan
To: Multiple recipients of list ORACLE-L
This will not resolve the 'buffer busy wait' scenario.
The contention is for blocks that are already in the SGA.
Regards,
Malcolm.
-Original Message-
Sent: Tuesday, November 27, 2001 9:15 AM
To: Multiple recipients of list ORACLE-L
Hi
I would try to set the table to cache mode.
Thomas Jeff wrote:
We recently had a new website go live. Since then, I'm seeing
constant buffer busy waits
and after a period of time, I see sessions hung on the same block#.
The SQL query
is always a COUNT(*) (below). It's almost as though one session has
a lock
of some sort in
Title: Number of Transactions per 24hr period? - Urgent
Hello List,
Please help, I would like to determine the number of transactions processed by Oracle during a 24 hr period.
Is this possible?
TIA
Denham
This e-mail message has been scanned for Viruses and Content and cleared by
Title: How to read trace file
just
start the oracle service in the control panel
Kranti
-Original Message-From: Saurabh Sharma
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 27, 2001 3:35
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
ORA - 12560: TNS: protocol
Denham Eva wrote:
Hello List,
Please help, I would like to determine the number of transactions
processed by Oracle during a 24 hr period.
Is this possible?
TIA
Denham
--
This e-mail message has been scanned for
Hi!
Where can I get a copy of
Scaling Oracle 8i
please
Cyril
On Tue, 27 Nov 2001 Jared Still wrote :
On Monday 26 November 2001 19:15, Rachel Carmichael
wrote:
For those of you techheads that don't yet have a
copy of 'Scaling
Oracle
8i',
it's full of
But what if they are aging out, isnt that one of reasons for buffer busy
and they are - if there is a scattered read
From docus:
As buffer busy waits are due to contention for particular blocks then you
cannot take any action until you know which blocks are being competed for
and why.
Title: RE: Number of Transactions per 24hr period? - Urgent
Thanks,
I have followed this line of thought, however, What parameter do I use as a yard stick?
Perhaps execute count, parse(hard), OR parse(total) - This is what I am not sure of:)
Thanks
Denham
-Original Message-
You cannot achieve this by one sql statement.
Instead you should consider use PL/SQL.
Make your own procedure or an anonymous PL/SQL block.
I would like to give you an example but you have to tell more about your
problem, like the update should be done based on a relation between those 2
Here is a script which generates all of the 'alter table' statements to drop
the referential constrains. Spool if or cut and paste and you should be all
set.
select 'alter table schema.'||table_name||' disable constraint
'||constraint_name||';'
from dba_constraints
where CONSTRAINT_TYPE in
Ruth:
Thanks, I found this to work also.
ALTER TABLE 'TABLE_NAME
DISABLE CONSTRAINGT CONSTRAINT_NAME;
Ken
-Original Message-
Sent: Tuesday, November 27, 2001 7:00 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Disabling Constraints
Here is a script which
Looks good. Does fol mean following?
Thanks,
Ken
-Original Message-
Sent: Wednesday, November 21, 2001 8:50 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Fixing a DB
Sorry forgot the command in my earlier email
To recap, here are the steps
1. create the new
I hate to disagree but why couldn't you
update x
set field = (select field1
from p
where p.join_field = x.join_field)
where conditions
Iain Nicoll
-Original Message-
Sent: Tuesday, November 27, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L
You
I have this large DB (approx. 250 tables) that has the tables and indexes in
the same tablespace (not my design). Is there a way I can move all of the
indexes to a separate tablespace en-mass? I know I can move them one at a
time with the alter index command, but that would be rather time
Title: FW: Antwort: RE: Antwort: RE: Buffer Busy Waits -- Sanity check please
The table has about 550,000 rows, and will be growing, currently about
230MB in size.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 7:25 AM
To:
Title: FW: Buffer Busy Waits -- Sanity check please
All: Thanks for the replies!
And yes, it's a data block. The query has been executed over 3,500 times
since this site went live about 5 days ago. I believe I'll check into
overindexing just as suggested, either that, go over and shoot
hi list,
i enrolled in this list jus today and it was
really nice to see the questions and the responses
that were posted.here i've got few doubts.if
possible plz do clear them as soon as possible, as
comming nov 30th is my project presentation.
1)If a tablespace is deleted will
Ken,
ALTER TABLE mytable DISABLE CONSTRAINT myconstraint.
This should work
Ramon E. Estevez
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
809-565-3121
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ken Janusz
Enviado el: Monday, 26 November, 2001 5:31
Title: RE: Number of Transactions per 24hr period? - Urgent
Denham,
Craig
Shallahamer explores this issue in a paper on www.orapub.comabout Response Time
Analysis.
In
essence, one way of calculating the no. of transactions can be from 'user
commits' + 'user rollbacks', but it appears
Henry, this is a great post. All I can add of peripheral
interest is a pointer to a book called Efficient Memory Programming
or something like that.
Absolutely the best presentation of CPU/cache dependencies i have seen.
Makes you really think about cache behavior, CPU architecture, and all
alter index schema.index_name rebuild new_tablespace.
You can create a script to move all of them as follows:
select 'alter index schema.'||index_name||' rebuild tablespace
NEW_TABLESPACE;'
from dba_indexes where owner='SCHEMA';
hth,
Ruth
- Original Message -
To: Multiple recipients of
Title: svrmgrl and W2k
OH MY GOSH this sucks.
Is anyone running 8.1.7 EE on W2k? I am trying to start the database (and the listener, for that matter) via Terminal Server and it keeps erring out with ORA-12560 protocol adapter error.
I look on Metalink and it just plain says, Go to the
Ken,
Why not generate the alter index {} rebuild tablespace {} commands using
sql,
break the resulting commands up into several different files, and run them
at the same time?
Probably the easiest (and fastest) way to go.
The generate script would be:
set head off
set pages 1000
spool
sangeetha,
1) If a tablespace is deleted all of the tables, indexes or rollback
segments that reside in that tablespace will also be deleted. Users are not
stored in a tablespace, except in the SYSTEM tablespace - which you DON'T
want to delete as it is the tablespace that runs the Oracle
Ken,
Try executing the following:
select 'I am rebuilding my index '||index_name||' and putting it in
another tablespace;'
from user_indexes
/
and of course, spool the sucker, set heading off, set pagesize.
Merry Spooling and Happy Selecting
[EMAIL PROTECTED] 11/27/01 08:25AM
I have this
I've never heard of a mass move index utility. What I did in a similar
situation is script it, with something like this:
SET head OFF feed ON echo OFF verify OFF pagesize 0 linesize 65 trimspool on
--
spool ind_fix.sql
--
select 'alter index '||index_name||' rebuild '
||CHR(10)||' tablespace
One of the fields is WAIT_TIME
A non-zero value is the session's last wait time.
A zero value means the session is currently waiting
What are the units associated with this number?
--
Charlie Mengler Maintenance Warehouse
[EMAIL PROTECTED]
You can't do it en-mass. Why not write a script to do this.
select 'alter index '||index_name||' rebuild new_tbsp;'
from user_indexes;
or somthing similar.
Terry
-Original Message-
Sent: Tuesday, November 27, 2001 8:25 AM
To: Multiple recipients of list ORACLE-L
I
Yes, I've seen it. Oracle Installation, sqlplus, svrmgrl through Terminal Server
Client do not work. I used PC Anywhere, everything went fine.
HTH,
Michael
From: Koivu, Lisa [EMAIL PROTECTED]
Subject: svrmgrl and W2k
Date: 27 Nov 01, 03:25 PM
To: Multiple recipients of list
no way that I know of, you need to move each index on its own
--- Ken Janusz [EMAIL PROTECTED] wrote:
I have this large DB (approx. 250 tables) that has the tables and
indexes in
the same tablespace (not my design). Is there a way I can move all
of the
indexes to a separate tablespace
sangeetha,
1. When a tablespace is deleted, the users do not get dropped. Users would
still be present. However, the tables created on the tablespace would be
dropped. Users and their details are maintained in Oracle dictionary. If
you have DBA permissions on your database, check the view,
maybe even moving the largest tables to their own
tablespace first.
Just remember that if you move a table, all its indexes will be invalid, so
you may want to rebuild the indexes for each table right after the table is
moved.
If you just move the indexes, only the index being moved is
Yeah, Iain, you are right, and I don't hate to recognize.
Iulian
-Original Message-
Sent: Tuesday, November 27, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L
I hate to disagree but why couldn't you
update x
set field = (select field1
from p
where
Dennis:
Thanks for the advice. Fortunately I am doing a DB conversion from IMS /
Lotus Notes to 8.1.7. This is being done on a dedicated server which only I
have access to and there is no application software connected to it. When I
finish the data conversion the data will be exported (for
http://www.amazon.com/exec/obidos/ASIN/0070388687/qid=1006878161/sr=1-2/ref=
sr_1_14_2/002-3320998-2702448
-Original Message-
Sent: Tuesday, November 27, 2001 10:33 AM
To: '[EMAIL PROTECTED]'
Henry, this is a great post. All I can add of peripheral
interest is a pointer to a book
ok, as much as i think MS could use a major kick in the fundament,
if you think of terminal server client as rsh client (please no
niggling
corrections of the rough analogy!:-) then you'll not be so vexed at
the lack of functionality.
Sad that this doesn't work, true, but...shrug...maybe in
What will you be wearing?
a short presentation?
h.
I think I detect a level III Shrek alert
-Original Message-
This is a cross-dressing post folks...
so...unfortunately, Susan McClain will not be able to attend OOW, and
it now seems I AM presenting (where the heck did I
Just a question off the wall here - kind of related:
Does anybody know why Oracle does NOT give the option to have a DEFAULT
INDEX TABLESPACE along with TEMPORARY and DEFAULT (for Tables for example)..
I know, I know it's just another thing to add to your syntax - but it would
be a FAR better
seconds.
see page 32 of Gaja's Oracle Performance Tuning 101
The value of this column is STATE dependent and is measured in
seconds
--
From: Charlie Mengler[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Tuesday, November 27, 2001 8:20 AM
To:
Charlie,
WAIT_TIME is measured in seconds. But in order for this to be so, you must
have the TIMED_STATISTICS parameter set to TRUE.
Dave
-Original Message-
Sent: Tuesday, November 27, 2001 9:20 AM
To: Multiple recipients of list ORACLE-L
One of the fields is WAIT_TIME
A
ControlIT (formally Remotely Possible) also works, regardless
of the fact its a CA product.
-Original Message-
Sent: Tuesday, November 27, 2001 8:25 AM
To: Multiple recipients of list ORACLE-L
Yes, I've seen it. Oracle Installation, sqlplus, svrmgrl through Terminal
Server Client do
Lisa,
Got bit by this first time out of the box with W2K. I don't have access to
PCAnywhere, so I had to do the install from the console. I have however
created a ton of .bat files that perform various functions that I can
execute from Terminal Services. I found it necessary to use sqlplus
with gas?
-Original Message-
snip
guess i'm just a big mean green DBA.;-)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohan, Ross
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
On Tue, 27 Nov 2001,Mohan, Ross scribbled on the wall in glitter crayon:
-
-What will you be wearing?
-
-a short presentation?
-
-h.
-
-I think I detect a level III Shrek alert
nope, working for a bankrupt company means i don't get to go nowhere or learn
nothing.
guess i'm just a big
On Tue, 27 Nov 2001,Mohan, Ross scribbled on the wall in glitter crayon:
-with gas?
nope, gas costs extra.;-)
-
--Original Message-
-From: Thater, William [mailto:[EMAIL PROTECTED]]
-
-snip
-
-guess i'm just a big mean green DBA.;-)
--
Bill Shrek Thater ORACLE DBA
Wonderful idea, Mark. We have scores of users who create their own tables,
indexes etc since we are a scientific research institution. It's hard to get
users to put in that extra code to place the index in it's own tablespace.
Shirley
-Original Message-
From: Mark Leith
Thanks Ross. By the way, did you ever get The Art of Computer Systems
Performance Analysis?
Henry
-Original Message-
Sent: Tuesday, November 27, 2001 11:25 AM
To: Multiple recipients of list ORACLE-L
http://www.amazon.com/exec/obidos/ASIN/0070388687/qid=1006878161/sr=1-2/ref=
Sorry for the delayed thanks... but things got hecked here.. Thank you
Michael Vergara and Brian...
On Fri, 9 Nov 2001, Brian McGraw wrote:
Funny, I wrote a perl script to do this same thing the other day. It is a
perl script, runs under UNIX, and not only checks for defaults, but the
Hello everyone,
I'm certain that this is a FAQ, but I thought I would make a request here.
I have a client whose management is requesting us to make a business case
for keeping our Oracle on UNIX rather than on NT.
I wonder if anyone can link to or provide any of the following on this
subject:
Mark Leith wrote:
Just a question off the wall here - kind of related:
Does anybody know why Oracle does NOT give the option to have a DEFAULT
INDEX TABLESPACE along with TEMPORARY and DEFAULT (for Tables for example)..
I know, I know it's just another thing to add to your syntax - but it
Hi
WHen I execute ps -ef |grep LOCAL on Solaris server the following output i
see in
1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
What is the diffrence between 1 and 2.
Thanks
Seema
Hi list people :)
We have a customer who has been running a particular delete statement
against a table for a while now, which usually ran within minutes. All of a
sudden this table has suddenly gone from a few minutes right up to 50! He
wants to diagnose why..
Where would you start?
I have a
Hi
If one of the tablespace in database is TRANSPORT TABLESPACE.I have full
export with consistent=y and full=y.
Can I full import the database?
If yes then what will happened with transport tablespace?
In case of crash can I restore full database with full export?
The assumption is we don't
Mark,
check for foreign key/missing index combinations. If the table is a parent
table, and it's child's foreign key's column is not indexed, the delete can
take *forever* if the child is a large table.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday,
Guys,
I'd appreciate any help that I could get.
I was trying to import to another tablespace, same user. I hadn't had a
need to do this in a while but thought this shouldn't be too difficult. So
I did what the manuals said:
ran a user export
set user's quota on old tablespace
To continue the discussion on getting together at Openworld:
How about Tuesday evening, around 7:00?
Someone who knows downtown SF want to suggest a place? My preference
is not too loud or too smoky.
Call out on the list if you are going to come, so we can keep track of
how many chairs to
Title: RE: Connection question?
1. User connect to Oracle through Unix (for example telnet and then SQLPlus from Unix).
2. Client user.
HTH,
Rivaldi
-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 12:05 PM
To: Multiple recipients of
Paul - What is the base of experience in this shop? Is it primarily an NT
shop and the Unix system is the odd one, or is it primarily a Unix shop and
the NT conversion would be a first plunge? Everything I hear depends
primarily on this factor. Most indications are that the Unix systems tend to
Actually, Dennis, it's currently a UNIX shop considering saving money by
migrating to NT. It seems like your argument would support sticking with
what they currently have.
Thanks,
Paul
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November
Eric, are you going?
-Original Message-
Sent: Tuesday, November 27, 2001 2:45 PM
To: Multiple recipients of list ORACLE-L
To continue the discussion on getting together at Openworld:
How about Tuesday evening, around 7:00?
Someone who knows downtown SF want to suggest a place? My
Mark Leith wrote:
Hi list people :)
We have a customer who has been running a particular delete statement
against a table for a while now, which usually ran within minutes. All of a
sudden this table has suddenly gone from a few minutes right up to 50! He
wants to diagnose why..
Where
Hi
Is there any easy way for our operator to check db status on NT env. any
clue?
Mitchell
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mitchell
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
Paul,
If they want to save $$$ they could consider migrating to LINUX. For a
UNIX shop it is a more logical migration than NT/2000. Or, is their
idea to get rid of higher priced SA's in favor of NT
Admins which they think they should pay less? In which case the outcome
is decided all ready.
Title: Terminal Server / svrmgrl
ZP? As in Zip It?
Just really really frustrating.
Thanks Ross and Michael
Lisa
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 11:51 AM
To: Multiple recipients of list ORACLE-L
Subject: RE:
George Hofilena wrote:
Guys,
I'd appreciate any help that I could get.
I was trying to import to another tablespace, same user. I hadn't had a
need to do this in a while but thought this shouldn't be too difficult. So
I did what the manuals said:
ran a user export
Hi Listers,
How can we revoke 'delete privilege' from the schema owner of the table and
also from DBA ?
If it is not possible, can we set through trigger ?
Thanks.
Aldi
_
Get your FREE download of MSN Explorer at
Also check for a delete trigger on the table.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
[EMAIL PROTECTED]
The idea is wonderful and also very old. It was one of the first enhancement requests
submitted. As far as I can tell Oracle has never shown an interest in it. Indeed it
appears to be going the other way. Take LOB's for instance. You can place the LOB
segment in a separate tablespace from
Title: RE: Connection question?
One is LOCAL=YES and one is LOCAL=NO
One is Local, one isn't.
Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 1:05 PM
To:
I thought that, given
disks with 256KB to 4M of ondisk cache
and
disk arrays with another 1M-16M of cache
and
storage boxes like EMC,Hitachi, etc with up to 16 GB of CACHE
and
the UBC
and
the Oracle BC
and
Henry Poras' recent post
that
tables and indexes in the same tspace didn't matter quite
Chevy's at Howard and 3rd is a good spot. I'll probably be attending only
the vendor exhibits but I'll try to make the list get-together.
Gerardo
-Original Message-
Sent: Tuesday, November 27, 2001 11:45 AM
To: Multiple recipients of list ORACLE-L
To continue the discussion on
Paul,
I think Dennis makes a great point here. If your organization thinks that
they can save money by switching hardware, you should point out that all of
the Unix admins will need NT Admin classes as part of the migration to the
new environment.
As I've said in the past, a well-maintained
If they're currently a unix shop and want to save money, why not suggest
Linux? It will run on the same hardware as Windows, and they can
leverage their existing unix experience.
Dennis
Paul Vallee wrote:
Actually, Dennis, it's currently a UNIX shop considering saving money by
migrating
Listers,
Does anyone have a script that will do the following:
Accept
user input for old data value
Accept
user input for new data value
Disable
table constraint
Update
record with new data value
Enable
constraint
A script like this would help
Title: RE: SVRMGRL and W2K
Thanks David!!
Lisa
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 12:10 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: SVRMGRL and W2K
Lisa,
Got bit by this first time out of the box
Paul - then I would check for a paper from a Unix vendor that discusses
total cost of ownership. A good place to start might be the Sun Web site
since Sun is the major Unix vendor that doesn't offer NT systems. Start
looking at the cost of downtime for your organization. Then there is the
cost of
You can't revoke the ability to delete from the schema owner. You
could revoke CREATE SESSION from the schema owner, but that doesn't
solve the problem of DBA-privileged accounts being able to delete.
I'm guessing that this is a perfect opportunity to use an INSTEAD OF
trigger.
--- Aldi Barco
Title: svrmgrl and W2k
Lisa,
I'm
running 8.1.6 and 8.1.7 EE on Win2k machines and I connect to them all the time
via Terminal Server. I get the same ORA-12560, but I just invoke svrmgrl
using internal@test or internal@dev. Works just fine.Am I
missing part of the problem?
Jack
Title: RE: Delete slowing..
Mark, how many indexes are on the table? Are there any unindexed foreign keys?
Lisa Koivu
Oracle Database Monkey Mama.
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Mark Leith [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001
The default tablespace is only used whenever there is no tablesapce
parameter in the crate and alter table/index statements. Since the export
always have tablespace parameter with the create table/index statement, your
import method definitely will fail. You can change the tablespace for the
set what, precisely, through a trigger?
Geez, if you have a DBA and/or a schema owner that can't/shouldn't be
deleting from a table, what you have is NOT a database problem, it's
an HR problem.
sheesh.
yea, how about this? an BEFORE DELETE trigger on the table, saving and
repopulating each
Where can I get a copy of
Scaling Oracle 8i please
It's a book.
--
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, California-- Public
sqlldr is not a sqlplus command - it needs to be called
from the OS command line.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 27, 2001 5:00 PM
I am in sql*plus (8.1.7) logged in as sys. When I try running sqlldr at
the
hey lisa
Thats what i was temted to reply as well {lol} .. but
if you look closely .. both her conn are bequeth .. i
was under the impression that bequeth was used only
for local and not remote .. thats why we chose beq
over tcp for db's that resided in same box for
performance reasons .. or so
Title: RE: Checking DB Status in NT env.
Yea. Connect to the database. If you can connect quickly, you can be sure that most everything is OK.
Lisa Koivu
Oracle Database Monkey Mama with the Big Wide Booty.
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: mitchell
hi
friends if anyone knows about the unzip command in solaris 2.6/2.7 .please mail
me.ex.OEM204_1.zip file.and i am not getting unzip command by using man pages.can i
needed to down load any unzip file.
pl. mail command as early
thanking to all
--
Please see the official ORACLE-L
All the objects are dropped beforehand. The import is done on a clean
slate. I just put in the ignore=y because that's what the docs suggested
and I was half hoping it'll drive the space quota exceeded... error away
:)
George
-Original Message-
Sent: Tuesday, November 27, 2001 12:30
You just open up with:
This is statspack. You install it with spcreate,
collect stats with a pl/sql call, and report with
spreport.sql. Then you interpret the myriad the
results - but of course, that is a tuning discussion
not a statspack one...Questions anyone?
:-)
--- Rachel Carmichael
I am in sql*plus (8.1.7) logged in as sys. When I try running sqlldr at
the command prompt I get this error:
SP2-0042: unknown command sqlldr - rest of line ignored.
I'm calling it from my client PC and the DB is located on a separate server.
How do I get this to work?
--
Please see the
Thanks for all your input - I'll be following up on this tomorrow morning,
and will let you all know..
Cheers
Mark
-Original Message-
Sent: 27 November 2001 20:45
To: Multiple recipients of list ORACLE-L
Also check for a delete trigger on the table.
Ron Thomas
Hypercom, Inc
[EMAIL
But of course a delete trigger is not called on a truncate...
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
MohanR@STARS-
Sounds like some inverted thinking by management... justify not making the
change(?). Usually you would have a cost-based analysis for making the
change. I've never seen one that would justify NT (I'd love to see it if
they have one). Both Solaris and Linux are alternatives to the OS-specific
At 02:10 PM 11/27/2001 -0800, you wrote:
hi
friends if anyone knows about the unzip command in solaris 2.6/2.7
not sure about 2.6 but in 2.7 just:
unzip filename
.please mail me.ex.OEM204_1.zip file.and i am not getting unzip
command by using man pages.can i needed to down load any
Hi Ken,
SQlldr is not a sqlplus command. It will need to be run from the OS
like sqlplus.
Good Luck
[EMAIL PROTECTED] wrote:
I am in sql*plus (8.1.7) logged in as sys. When I try running sqlldr at
the command prompt I get this error:
SP2-0042: unknown command sqlldr - rest of line
Actually, you can. Use FGAC (Fine-Grained Access Control) and you can put a
Policy in place on a table that even the table owner can't bypass - even
System can't bypass. Only Sys can bypass FGAC policies - and the owner of
the security schema in which you place the Policy functions.
I've used
Ken,
Sqlldr is a stanalone utility, it doesn't run from inside SQL*Plus, it runs
from the
OS command line.
Take a look at the utilities manual for the docs on sqlldr.
Jared
1 - 100 of 113 matches
Mail list logo