Why DB_Name 4 chars only.

2002-07-30 Thread Srinivas
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
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', &#x

RE: privileges and synonyms and dblinks

2002-06-26 Thread Srinivas
one please 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]

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

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:

error 356 on oracle 7.3.2

2001-05-11 Thread srinivas aradhyula
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

error 356 log corruption

2001-03-06 Thread srinivas aradhyula
ABASE RECOVER FROM '/bmp/rpts/home/db/ar... Tue Mar 6 22:10:08 2001 ALTER DATABASE RECOVER CANCEL ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL... this is on solaris 2.6 are there any oracle or unix utilities to check this 003622

RE: oracle on win2k

2001-02-07 Thread srinivas aradhyula
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 Network Services

RE: oracle on win2k

2001-02-07 Thread srinivas aradhyula
_ > 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 Network

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