Add this to what Arup said:
PK enables one to have References established in a schema. (Parent Child
relationships i mean). That cannot be done just by having a unique
and/or
not null constraints set.
You will get ORA-02270: no matching unique or primary key for this
column-list
HTH
GovindanK
Create a dummy user dummy with pw as dummy and only with create session
priv. Execute a sql script which will connect to the username/pw and
which does
not have read privs at os level for others.
May be someone on the list has a better idea.
HTH
GovindanK
On Fri, 16 Jan 2004 10:04:35 -0800
XXX,
can be seen in the savegroup messages or in stdout during manual
operations. You must increase the connection port range on system XXX.
A corresponding change is also required in the firewall rules.
/quote
I don't see any port info in the error message i got.
Any ideas?
TIA
GovindanK
Ok. Here you go.
http://osi.oracle.com/~tkyte/Mutate/index.html
Let me know if you find this useful.
HTH
GovindanK
OCP 8,8i
Brainbench Certified Master DBA(8)
On Thu, 08 Jan 2004 11:24:25 -0800, Nuala Cullen [EMAIL PROTECTED]
said:
Hi All,
Firstly my apologies if this seems like a very
line at a time.
Thanks in Advance.
GovindanK
--
http://www.fastmail.fm - The professional email service
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: GovindanK
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego
Yes .. that is good.
GovindanK
On Wed, 10 Dec 2003 13:44:34 -0800, Freeman Robert - IL
[EMAIL PROTECTED] said:
Excellent slide show Tanel!
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 12/10/2003 3:34 PM
dc_histogram_defs)
Pete, I'd like
What you essentially need to do (without any additional programming
effort) is implement VPD (Virtual Private Database).
The link is here:
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adgsec02.htm#1009919
HTH
GovindanK
On Fri, 14 Nov 2003 09:49:25 -0800, Hamid Alavi
Kitty , it is nice on your part to share the solution with the list.
For future : (On the lines of what Stefan said)
May be dd if=inputfile of=outputfile conv=ebcdic/ebcdicb/ibm/ibmb might
have
helped. Check with man dd.
The suggestion given by Raj is worth keeping in mind.
HTH
GovindanK
$OH/rdbms/admin/catqm.sql .
HTH
GovindanK
On Thu, 13 Nov 2003 06:59:37 -0800, Senthil Kumar
[EMAIL PROTECTED] said:
Hi Group,
Recently I have installed oracle 9i (R2). I have seen a user called
ANONYMOUS which is locked. There is no documentation about this user. I
have used DBCA
http://lists.gridapp.com/mailman/listinfo.cgi/oracle-rac
HTH
GovindanK
On Thu, 13 Nov 2003 08:09:26 -0800, Browett, Darren
[EMAIL PROTECTED] said:
I am looking for a RAC listserv that is active.
I have signed up for one, unfortunately I can't rememer what the address
is and there has
been
-- 1 govindankappdev1 42 Nov 13 11:40 myfile.dat
-rw-r--r-- 1 govindankappdev1 32 Nov 13 11:43 myfile.tmp
$ more myfile.tmp
WI auto
WI Auto
NY auto
ny Auto
$ diff myfile.dat myfile.tmp
5d4
Junk auto
$
HTH
GovindanK
On Thu, 13 Nov 2003 11:24:25 -0800, Tracy Rahmlow
[EMAIL PROTECTED
.
HTH
GovindanK
On Tue, 11 Nov 2003 22:24:24 -0800, VirVit [EMAIL PROTECTED]
said:
Hello!
How can I clean temporary tablespace? It grows up faster and faster.
--
ðÏÃÅÌÕÅ× ÷ÉÔÁÌÉÊ éÇÏÒÅ×ÉÞ (VirVit)
Oracle 9i DBA beginner
--
http://www.fastmail.fm - Sent 0.02 seconds ago
--
Please see
is getting filled. Hence i suggested this. This is mentioned in
Metalink too.
HTH
GovindanK
On Thu, 13 Nov 2003 17:19:24 -0800, [EMAIL PROTECTED] said:
Actually, you need to set the PCTINCREASE to a non zero value for
automatic coalescing to take place.
It isn't needed in any case. Oracle
grant exp_full_database to user;
grant imp_full_database to user;
No need for system account/dba privs to be used.
HTH
GovindanK
Oracle Certified Professional(8,8i)
Brainbench Certified Master DBA(8)
We still have to use SYS and SYSTEM for database creates, full exports,
imports, etc
GovindanK
Oracle Certified Professional(8,8i)
Brainbench Certified Master DBA(8)
On Wed, 12 Nov 2003 12:04:35 -0800, Smith, Ron L. [EMAIL PROTECTED]
said:
We are being asked by Auditing to stop using the SYS, and SYSTEM
accounts. They would like for us to create an Oracle Role with the same
You need to cut paste.
HTH
GovindanK
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, September 22, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L
When I right click on a metalink article to try to save it to a local
directory and use save target as - it only provides a blank
If $OH/bin was in the PATH then which rman would have got you the result.
I think that was not the case. That's exactly why it connected to rman when
you typed $OH/bin/rman. Therefore include $ORACLE_HOME/bin in the path
after :/bin:/usr/sbin etc.
HTH
GovindanK
Hi list,
Recalling
You would require something like this:
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:504432994857
HTH
GovindanK
Hello Listers,
I need some SQL help.
Not sure if this is possible in plain SQL or not, but here it is:
I have a table with two columns:
EMPNBR LINENBR
How about SELECT ORA_DATABASE_NAME FROM DUAL;
HTH
GovindanK
select sys_context('USERENV','DB_NAME') from anytable;
At 10:49 AM 9/10/2003 -0800, you wrote:
hi.
I think there was a dbms package to get some of
the environment variables for a session, but I can't
remember anyhting specific
://www.orafaq.net
--
Author: GovindanK
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list
or else you would get ORA-14508: specified VALIDATE INTO table
not found instead of an ORA-1499.
quote
HTH
GovindanK
hi, GovindanK:
I searched metalink and cannot find note:287936.999 you mentioned.
And I did not move the IOT index segment and overflow segment online.
I
did those
cat filename|mailx -s subject mailid
HTH
GovindanK
Hi List
I tried the following stuff but it says Service
Unavailable.
$mail -s Test Subject [EMAIL PROTECTED]
body line1
body line2
Ctrl-D
What should i do to make email stuff work?
Thanks in advance
Sami
Congrats Tanel on becoming OCM.
GovindanK
Certified DBA(8,8i,Brainbench-Master)
Thanks Patrice.
Yes, the exam was challenging, I've never typed and thought that fast than
5
min before end of second testing day ;)
Tanel.
- Original Message -
To: Multiple recipients of list
Enable Network Tracing and check.
GovindanK
I'm confused, has anyone ever seen something like this before?
This query works as you can see:
select count(*)
from [EMAIL PROTECTED];
COUNT(*)
--
275375
We execute the following DDL:
DROP SYNONYM
Damien
Your gesture is appreciated. It is a must that such solutions are shared
with the list members.
GovindanK
Thank you very mutch for your replys,
Today I finally found the problem. The traceroute shows the good route,
but a Ms Proxy Client installed on the server blocked the request
Earlier post did not reach. Hence Reposting.
Take a look at the Metalink Note:125149.1
ALERT: ONLINE Index Rebuild or IOT Table Move can Produce Corrupt Index
As per the note it affects 8.1.(5/6/7).x
It has the relevant info.
Also take a look at the Docid: 287936.999.
HTH
GovindanK
I wonder how the code generator is going to take care of Multiple
Record Types , Redefines clauses , Renames clause, GO to statements,
Perform Thru , Declaratives? That would be interesting.
GovindanK
Hi List,
Does anyone know of tools, or have had experience using tools, that will
quickly
the internals etc. Go thru Recovery principles, Case Studies by Rama
Velpuri. (Add RF's book too). Try doing the same with Standby too.
HTH
GovindanK
My Oracle9i RMAN Backup and Recovery book from Oracle Press has a chapter
devoted to case studies and RMAN.
RF
-Original Message
When you get wait seconds 0 use TKPROF and look for statements taking
time.
HTH
GovindanK
Ehresmann, David wrote:
System-wide Wait Analysis
for current wait events
Take a look at the Metalink Note:125149.1
ALERT: ONLINE Index Rebuild or IOT Table Move can Produce Corrupt Index
As per the note it affects 8.1.(5/6/7).x
It has the relevant info.
Also take a look at the Docid: 287936.999.
HTH
GovindanK
Sun solaris 8/oracle 8.1.7.2 64bit.
After some
)A QUERY clause is specified
4)Only certain partitions or subpartitions are exported.
***
/quote
HTH
GovindanK
Jin - Sounds good. Start with Google and with metalink.oracle.com. If as a
result of your investigations you find that my simple-minded approach has
overlooked a ghastly possibility
If 8i and above then take a look at v$mystat, v$session
, v$transaction.
Those should help.
HTH
GovindanK
I can't get ID current session and others info: User Name, User ID, Date,
Time of session transaction from Trigger.
Please help me: [EMAIL PROTECTED] or [EMAIL PROTECTED
to be sturdy, double check your backup recovery strategies. Also, which option to
use is influenced by how much downtime/shutdown time you can afford.
HTH
GovindanK
--
|XXX|
|You should treat others the way you want to be treated
the
active log could not be read for recovery. How would one perform a complete recovery?.
Let me know if you have a workaround.
I am willing to learn.
GovindanK
--
|XXX|
|You should treat others the way you want to be treated
. However, if it is multiplexed then an error will be logged to the alert.log but
the db will continue to function. I agree this has nothing to do with the arch/noarch
mode but one has to have the log files multiplexed to get out of such scenarios.
HTH
GovindanK
Agreed. I admit my English needs some improvement. What i wanted to say was about
rollback but used the words no.of.users. Thanks for pointing out.
GovindanK
Jeremiah Wilton [EMAIL PROTECTED] wrote:
On Wed, 2 Apr 2003, GovindanK wrote:
Shutdown immediate does rollback and will take time
To me it seemed the same as turning off your computer with the power button instead
of the shutdown command or using kill -9, sometimes you have to, but it's not what
you do normally.
Chris Berry
Sounds practical.
GovindanK
37 matches
Mail list logo
