Re: Explain plan of a table you do not own

2002-09-21 Thread Mark J. Bobak
ALTER SESSION SET CURRENT_SCHEMA = ; -Mark On Sat, 2002-09-21 at 15:33, Van der Sande Patrick wrote: > Dear, > > As system I want to generate an explain plan of an end user query. > In this query a number of tables are defined which do not have a public synonym. > > The explain plan ... statem

Explain plan of a table you do not own

2002-09-21 Thread Van der Sande Patrick
Dear,   As system I want to generate an explain plan of an end user query. In this query a number of tables are defined which do not have a public synonym.   The explain plan ... statement does not succeed because of a "Table or View does not exist".   Can somebody tell me how to bypass this

sercurity issue

2002-09-21 Thread Ray Stell
I don't remember the recent SSL vulnerability being listed here: http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=206034.1 Vulnerable: Oracle HTTP Server (OHS) shipped with the database up to and including version 9.2.0. Oracle9iAS versions earlier than 9.0.2, including all version

Re: Spool Oracle Tables into Excel Format

2002-09-21 Thread Tim Gorman
Delimiting each column with surrounding double-quotes as well as commas is pretty standard...   Another standard approach is to delimit with a character that is less likely to be part of the data, such as the "tilde" or "~" character... - Original Message - From: Naveen Nahat

RE: Spool Oracle Tables into Excel Format

2002-09-21 Thread Naveen Nahata
You don't need to get rid of the commas. A CSV file will automatically be read into excel and all the commas will become a breakpoint for new columns. Or alternatively a spooled output can be read into excel, it will open the format wizard to specify the breakpoints for columns   But the qu