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
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.
I don't see any port info in the error message i got.
Any ideas?
TIA
GovindanK
--
http://www.fastma
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
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,
>
> Firstl
eems to be going one 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.f
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:3
I agree with Jared. Take a look at asktom. One will know how much
deep is pl/sql. That is what Jared has meant. It is not the features
that matter, but how you interpret and mix and match them is what
matters. Repeat asktom.
HTH
GovindanK
On Wed, 19 Nov 2003 10:40:10 -0800, [EMAIL PROTECTED
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
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
EMP
segment 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'
ularly with results.
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
unk auto
$ more wi_auto
WI auto
WI Auto
$ more ny_auto
NY auto
ny Auto
$ ls -lrt *myfile*
-rw-r--r-- 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.tm
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 w
$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 docume
You would require SYS to carry out tasks like
1. grant execute on dbms_package to
2. grant select on v_$view to
Whether to have these things granted to PUBLIC is always debatable.
..
..
Tell this to your auditing. And what they suggest too does not seem to
hold water.
HTH
GovindanK
grant exp_full_database to ;
grant imp_full_database to ;
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...
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,
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 co
How about SELECT ORA_DATABASE_NAME FROM DUAL;
HTH
GovindanK
> select sys_context('USERENV','DB_NAME') from ;
>
> 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 fo
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 sho
ory or else you would get ORA-14508: "specified VALIDATE INTO table
not found" instead of an ORA-1499.
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 segmen
der immediately and delete the material from
> any computer. This email may have been monitored for policy compliance.
> [021216]
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: GovindanK
INET: [EM
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 -
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,
: 287936.999.
>
> HTH
> GovindanK
>
>> Sun solaris 8/oracle 8.1.7.2 64bit.
>>
>> After some database defrag(via alter table xxx move and alter index xxx
>> rebuild), I got 600-25012 from my delete session and alert file.
>>
>>
>> SQL> DELE
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
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 ex
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.
>
> A
When you get wait seconds > 0 use TKPROF and look for statements taking
time.
HTH
GovindanK
>
> "Ehresmann, David" wrote:
>
>> System-wide Wait Analysis
>>
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
>
>
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 PROTEC
r set
3)A QUERY clause is specified
4)Only certain partitions or subpartitions are exported.
***
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
>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
So
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 roll
. 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
on 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 t
ecovery seems
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 th
38 matches
Mail list logo