Direct privs vs Acess thru a role

Hello, How does Direct grant access differs from an access thru a role? and *WHY*? Thanks. OraCop __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ

RE: Automatic backup on Oracle 9i -- For Jared

Well, I understand that writing you is not much trouble compared to writing U, but understanding U, should not be much trouble either. Don't U think so? OraCop. --- [EMAIL PROTECTED] wrote: I have never known what lol stood for , I appreciated the general meaning by looking at the context

RE: Automatic backup on Oracle 9i -- For Jared

Even though i strongly think that there is nothing wrong in writing U instead of you, respecting your feelings towards the list, and considering the fact that we must think above such small matters, I will be careful in future. Thanks. OraCop. --- Martin Kendall [EMAIL PROTECTED] wrote

Re: Automatic backup on Oracle 9i -- For Jared

Jared what exactly U use Veritas Netbackup fr in Ur backup strategy. I use rman to take backup on disk. Please describe the role of veritas NB in detail and if u can send me example script to perform what tasks, that would be gr8. OraCop Jared --- Jared Still [EMAIL PROTECTED] wrote

Spool output issue on solaris

: http://www.orafaq.net -- Author: OraCop 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

Spool file behavior on Solaris

hello, This is what i am doing: __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop INET: [EMAIL PROTECTED] Fat

Spool file output

__ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Parsing Column val

://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Parsing Column val

Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: OraCop [SMTP:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Subject:Parsing Column val Hello, One

RE: Parsing Column val

output will be written to a 2nd table and I may/may not have primary key on that table. Thanks. --- OraCop [EMAIL PROTECTED] wrote: Yes there is primary key on the table. --- Koivu, Lisa [EMAIL PROTECTED] wrote: Looks to me like you have to do this in pl/sql unless you can say something

RE: Parsing Column val

output will be written to a 2nd table and I may/may not have primary key on that table. Thanks. --- OraCop [EMAIL PROTECTED] wrote: Yes there is primary key on the table. --- Koivu, Lisa [EMAIL PROTECTED] wrote: Looks to me like you have to do this in pl/sql unless you can say something

RE: LONG's

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

RE: LONG's

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

RE: 9i Lite

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

RE: Urgent: ORA-02067 transaction or savepoint rollback required (Distributed transaction)

Hello, Are u performing any exception handeling in Ur code? Try to capture oracle err mesg using USER DEFINED EXCEPTIONS. For more detail look into DBMS_ERROR_CODE and DBMS_ERROR_TEXT OraCOP --- Charu Joshi [EMAIL PROTECTED] wrote: Hi Arup, Thanks for the reply. I have

Re: [Q] ORACLE 9i remote export insufficient previlege?

CATPROC.SQL (this runs CATRM.SQL) the modification made to the EXP_FULL_DATABASE role by CATRM.SQL no longer exist since CATEXP.SQL drops and creates the EXP_FULL_DATABASE role.The privileges granted to the role by CATRM.SQL are necessary to export the resource manager objects. OraCop

Re: Advanced Rep between 9.2.0 and 8.1.7?

Yes, I am replicating between 8.1.7.3 and 9iR2 without any issues. Need help? OraCop --- Michael Barger [EMAIL PROTECTED] wrote: Has anyone heard of or experienced a successful implementation of Advanced Replication between an 8.1.7 database and a 9.2.0 db

Auto restart of Database

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Auto restart of Database

Set last argument for appropriate SID in oratab = Y to restart DB at boot time. --- OraCop [EMAIL PROTECTED] wrote: How can I setup my server/database sothat after reboot of my Solaris server, database and listener start automatically? Thanks

Re: SERACH FAST

Seema Ji, Are U using Oracle Search for this purpose? Are u using search indexes and using them correctly? What version of Oracle? Regards. OraCop --- Seema Singh [EMAIL PROTECTED] wrote: Hi How to make search fast? We are building some application and this application need

RE: Whitepapers on Triggers

We call them Journal tables. Great technique. OraCop --- Lisa R. Clary [EMAIL PROTECTED] wrote: Since we are in the medical records business, we too have the same guideline. What we do, is create an exact table replica (we call it an archive table and it does not have constraints) to which

Re: SERACH FAST

U can use Oracle intermedia/Oracle Text/Ultra search. what kind of data Ur performing this search on. What is the datatype of the data? How exactly U r trying to search right now? U need to gather all this information? OraCop --- Seema Singh [EMAIL PROTECTED] wrote: Oracle 8.1.6

Backup/Restore

ideas/links to help improve backup strategy, using veritas and RMAN. Thanks. OraCop __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: Backup/Restore

restoring. echo echo -- DON'T FORGET -- DON'T FORGET -- echo Don't forget to RESET DATABASE in RMAN catalog. echo -- DON'T FORGET -- DON'T FORGET -- echo -Original Message- From: OraCop [mailto:oracop;yahoo.com] Sent: Tuesday, November 12, 2002 2:29

RE: Backup/Restore

Stephen: Thanks a lot for Ur response. How do U restore from the backup? have a script? U r not using veritas? Thanks. OraCop. --- Stephen Lee [EMAIL PROTECTED] wrote: You don't say if you are using catalog or not. If not, be sure to backup control files

RE: Backup/Restore

restoring. echo echo -- DON'T FORGET -- DON'T FORGET -- echo Don't forget to RESET DATABASE in RMAN catalog. echo -- DON'T FORGET -- DON'T FORGET -- echo -Original Message- From: OraCop [mailto:oracop;yahoo.com] Sent: Tuesday, November 12, 2002 2:29