Why DB_Name 4 chars only.

2002-07-30 Thread Srinivas
. Is it a common practice to keep SID/db_name/instance name parameters same (for example PBDS). thanks Srinivas __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Please Help: estimating size for materialized view Question

2002-07-24 Thread Srinivas
ON and VAR num_bytes NUMBER VAR num_rows NUMBER at SQL prompt in SQL*Plus. Can someone help me how to find the estimated size before creating a materialized view for the following syntax for the following. thanks, Srinivas exec DBMS_OLAP.estimate_summary_size('test_est_size', 'SELECT empno

RE: privileges and synonyms and dblinks

2002-06-26 Thread Srinivas
explain. Using 8.1.7.on unix __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Srinivas INET: [EMAIL PROTECTED] Fat City

Help Please: ORA-01031

2002-06-21 Thread Srinivas
). Why is this not working. Please help. J2400 owns table TBL_A. SQL GRANT SELECT ON J2400.TBL_A TO J1416; GRANT SELECT ON J2400.TBL_A TO J1416 * ERROR at line 1: ORA-01031: insufficient privileges thank you Srinivas __ Do You

IMPORTING FROM 8.1.6 to 8.1.5

2002-05-16 Thread Pati Srinivas Rao
hi all i am facing problem , when i am importing oracle 8.1.6 backup dmp file into oracle 8.1.5 database. pls give solution. bye srinivas rao . Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience

Storing formated data in oracle table

2002-04-27 Thread Pati Srinivas Rao
hi all How to store formated data(bold,italic) in oracle table. bye Do You Yahoo!? Yahoo! Health - your guide to health and wellness

RE: How set Date format Globally

2001-07-11 Thread Srinivas Vedantam
Hi, Put that statement in GLOGIN.sql and see. Rgds Vra Srinivas. -- From: Rangachari Sundar[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Wednesday, July 11, 2001 2:05 PM To: Multiple recipients of list ORACLE-L Subject: How set Date

error 356 on oracle 7.3.2

2001-05-11 Thread srinivas aradhyula
in advance. Srini __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: srinivas aradhyula INET: [EMAIL PROTECTED] Fat City

current transaction in oracle

2001-04-17 Thread srinivas aradhyula
hi, i am looking for a sql statement which can tell me the current sql running in oracle. TIA Srinivas __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ

oracle on win2k

2001-02-07 Thread srinivas aradhyula
prices. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: srinivas aradhyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: oracle on win2k

2001-02-07 Thread srinivas aradhyula
. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: srinivas aradhyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists