RE: GRANT REFERENCES

Hi All, > > I am trying to GRANT REFERENCES on a table that resides on a different > database, on a different server. Is this possible and how do I go about > doing it. > > TIA > E. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Auth

RE: GRANT REFERENCES

on a table that resides on a different database, on a different server. Is this possible and how do I go about doing it. TIA E. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Troiano, Paul (CAP, GEFA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: ORA-03113

ude a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Troiano, Paul (CAP, GEFA) INET: [EMAIL PRO

RE: Multiple instances - Sun Solaris: shmsys and semsys settings

HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Troiano, Paul (CAP, GEFA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: Statistics not updated

BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Troiano, Paul (CAP, GEFA) INET: [EMAIL

RE: Oracle/UNIX vs. Oracle/NT

r other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Troiano, Paul (CAP, GEFA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Intern

RE: Help!: Job Description for Data Architect

ling list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Troiano, Paul (CAP, GEFA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

RE: Which unix command

, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Troiano, Paul (CAP, GEFA) INET: [EMAIL PRO

RE: Help: truncate lasting 2+ hours

cause the truncate to run very long -- Oracle needs to release the extents to the FET$ -- which means taking each extent OFF the UET$ and adding it to FET$ -- lots of recursive SQL >From: "Troiano, Paul (CAP, GEFA)" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: M

Help: truncate lasting 2+ hours

I have a 12.5 million row table for which a truncate has been running for >2hrs. What can cause this? (Solaris 2.6, Oracle 8.1.7) Thanks in advance, - Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Troiano, Paul (CAP, GEFA) INET: [EMAIL PROTECTED] Fat C

RE: Invalid packages not being recompiled by Oracle

n advance, - Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: Troiano, Paul (CAP, GEFA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Invalid packages not being recompiled by Oracle

ion to not impacting performance or without having to recompile all the dependent packages. Thanks in advance, - Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Troiano, Paul (CAP, GEFA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 5

RE: db domain being appended to db links when global_names = fals

global_names was set to false and a db_domain was set. The new database was created with these new parameters. I just recreated the control files with the new settings and new name. Thanks, - Paul -Original Message- From: Troiano, Paul (CAP, GEFA

db domain being appended to db links when global_names = false

effect (I did bounce the DB). I am using the simple version of the create database statement: create public database link dev4 using 'dev4'; Thanks in advance, - Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Troiano, Paul (CAP, GEFA) INET: [EMAIL

RE: INVALID Packages

t patchset. Thanks in advance - Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: Troiano, Paul (CAP, GEFA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

INVALID Packages

r own. My question is: What is preventing Oracle from re-parsing the package? It has nothing to do with system load or lack of SGA. We're running Oracle 8.0.5.2.1 on Solaris 2.6 w/latest patchset. Thanks in advance - Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

RE: ScanMail Message: To Sender, sensitive content found and

the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.ora

RE: OT RE: Async I/O on Windows

7;) and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Troiano, Paul