Hi lists
while doing export import, often I need to check whether the target
table has any excess columns or does the column have different
datatypes/sizes from source table.
as our tables have many columns it has become tedious to check every
time.
can anybody post me any sql or pl/sql
Hi!
It seems it is explained here
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a76939/adg10pck.htm#6142
excerpt:
PL/SQL lets you overload packaged (but not stand-alone) functions. You can
use the same name for different functions if their formal parameters
srinivas,
The following is a script to compare two schemas. If you don't want to go
the whole hog, edit the script - but it may help you in full at some other
time.
col table_name format a30
col column_nameformat a30
col medph2_format format a30
col med_test_format
Thanks for all the serious and amusing replies on this, superb stuff!!
Seriously, I raised this question just to cover my back so when I give my
answer (the answer being NO!!) then no other bright spark can justifiably
contradict it.
Thanks again for your time,
Dave Leach
Where it goes the listener, you add the parameter
queuesize=XXX. Fe:
listener=(address=
(protocol=tcp)
(host=192.168.11.71)
(port=2641)
(queuesize=20)
)
Regards.
--- Dash, Saroj (CAP,CEF)
[EMAIL PROTECTED] wrote:
How to
In a solaris 2.6 unix machine Database is started and shutdown properly
through svrmgrl.
But when I rebot the machine I will start the database manually and listener
start also manually.
Please tell me how to do automatic startup the database and listener.
I tried to chnage in oratab file
I have no direct experience of this on Oracle, but I do know that
trusted operating systems make it possible to prevent the sysadmin from
reading files. They can be backed up to tape and restored, but they
couldn't be opened by a regular process such as a text editor without
the operating system
Kevin,
My advice would be to type:
C:\format c:\
Then install Win2K from the outset! The install is painless, and the O/S is
a HELL of a lot more stable. Don't bother upgrading from 98 - 2000, as you
*can* get software driver problems etc.
Now I also know (like me) you're a gamer, (is this
9i for sure...
Lets face it - in 2 months time, a nice little alert
will pop out on Metalink telling us how support on
8.1.7.2 is on the way out, and all customers are
requested to upgade to 9 as they do with all the
old releases...
Connor
--- Christopher Spence [EMAIL PROTECTED] wrote:
I am
Thanks Christian Trassens .
Regards,
Saroj.
-Original Message-
Sent: Friday, August 24, 2001 PM 07:11
To: Multiple recipients of list ORACLE-L
Where it goes the listener, you add the parameter
queuesize=XXX. Fe:
listener=(address=
(protocol=tcp)
Hi lists
have any body come across, decreasing db_block_size.
we know that the db_block_size can be increased.
to do this, usual way is export full db. create new db with new
increased db_block_size and import the data into it.
will this work for decrease db_block_size.
my present size is 8
breako ut the documentation for your platform(ie: solaris), there used
to be a section on how to setup the automatic startup/shutdown, you'll
need root to setup the init.d pieces/parts.
joe
Dash, Saroj (CAP,CEF) wrote:
In a solaris 2.6 unix machine Database is started and shutdown properly
Sorry, but format c: will not run if you're on c: partition (anf if c: is
system partition). :-)
JP
Dne pá 24. srpen 2001 11:32 jste napsal(a):
Kevin,
My advice would be to type:
C:\format c:\
Then install Win2K from the outset! The install is painless, and the O/S is
a HELL of a
Kevin,
Here's one that has been posted to our site recently by a customer
(www.cool-tools.co.uk Support User Defined Collections BLOCKER):
select l.sid sid,
s.username username,
s.program program,
t.sql_text,
u.name
Germany, lived there also, 3 years, beautiful and the only place where
trash was laying around in the street was where the American military
housing was. go figure.
joe
Scott Shafer wrote:
You know, I lived in Berlin for 2 years, and if I could figure out all the
Yes, it works.
t.Jorma
-Original Message-
From: ext Tatireddy, Shrinivas (MED, Keane)
[mailto:[EMAIL PROTECTED]]
Sent: 24 August, 2001 14:25
To: Multiple recipients of list ORACLE-L
Subject: any body come across, decreasing db_block_size.
Hi lists
have any body come
Saroj, you must create two files, SXXXOracle and KXXXOracle,
in /etc/rc2.d, for example, where XXX are numbers. So when your machine
reboots that files starts Oracle Database and listeners. Well, first,
because second is to stop database and listener. This is a question of
Unix start. Due to
Ahh of course you are right - :P I didn't elaborate (slaps my own wrist :)
If this is the case - insert your boot disk (I'm not sure whether you would
want the 98 or 2000 one at this stage though, as I've never wiped and
upgraded along this path), and use the following:
C:\format c: /s
Then
Beware of upgrading 98 to 2k. OS works fine, but games don't work anymore :(. I had
to restore back to 98. Thats what you get when you pirate games, no updates :)
[EMAIL PROTECTED] 08/23/01 06:58PM
I have not seen XP myself but a co-worker likes it. He was running
2000, which is what I
write entries in oratab file in /var/opt/oracle directory.
rukmini
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, August 24, 2001 5:40 PM
Saroj, you must create two files, SXXXOracle and KXXXOracle,
in /etc/rc2.d, for example, where
I didn't mean to use 'format' to clear up windows from your hdd.
(You have to use 'fdisk /mbr' too)
But some more sophisticated tools of erasing - like candle pin :-
Yea, it's friday.
JP
Dne pá 24. srpen 2001 14:25 jste napsal(a):
Ahh of course you are right - :P I didn't elaborate
** The Dead Come Through For Microsoft
As if there wasn't enough contentiousness between Microsoft and
the government, now state attorneys general are wondering why
they're receiving letters from Microsoft supporters who aren't
even alive. The letters have been arriving for the past several
Kimberly,
Don't get me wrong, I have 2k on a couple of machines and it is very stable
compared to 98 and NT. Problem is the motherboard I purchased has a Promise
ATA100 controller on the board, and I would have had to had installed the
drivers before installation. However, I wasn't sure
Scott Shafer wrote:
If the folding metal chair at my computer desk wasn't so cold, I wouldn't
bother...
--Scott
two words: seat cushion.;-)
--
--
Bill Shrek Thater ORACLE DBA
Telergy,Inc. [EMAIL PROTECTED]
srinvias,
Works the same way if you want to decrease the block size. The question to
ask is why?
Dick Goulet
Reply Separator
Author: Tatireddy; Shrinivas (MED; Keane) [EMAIL PROTECTED]
Date: 8/24/2001 3:25 AM
Hi lists
have any body come
Mark,
Like I said it wasn't that I couldn't install it, I just wasn't sure where
the drivers were. I know it's a lot more stable, but I heard the same
things you stated. I am a gamer and I heard it doesn't get along so well
with some games drivers etc. I am going to have to do it
Have you written your oratab file in /var/opt/oracle directory?
rukmini
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, August 24, 2001 4:02 PM
In a solaris 2.6 unix machine Database is started and shutdown properly
through svrmgrl.
One thing I noticed, M$ will not allow you to do redundancy raid (1, 5, 0+1)
in Windows Professsional. It will fail the install. You can only seem to
use Raid 0 (even hardware raid contorllers) some how it figures this out and
forces you to use server. Sucks if you ask me.
Do not criticize
Yeah, but you could do it from the a drive. You also can't install win2k
from dos:)
KK
-Original Message-
Sent: Friday, August 24, 2001 7:41 AM
To: Multiple recipients of list ORACLE-L
Sorry, but format c: will not run if you're on c: partition (anf if c: is
system partition).
Hi lists
can anybody throw some light on this:
when a process (bkgd/user ) starts, does it reserve memory (the memory
it really requires+additional buffer)
If yes, how to find out the free memory the process is not using.
thnx in adv.
reg
srinivas
--
Please see the official ORACLE-L FAQ:
Has anyone ever heard of a Sequence ever messing up and delivering the same
number more than once ??
During a very heavy hitting period on our application we are getting locks
that appear to be going after the same rows. These rows are govered by a
claim ID that is created via a sequence.
I will be using Win2000 for some time because of that crap. My computer
gets upgraded every 2 -3 months.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978)
In fact almost all of the files at rc0.d and rc2.d is linked to /etc/init.d
Do not forget to link the files Murosa has told you before
Create a script something like oracle:
#!/usr/bin/sh
#variables
ORA_HOME=/usr/u01/app/oracle/product/8.0.5
ORA_OWNER=oracle # That shall be your oracle owner
Mark;
No neccessary. I have win2k on mine. I was just asking the room after
reading an article in the local news paper.
-Original Message-
Sent: Friday, August 24, 2001 4:32 AM
To: Multiple recipients of list ORACLE-L
Kevin,
My advice would be to type:
C:\format c:\
Then install
Trusted Oracle is very much like regular Oracle. Most of the
security actually comes from the OS. That being said it does have
row level security so you have to match or superseed the privilage
that the row has to see the row but sys has the ability to change
to the higher level and you
Now see, that is why I have no issues with Windows 2000. Only game I play
is Freecell. Although I did install a Nascar game but no time to play it:-(
-Original Message-
Sent: Friday, August 24, 2001 5:51 AM
To: Multiple recipients of list ORACLE-L
Beware of upgrading 98 to 2k. OS
Steve:
According to Orace The Complete Reference (in the Hitchhiker's Guide to the
Optimizer chapter), the 1st table is scanned via a table access full and the
database applies hashing functions to the data to prepare the table for
the join. The values from the second table are then read and the
Every two to three months, what do you do with all of the old hardware? I
thought I was bad because I bought a new machine after a year, sheesh:)
kK
-Original Message-
Spence
Sent: Friday, August 24, 2001 10:40 AM
To: Multiple recipients of list ORACLE-L
I will be using Win2000 for
Hi,
How to Know when switching RedoLogs occur?
Oracle 8.0.6.2 TRUE 64 5.0
Thank's...
javs
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jairo Villalobos
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego,
I have same impression for Amsterdam, Netherlands where I lived for 3 years
1984-87 and enjoyed my time Got married and had 2 beautiful
baby girls
Have a nice weekend
Regards
MOHAMMAD RAFIQ
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
NASCAR game? heheheh I am more into shoot'em games like Mechwarrior, I
imagine that all of the other players are all of the new jersey drivers that
pissed me off on my way home:)
kK
-Original Message-
Smith
Sent: Friday, August 24, 2001 11:15 AM
To: Multiple recipients of list ORACLE-L
The order of execution is innermost, upmost first, and so on...
-Original Message-
Sent: Thursday, August 23, 2001 9:35 PM
To: Multiple recipients of list ORACLE-L
Does anyone know how the operation below is performed? Which object has
the hashtable built on it and which object
Check your alert log.
-Original Message-
Sent: Friday, August 24, 2001 11:51 AM
To: Multiple recipients of list ORACLE-L
Hi,
How to Know when switching RedoLogs occur?
Oracle 8.0.6.2 TRUE 64 5.0
Thank's...
javs
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
I have had this problem before, but it is generally due to some code pulling
a difference sequence than it should have.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Sell it on ebay or at a show, Just this year alone I had the following
equipment changed
Dual 700 - Dual 1000
Dual 1000 - Amd 1.4
Amd 1.4 - Dual Amd 1.5
512Mb ram - 1Gb ram
Gforce 2 - Gforce 3
18Gb Cheetah + 9gb cheetah - 128Mb writeback cache 100MHz raid with 2x18
Cheetah raid 0 + 2 9gb cheetah
Title: Message
Solaris, AIX, or HP-UX.
I am
bias to Solaris as I am acustom to it, but with the change in direction of
Oracle, I am considering HP-UX, and due to the cost and performance benefits of
AiX, I am also looking there. So in answer, I really don't know. I
would like to say Sun
What I was planing on doing, is using as much flat 8.1.7 features, but take
advantage of the 9i way of doing it.
For example, 9i is faster in calls to sql from PLSQL, this will not effect
my PLSQL code in one bit.
The new OPS features, if I need to go to old OPS, won't need to change code.
If
It is insane!! How can you expect someone to NOT upgrade?
Just a year back, it was a BIG configuration if you had 32 MB RAM, and 2
Gig drive.
Now, they have these 60Gig hard drives, and the newer OS's and
application really hog space like they assume you have 20+ drive. And 32
MB RAM? Many apps
Title: RE: RedoLogs switching
You can look in the alert.log file or
in the v$log_history table.
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is like
trying to club someone to death with a loaded Uzi.
- Larry Wall (creator of Perl)
And I assure you, you are not alone. People who are likely to go for
newer operating systems are the ones who would also keep upgrading their
systems' hardware - so Microsoft's policy is going to raise more than
eyebrows...
As for Windows XP, the look and feel is just awesome - the look has been
i think AIX is still the redheaded, 2nd class stepchild when versions come
out. I mean 9i for linux came out before AIX.
joe
[EMAIL PROTECTED] 08/24/01 12:02PM
Solaris, AIX, or HP-UX.
I am
bias to Solaris as I am acustom to it, but with the change in direction of
Oracle, I am
Redo log switch information appears in your alert log; you can also monitor
v$log and v$logfile.
Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, August 24, 2001 11:51 AM
To: Multiple recipients of list ORACLE-L
Hi,
How to Know when
Or issue a query on v$log_history
Regards.
--- Yexley Robert D SSgt AFIT/SCA
[EMAIL PROTECTED] wrote:
Check your alert log.
-Original Message-
Sent: Friday, August 24, 2001 11:51 AM
To: Multiple recipients of list ORACLE-L
Hi,
How to Know when switching RedoLogs occur?
Having worked on all 3: Solaris is the most basic (open), AIX is done the IBM way
(unique to IBM), and HPUX is somewhere in the middle. They each leap frog one
another. I would go for the best bang for the buck. Nowadays, they are getting
desperate :)
As for Oracle versions, go for 9i.
For the love of God Chris!!! I thought I had a problem, but jeez, you are
out of controll!!! Dual 1.5 Athlon Thunerbirds? Wow that must kick some
serious a... I am very pleased so far with my new setup, Thunderbird at
1GHZ, 512MB PC133, Gforce2, 20GIG ata100, 20gig ATA66, 12X10X32, 45cdrom.
Hi lists
can anybody post me this query:
I need to generate a dynamic sql that will create a statement to add a
constraint of composite primary key .
alter table xyz add constriant xyz_comp_pk (col1,col2,col3);
when I generated this from dba_cons_columns i am getting the flwng:
alter
i'd just got a piece of code from metalstink the other day that will
generate the constraints on a table for you into sql code.
if you want it let me know and i'll email it to ya(its really too big for
the list).
joe
[EMAIL PROTECTED] 08/24/01 12:31PM
Hi listscan anybody post me this
I think there is a table like v$loghistory that has
the information about latest log switches. Not sure
about the correct name, but you can search dba_objects
for object_name like '%LOG_HIST%' you'll probably find
it
G
--- Jairo Villalobos [EMAIL PROTECTED] wrote:
Hi,
How to Know when
Try this...
REM Log switches
set lin 132
col 00 format a3
col 01 format a3
col 02 format a3
col 03 format a3
col 04 format a3
col 05 format a3
col 06 format a3
col 07 format a3
col 08 format a3
col 09 format a3
col 10 format a3
col 11 format a3
col 12 format a3
col 13 format a3
col 14 format a3
given this, I'd definitely develop in 9i, since fallback to 8.1.7 would
require testing but not recoding.
good luck and let us know -- I hate living on the bleeding edge :)
From: Christopher Spence [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
Title: Message
Well I think part of that is because Oracle
knows linux people would be running it far faster than Aix people, most aix
boxes are production, where as many people are running linux and more quickly to
try it out there.
"Do not criticize someone until you walked a mile in
I have XP from MSDN, but I have yet to attemp to even try it.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
Greetings fellow listers,
We arestarting to make the changes
to sqlnet.ora files, I discovered that wehave 9 separate files on one
particular. Most of the file is identical with the only variance appearing
to be in the SQLNET.EXPIRE_TIME value which ranges from 10 to 300.
I'm thinking
Here is a script that I use, which creates a
procedure called logtime. You call it, providing it with a parameter which is
the last x log switches you want to know the time of...
create or replace procedure logtime(p_logs
in number default 20) as
v_no_of_logs number
:=p_logs;
Hi,
Can anyone tell me where I
can
download a copy of "top" to run on
aix 4.3.3 ?
thanks for your help.
ed lewis
Hi all,
I am sure someone should be able to help me on this. I am having a user
having problem when inserting a data that is from Legacy Systems into
oracle. His 'Cent' symbol getting converted to Inverted 'Question Mark'.
NOw everthing is 'cent' until it goes into database. Oracle suggested
Considering 1 year of development, I am hoping it wouldn't be bleeding edge
at release.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:
Hmm..
While taking away connections from user thru sqlplus would allow application access coz application makes connection using with application user name.
Product_user_profile table is useful only to restrict some scope of sqlplus.
If u still want to keep sqlplus access looks like u have to
List,
Has anyone downgraded from 7.0 Linux to 6.2 linux with Oracle 8.1.7.0.1 installed?
Any pit falls that need to be taken care of?
Reason being, I started with 6.2 and installed Oracle 8.1.7.0.1 and all was fine.
Upgraded the os to 7.0 and all was fine. Tried to add a new option to Oracle
actual date = to_date(junion_date_as_number, 'J');
seconds = actual seconds ... as long as they are less than 86400
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here
If you want to see it happen,
alter session set events '10104 trace name context forever, level 1';
alter session set events '10046 trace name context forever, level 8';
The first switches on the hash trace.
The second dumps wait states.
You can watch the hash taking place and see the
data
Title: startup time v7
The v$instance table has the following two entries in
Oracle7.
STARTUP TIME - Julian 2452043
STARTUP TIME - SECONDS 9476
Doing the obligitory RTFM, I find all it
says is that STARTUP TIME - Julian is the
startup date and time in Julian format.
(Thanks oracle,
Just create one under /etc/init.d and softlink both the S and K script to it.
The one under /etc/init.d must accept stop and start as an argument and
do startup and shutdown accordingly. You can check out any script
under /etc/init.d as a example on how to write one.
Richard Ji
[EMAIL
Hi DBA's
I'm currently monitoring the Oracle SIDALRT.LOG and *.TRC files in
$ORACLE_HOME/RDBMS80/TRACE on our production Oracle 805 database.
I've observed the following files being used by Oracle in that directory:
SIDP000.TRC 5MB
SIDP001.TRC 5MB
SIDP002.TRC 5MB
SIDP003.TRC 5MB
SIDP004.TRC
The julian date is the year plus the day number of the year. Today
(Aug. 24, 2001) is 2001236 or 01236, since today is the 236th day of 2001.
"Adams, Matthew (GEA, 088130)" wrote:
The v$instance table has the following two entries in
Oracle7.
STARTUP TIME - Julian
2452043
STARTUP TIME - SECONDS
Denmark,
I am not an expert but from everything I have read is that when you get
ORA-00600 errors you should probably open a TAR with Oracle. It may not be
much but why take the chance.
I would be interested in that tuning script that you downloaded. Cound you
send it to me directly or let me
I'd hope not, but you never know with Oracle :)
I meant bleeding edge to start developing it now, with 9i so new and raw and
barely born
From: Christopher Spence [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Would you use
I agree. The general idea is:
1) Set up /var/opt/oracle/oratab
2) Create a script like the one below named, for example, dbora in
/etc//init.d
3) Create links to this script from /etc/rc0.d and /etc/rc2.d (e.g. ln -s
/etc/init.d/dbora etc/rc0.d/K99dbora)
Now you only have to modify
nobody would be that dumb, would they? :)
--
From: Mohan, Ross [EMAIL PROTECTED]
Date: Thu, 23 Aug 2001 11:13:04 -0400
Subject: RE: Installing 73 and 816 on one NT server?
[via ORACLE-L Digest -- Volume 2001, Number 236]
... sw raid?
--
Please see the
for those of you with metalstink, its
Doc ID: Note:1016836.6
for those of you who dont(and want it, email me).
have a good weekend everyone(for those of you already into the weekend in
Australia and NZ, what does the weekend look like, good?
joe
80 matches
Mail list logo