Exactly.
I for one am not happy and resent being labelled as
helpful or useful...
I got into the DBA business to cause carnage, misery
and suffering, not to make people happy!
:-)
Cheers
Connor
--- Johnson, Michael
[EMAIL PROTECTED] wrote: Are you
sure you want to go down this road and get
pdml on non-partitioned tables is there in 9i
hth
connor
--- Deshpande, Kirti [EMAIL PROTECTED]
wrote: How true !! I just ignored the 'writing' part
of the
parallelized 'reading'. Sorry.
Thanks for catching it, Waleed.
Our own update process, that I am baby sitting, was
on my mind that
We've recently upgraded many client machines to WinXP and found that the only way we
can get the 9i client to connect to the server is if the windows user account is an
administrator on the client machine. We've tried giving full access to the c:\oracle
and c:\program files\oracle directories
And that was 9iR2, right (I'm on 8.1.7 in real life)? The docs are rather
amusing. From the 9iR2 documentation the New Features doc says You can now
use parallel DML on nonpartitioned tables. This wasn't mentioned in the
9iR1 new features doc. And then the DW Guide for 9iR2 says Tables must be
Title: BackupExec & Oracle
We use
NetBackup, it works well.
;)
Regards,
Patrice Boivin Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et
Exploit. des systèmes Technology
Services | Services
technologiques Informatics
Branch | Direction de
l'informatique
My comment is:
Marketing based on false information can destroy people's lives.
Can you imagine a clerk who decides to pay thousands of dollars to take
computer courses, only to discover they can't do it, will go through?
Wouldn't that turn their lives into a living Hell?
Regards,
Patrice
Sure. The original post mentioned 8.1.7.2!
- Kirti
-Original Message-
Sent: Tuesday, November 26, 2002 3:29 AM
To: Multiple recipients of list ORACLE-L
pdml on non-partitioned tables is there in 9i
hth
connor
--- Deshpande, Kirti [EMAIL PROTECTED]
wrote: How true !! I just ignored
Rachel,
I have saved over 2000 messages, from various posters, in my Oracle-l (oratips)
folder, going back to 1998. And I still scan that folder before I go to Metalink (we
still run 7.3 in production ;)
When it comes to Oracle, I think I have learned a lot from people on this list. They
Robert,
Well I'll start you off on the other end. If it's got my name on it, trash
it.
Dick Goulet
Reply Separator
Author: Freeman; Robert [EMAIL PROTECTED]
Date: 11/25/2002 2:04 PM
Board -
If you had to choose the 10 top posters here at
you can use the copy command for the longs - but I don't think it
works for long raws - write a pl/sql that pulls it in in 32k chunks or create
temp tables with the pk and long raw and do the insert/update
routine. [EMAIL PROTECTED] 11/25/02 09:59AM
OK, so
you can't CTAS on tables with
On Tuesday 26 November 2002 03:53, Boivin, Patrice J wrote:
Can you imagine a clerk who decides to pay thousands of dollars to take
computer courses, only to discover they can't do it, will go through?
Wouldn't that turn their lives into a living Hell?
Of course, that would be the goal of
i need your advise with this one as i am trying to delete a
database via the configuration Assistant tool. (deleting because of
i had problems with this database as its control files were
missing).
so should i go ahead and delete the service, because most likely
none of the files would be
Ditto! Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, November 25, 2002 9:59 AM
Good to hear from you Lisa!! Welcome Back!!
-Original Message-
Sent: Monday, November 25, 2002 7:49 AM
To: Multiple recipients of list ORACLE-L
Title: BackupExec & Oracle
We use BackupExec for remote sites.
We installed the agent on the database server and
configure the backup jobs from the BackupExec menus and all is well. We did a
test yesterday and restored a database to a new computer and all works
fine.
When restoring to the
Hmm, Roland???
:-)
JP
Reply Separator
Author: Freeman; Robert [EMAIL PROTECTED]
Date: 11/25/2002 2:04 PM
Board -
If you had to choose the 10 top posters here at Oracle-L who provided the
biggest input and
knowledge, who would they be? Who
Oracle 9i installation on Solaris being attempted
# xhost +
Message - unable to open display :
export DISPLAY=PC Client IP address:0.0
# xhost +
Xlib : connection to client refused PC Client IP Address
Xlib : cannot set display to PC Client IP Address
NOTE - Installation being initiated from
If I may offer another view
-Original Message-
Having multiple redo log members has its advantages. The
archiver process 'knows' these multiple members and it will
optimize the archiving process,
Is there any supporting documentation about this optimizing? Are you
saying
Rachel,
As I told Ian, this isn't an effort to run a popularity poll. I have an
URGENT need to quickly cull down 20,000 messages to a reasonable number and
store them on CD. I needed some criteria and this seemed the most logical.
This newsgroup is a great resource, and I should hate to loose the
I believe that we solved this by specifically giving access to the registry key
[ORACLE] to the Users on the machine that required it. The administrator that helped
us with this isn't in today, so I can't be totally sure. If I track down his write-up
I'll post it.
Keith H.
-Original
Read the post Ian, this isn't a popularity poll, I have no interest in
those. I *HAVE* to cull out my mail box for certain reasons I can't discuss
at the *moment*. I offered to provide a summary of the results if the group
was interested, but that's not the purpose.
The truth of the matter is
Ping yourself and find out what your IP address is (or run netstat, etc)
say your IP is 122.33.22.126
now, on the server window type in:
export DISPLAY=122.33.22.126:0.0
Then, you need to make sure you are able to run an X session, so find xclock
and run it.
If you get a clock up in your X
Go an X Server running on your PC ?
Is the UNIX box behind a firewall, need to open up ports ?
Need to add in any routes on the server ?
-Original Message-
Sent: 26 November 2002 14:39
To: Multiple recipients of list ORACLE-L
Oracle 9i installation on Solaris being attempted
# xhost +
Pending further evidence to the contrary, I'll take mirroring external to
Oracle as the better choice.
Redo and archived redo logs are the most important files in the database.
Lose a datafile? You can still recover the database.
Lose all controlfiles? They can be recreated.
Lose a single redo
Try executing the xhost command as root first. Then you should be able to
execute xhost + command.
Nancy
-Original Message-
VIVEK_SHARMA
Sent: Tuesday, November 26, 2002 8:39 AM
To: Multiple recipients of list ORACLE-L
Oracle 9i installation on Solaris being attempted
# xhost +
Connor,
You positively make me miserable then...
Feel better?
It was good meeting you at OOW by the way. See you at UKOUG.
:-))
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!
Londo
Hi,
you'll need to be signed in as root in order to run the xhost + command.
The rest of that looks fine so :
as root :
xhost +
as oracle_user :
export DISPLAY=PC Client IP address:0.0
xclock(to test yopur X config)
NB Exceed has its own array of bugs when used with the Oracle
Thanks all for the suggestions. I think I'll take a look at COPY and the
PL/SQL options since I've used them before, and C Perl are not in my
repertoire, I'm ashamed to say ;) To shed a little more light on the
requirement, I'm researching the best (subjective) way to convert
Addressing the corruption issue, Kirti's statement is not speculation. Because my
OS/hardware IS reliable a corrupted log file that is mirrored outside of Oracle will
be corrupt - the original is corrupt, so is the mirror. If I mirror my log files
using Oracle, logfile A may be corrupt, but
on the client pc:
Right click exceed - tools - configuration - security - host access
control list
I use file: click edit and add the ip address to let the db server
connect to the x-server on your pc.
-Original Message-
From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
It's nice to know they have it now. I have one database on 9.2.0.2 but the
optimizer feature enable parameter is still on 8.1.7. We trying to reduce
the amount of work needed to downgrade in case we have to.
There are many problems we are working with Oracle to resolve.
Still my point is
LOL. But it gives one an insight into why End Users Without A Clue seem to
think that if they just yell a little louder into the phone then the
gibberish that they're speaking will start to make sense to me.
Just wondering... what about the archive for this list?
Doesn't that include the info you want to store on CD?
(call me clueless, I have over 1700 e-mails in my DBA Listserv folder).
Pat.
-Original Message-
Sent: Tuesday, November 26, 2002 11:29 AM
To: Multiple recipients of list
You're saving all my fly-fishing emails, right?
Man, I wish I was popular.
--Walt Weaver
Bozeman, Montana
-Original Message-
Sent: Tuesday, November 26, 2002 8:29 AM
To: Multiple recipients of list ORACLE-L
Rachel,
As I told Ian, this isn't an effort to run a popularity poll. I
Sure...
What I posted came from my discussions with others and from various resources on
Metalink and from Oracle Training Classes. Note #45042.1 titled Archiver Best
Practices summarizes it all.
Agreed, that RAID and disk technologies have improved over the years, however, I would
still
Hmmm
I do not seem to qualify as an alien,
extra-terrestrial or otherwise, and I never heard from
them after I sent a resume'.
--- Joe Testa [EMAIL PROTECTED] wrote:
It could have been because they were aliens(either
the non-US citizen
type or the outer space kind, since neither need
Well then, be sure to keep all posts from Dave Farnsworth, he's a freaking genius. ;o)
-Original Message-
Sent: Tuesday, November 26, 2002 9:24 AM
To: Multiple recipients of list ORACLE-L
Read the post Ian, this isn't a popularity poll, I have no interest in
those. I *HAVE* to cull out
I think the problem is the client. Does it have an xauth setting somewhere?
-Original Message-
Oracle 9i installation on Solaris being attempted
# xhost +
Message - unable to open display :
export DISPLAY=PC Client IP address:0.0
# xhost +
Xlib : connection to client refused
Interesting. I went to the local 2 year tech school to obtain my prominent
A.D. in Data Processing. Out of the 130 or so in my class, only about half
graduated. Most of the dropouts freaked when they got the rude awakening
that real business computer work (at the time) was the likes of assembly
MBRC stands for what ?
-Original Message-
Sent: Tuesday, November 26, 2002 9:29 PM
To: Multiple recipients of list ORACLE-L
It's nice to know they have it now. I have one database on 9.2.0.2 but the
optimizer feature enable parameter is still on 8.1.7. We trying to reduce
the amount of
Also stand by that corrupted write will be restricted to just the affected member
Hence one can simply overwrite the BAD (Corrupted) member with the Good one
-Original Message-
Sent: Tuesday, November 26, 2002 9:40 PM
To: Multiple recipients of list ORACLE-L
Sure...
What I posted
No one uses 9i Lite? Gurus, help me out!!!
Saira
-Original Message-
Somani
Sent: November 25, 2002 10:49 AM
To: Multiple recipients of list ORACLE-L
I wonder if there are any mailing lists out there for Oracle 9i Lite. Or
for that matter, if any of you have used in the past or are using
How may LONG , LON RAW be Converted to CLOB or LOB ?
Which is Better ?
Thanks
-Original Message-
Sent: Tuesday, November 26, 2002 9:24 PM
To: Multiple recipients of list ORACLE-L
Thanks all for the suggestions. I think I'll take a look at COPY and the
PL/SQL options since I've used
Thanks Jared, thats not what I see. I have 20 rollback segments, and at no
point in time, there were more than
4 transactions in the rollback segments. In fact, I happened to see it a
couple of minutes ago.
select usn, xacts from v$rollstat showed me 0 in 19 rollback segments, and
2 in one of
Mike,
Not necessarily.
It depends on who started the Xsession.
I regularly run 'xhost' on my workstation as a non-root user.
Root is unable to do so on the same machine.
Jared
Hately, Mike (NESL-IT) [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/26/2002 07:54 AM
Please respond to
'xhost +' is terribly insecure.
'xhost client_machine' would be better.
Jared
Nancy McCormick [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/26/2002 07:59 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Ah, I missed that it was SAP.
Yeah, they don't like you mucking about with their schema.
I would like to see their cluster/pools go *away*!
They are a major pain at times.
Jared
Hand, Michael T [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/26/2002 07:54 AM
Please respond to ORACLE-L
Ditto.
The biggest problem with non-Oracle-mirrored redo log is
a personnel issue.
Take it from someone who's experienced a SA deleting all
files from a 500 Gig DW during the middle of the day.
Jared
Fink, Dan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/26/2002 08:04 AM
Please
Well, I give MicroSlop pretty poor grades for predicting the future and
Monster.com is absolutely useless (naw make that less than) at job stuff in
general. I will agree with the person who wrote the article on one point. The
job of being a DBA is changing and we all need to remain flexible to
We are on 9.2.0.2, Solaris 8 on Sunfire 3800 with 16 GB memory and 128 MB
on a hardware-controlled, mirrored RAID5 StorEdge T-3 Array.
Periodically throughout the day the LGWR background process clocks 20+
minutes of CPU time while actual CPU usage is quite low. I ran a statspack
report and
LONG's maybe converted to LOB's via the TO_LOB SQL function.
There are strict limitations on this function: it can only be used in
the SELECT subquery of an INSERT statement.
e.g INSERT INTO lob_table
SELECT n, TO_LOB(long_col) FROM long_table;
As to which is better, LONG columns will
There are times that I do not have access to a network connection, so a
traveling CD would be good.
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!
Londo Mollari: Ah, arrogance and
multiblock_read_count as in db_file_multiblock_read_count.
- Kirti
-Original Message-
Sent: Tuesday, November 26, 2002 11:24 AM
To: Multiple recipients of list ORACLE-L
MBRC stands for what ?
-Original Message-
Sent: Tuesday, November 26, 2002 9:29 PM
To: Multiple recipients
Hey Jonathon,
Two questions about your response:
1) Yes, you are obviously correct. My test was flawed. So, if NULLs use
no space, then why does many NULL rows cause a table to extend? Is it
because of the row directory in the data block header? Egad...going back to
DBA school here. blush
And everything I've learned about single malts, I've learned from this list.
And save in my Teetotaller folder ;)
-Original Message-
You're saving all my fly-fishing emails, right?
Man, I wish I was popular.
--Walt Weaver
Bozeman, Montana
+**+
This transmission is intended
U can use To_LOB(long_col) to convert long to
Clob/BLOB.
OraCop
--- VIVEK_SHARMA [EMAIL PROTECTED] wrote:
How may LONG , LON RAW be Converted to CLOB or LOB ?
Which is Better ?
Thanks
-Original Message-
Sent: Tuesday, November 26, 2002 9:24 PM
To: Multiple recipients of
Sorry I missed 2nd part of Ur question.
LOB is not a datatype it self. LOB = Long Object.
Oracle provides 2 kind of LOBs. CLOB and BLOB
If U want to store Binary data, eg pdf files, movies,
sound files, etc, use BLOB(Binary long Object).
For other U can use CLOB.
OraCOp.
--- VIVEK_SHARMA
Raj,
You're assuming that the transactions are lasting long enough
for you to catch them in the rollback segments.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/26/2002 09:42 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Saira Ji,
I never heard of any Oracle lite list/Group. But
When ever U encounter an issue with Oracle Lite, U may
post it here and we can try to help U out.
Thanks.
OraCop.
--- Saira Somani [EMAIL PROTECTED] wrote:
No one uses 9i Lite? Gurus, help me out!!!
Saira
-Original
Deborah,
First, don't remove Oracle's RedoLog duplexing, you may regret about it
later (see recent thread on this issue).
Second, if what you are telling (logs are about 100 MB in 2 groups of 20
members each) is accurate, then this is your main problem. If you have
your log switches on avg 2.5
Hello everybody,
I have the following query that runs every week.
UPDATE tmp_brian_metareward1 tmp
SET offers_seen = (SELECT count(f.fastcash_id) FROM
metareward.fastcash f
WHERE f.subsite_id = tmp.subsite_id
and attempt =
I was going to let the differences of opinion stand, but I suppose this
requires an answer.
-Original Message-
Redo and archived redo logs are the most important files in
the database.
Lose a datafile? You can still recover the database.
Lose all controlfiles? They can be
Larry,
What I found was the explain plan in 9iR2 will tell you if the DML is getting
parallelized.
Here is what I see:
SQL alter session enable parallel dml;
Session altered.
SQL explain plan for
2 update /*+ parallel (KED, 4) */ KED
3 set secondary = 'X';
Explained.
SQL
John,
Didn't I just complete quite a number of emails on this very issue? I hoped
those resolved it.
Anyway, the assistant can't start the database; so it can't determine the
datafiles that made up the database. You would say Yes to delete the service
anyway and look for the datafiles yourself,
Saira - I agree with OraCop, just ask questions here. My assumption is that
there are few differences between Oracle Lite and other Oracle versions. I
think it is based on the same Oracle code, with a few features removed. Here
is the note from the FAQ for this list:
Well, there's Schlitz, King Cobra, Olde English, Mickey's Big Mouth, et al.
Single Malt Liquor at its finest!
Scott Shafer
San Antonio, TX
210.581.6217
-Original Message-
From: Hand, Michael T [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 12:17 PM
To: Multiple
So what is discussed in this paper is outdated alreadyuh!
www.sun.com/blueprints/0101/SunOracle.pdf Gosh, time flies ;) Pages 13-14 talk about
Oracle Redo Logs.
As a first attempt, I would consider reducing the number of log members (from 20 to 4,
or even 3) than removing them
Saira - One other point. When you submit a message, it would be a really
good idea to mention that you are using Oracle9i Lite.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, November 26, 2002 1:19 PM
To: '[EMAIL PROTECTED]'
Saira - I agree with
In some of our benchmarks with our hybrid application on Oracle 8.1.7 , Oversizing
session_cached_cursors would HARM performance greatly . Our Optimal Value is 50
-Original Message-
Sent: Wednesday, November 27, 2002 12:20 AM
To: Multiple recipients of list ORACLE-L
Deborah,
First,
Is there an easy query to get a list of tables that don't have any primary
key?
I've tried a couple of different ones, but none of them work quite right.
Seems like this should be easy.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike Sardin
INET: [EMAIL
Exactly. A guy might have to poll V$ROLLSTAT 100+ times per second to
see the allocations happening on a system with well-designed
transactions. You just can't do that with SQL.
Raj, you *can* test the behavior by using some artificially *bad*
transactions. On a quiescent system (nothing else
Interesting; but would the specific performance affect of a high number of
session_cached_cursors involve the LGWR process?
At 11:25 AM 11/26/2002 -0800, you wrote:
In some of our benchmarks with our hybrid application on Oracle 8.1.7 ,
Oversizing session_cached_cursors would HARM performance
Title: RE: SQL tuning help
Sergei,
How many records in each table? What indexes are in these tables? What version of Oracle?
What do you mean by 'began to hang'?
I'd try making the attempts in the WHERE clause into a Between. I'd also try grouping by f.subsite_id.
You could always
You do have to be careful in version 9, though,
since the really is an MBRC - which is the
system stat which is the average size of
multi block read count actually achieved over
a time period, rather than the value requested
in the db_file_multiblock_read_count parameter.
(The real MBRC is used
Schlitz gives me the Blatz. (But Blatz gives me the Schlitz)
And most beers, even watered down American lagers (like malt liquors), use
multiple types of grains in their malts.
Olde English 800???!?? In the words of the immortal Don Martin, Blech!.
And where's the venerable Colt 45?
Of
At 10:50 AM 11/26/2002 -0800, you wrote:
Second, if what you are telling (logs are about 100 MB in 2 groups of 20
members each) is accurate, then this is your main problem. If you have
your log switches on avg 2.5 per day, change your RedoLog configuration snip
You will have more log switches
Point (1)
As Larry Elkins pointed out to me in an offline post,
I had forgotten to highlight the fact that even null CHAR
columns do still use a length byte (unless they are
trailing nulls - i.e. there are no following non-null columns).
Apart from this, a row still needs:
two byte entry in
Stephen,
Nothing is gained by personal attacks in this forum. This forum is
intended to be a learning experience for all (myself included). I suggest
that you review the archived list and examine the quality of posts by Kirti,
Jared, et.al. They speak for themselves.
BTW, 2 + 2
And everything I've learned about single malts, I've learned from this
list.
And save in my Teetotaller folder ;)
This post is not near off topic enough...please forward this folder
Steve McClure
-Original Message-
Michael T
Sent: Tuesday, November 26, 2002 10:17 AM
To: Multiple
I don't think changing the logmembers will do much good - I
have a v880 with 16 GB and a Hitachi san. I have only 3 logmembers - 4
groups, they are on the local drive. I have some kind of performance issue with
periodic slowdowns (47 minutes lgwr cpu in one day on a very low transaction
I am doing the ORACLE 9iR2 database test and tried to export form a 8i
computer to 9iR2 server. I got ORA-01031: insufficient privileges.
my export parfile on 8i server is:
userid='sys/passwd1@db92 as sysdba'
file=/tmp/exp_db8i_full.dmp
buffer=6400
compress=n
grants=y
indexes=y
rows=y
Precisely why I name all Oracle files with .dbf extension. Who ever
thought naming a redo log with .log was a good idea??? With all DB files
the same, it's a simple rule: Don't touch .dbf files. No confusion there.
If you need to mess with them (backups, etc), write and test a script. Try
to
I did read your post. I stated you were taking a poll, the popularity
characterization is no where to be found in my message. Nor is there any implication
in my post that you were running a beauty contest. Perhaps my choice of the word
important instead of useful or informative was what
Debi,
A log file sync event usually indicates that the application is probably
committing too often, and LGWR cannot keep pace with it. You might be
experiencing contention or I/O issues, on the disks where the redo log
files are placed. Moving your redo log files away from RAID 5 is a step in
Hi Dennis,
This is a completely separate product, it is designed for mobile devices
like pda's etc.
Regards,
John
DENNIS WILLIAMS wrote:
Saira - I agree with OraCop, just ask questions here. My assumption is that
there are few differences between Oracle Lite and other Oracle versions. I
think
Thanks for this paper--I will share it with our Sun engineer.
BTW, to clarify, I have 20 redo groups with 2 members each...I think I'm
saying it right:
LOGFILE Group 1 ('/disk1/log01.log',
'/disk2/log01.log') size 100M,
Group 2 ('/disk1/log02.log',
Sergei,
When the query is running try to collect some stats, especially session
waits, from v$session_wait and see where the waits are happening.
Or you could do this from command line
alter session set event '10046 trace name context forever, level 8';
your query
alter session set event
Mike,
How about:
select table_name from user_tables a
where not exists(select 1 from user_constraints b
where a.table_name = b.table_name
and b.constraint_type = 'P');
Constraint_type values are:
P = Primary Key
C = Check Constraint
R =
select owner, table_name from dba_tables where (owner, table_name) not in
(select owner, table_name from dba_constraints where constraint_type = 'P');
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday,
SQL select table_name
2 from dba_tables
3 minus
4 select table_name
5 from dba_constraints
6 where constraint_type = 'R';
This should work (does in my 8.1.7 test db).
What methods have you tried? and what was not working?
-Original Message-
Sent: Tuesday, November 26,
select owner, table_name from dba_tables where not exists (select 'a'
from dba_constraints where constraint_type = 'P'
and owner = dba_tables.owner and table_name = dba_tables.table_name)
order by owner, table_name;
Mike Sardina wrote:
Is there an easy query to get a list of tables that don't
I thought Oracle lite is a different code base from Oracle PE, SE, EE.
So it's very different.
-Original Message-
Sent: Tuesday, November 26, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L
Saira - I agree with OraCop, just ask questions here. My assumption is that
there are few
Title: RE: Primary Key Constraints
SELECT owner, table_name
FROM DBA_TABLES t
WHERE NOT EXISTS
(SELECT 'X'
FROM DBA_CONSTRAINTS c
WHERE c.owner = t.owner
AND c.table_name = t.table_name
AND c.constraint_type = 'P')
ORDER BY 1,2
Take off the ORDER BY to speed things up.
Hey guys, in the name of all the persons (me too) who
are not experts, genius, gurus, etc... Can we stop
this useless discussion? I mean, the one that wants,
just answer to Robert and let's to the rest of us to
continue learning Oracle!
Just a comment ;-)
Gabriel
--- MacGregor, Ian A. [EMAIL
select owner, table_name from all_tables A where not exists
(select owner, table_name from all_constraints B where b.owner=A.owner and
b.table_name=A.table_name
and b.constraint_type='P')
That ought to do it. Cheers :
Ferenc Mantfeld
-Original Message-
From: Mike Sardina
how about select table_name from user_tables where table_name not
in (select table_name from user_constraints where constraint_type =
'P'); [EMAIL PROTECTED] 11/26/02 01:25PM
Is there an easy query to get a list of tables that don't have
any primarykey? I've tried a couple of different ones,
1) In a few trials on 8K blocks, I've been able to get a maximum 662 rows of
CHAR(1) (and CHAR(2) and CHAR(4))populated with spaces in a single block.
As these weren't exactly scientific, I don't remember if I had kept PCTFREE
at 2 thru my trials. Is this info documented somewhere? The only
These are out of left field, but have bit me in the past. Take with a big
ol' grain of salt.
Is the application issuing a 'COMMIT' after each 'SELECT'? This will cause a
commit entry to be written to the log buffer and the buffer to be flushed.
It could explain why LGWR is consuming time and not
I need to document a number of Oracle environments for a client. I think
that this is similar in scope to what Oracle Consulting calls an Operational
Readiness Assessment. Has anyone on the list been through this sort of
exercise? Can anyone share any documents that would be appropriate for this?
1 - 100 of 166 matches
Mail list logo
