OCP (OPP number)

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

.NET and Oracle

Hi, I read somewhere that .NET application will only be supported with SQL Server. Is this true or it can be run with any other database like Oracle? Thanks --Harvinder

dbms_stats question

-- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing

query problem

' Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Odbc and reserve words

IS there and escape sequence in ODBC where it will not give error for reserved words.. Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

double quotes column name

ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

probem using ROWNUM and ORDER BY clause together

-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: probem using ROWNUM and ORDER BY clause together

://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

RE: problem using ROWNUM and ORDER BY clause together

value 2) and only fails if we use rownum 2... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: SQLServer copy table from 1 db to another

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: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RECOVERY QUESTION

ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: RECOVERY QUESTION

and then u can drop tablespaces. OR at current stage.did u status in check v_$datafile and v_$tablespace dictionary table ? Thx -Seema From: Harvinder Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RECOVERY QUESTION Date: Thu

Error while connecting to database

?? Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Upgrade from 9.0.1.2

see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

9.2 and Microsoft ODBC driver issues

ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

dynamic sql problem

* from'||' '||name3; execute immediate str; Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

export fails with invalid column name

: invalid column name .export fails. column is null for all rows How can i migrate this table to new version ..without using sql loader... Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City

import fails with referentail integrity constraint violation

as t_usage is primary table..referntial integrity problem.. how to resolve this issue. Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

QUERY TUNING

to check for this performance degradation... i am only working on test machine so no other user intervention. Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858

query performance

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Interview Queries

queires or have any good queries of their own. for example the query asking difference between using IN or EXISTS.. Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

listener problem

ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

error running query using microsoft odbc driver for oracle

queries r running fine with this syntax. Thanks -harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

converting case in sqlserver to oracle

AND child_kind.nm_productview = ed.nm_enum_data then -(au.id_pi_instance + 0x4000) else -au.id_pi_instance end) end,au.instance, Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL

unable to execute procedure containg pl/sql tables

; end; end; / -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

outer join problem

= t_pl_map.id_pi_template(+) and t_aggregate.id_prop = t_pl_map.id_pi_template(+) and Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

what is wrong in query

) AND te.n_begintype 0 AND ta.n_begintype 0 Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: what is wrong in query

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

RE: what is wrong in query

: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E

query problem

://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

unable to insert into table with datatype raw

') --- # Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

CLIENT VERSION

Hi, In batch script If we need to verify the version of oracle software on server we issue: select * from v$version; But how to find the client version from some batch script?? Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh

RE: CLIENT VERSION

2002, Harvinder Singh wrote: In batch script If we need to verify the version of oracle software on server we issue: select * from v$version; But how to find the client version from some batch script?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah

Dbms_job not running

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

function based index problem

behaviour or i am missing something??? Environment is 9.0.1 on WIN 2k. Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

optimizer not using function based indexes

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

RE: optimizer not using function based indexes

-- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing

function based indexes

be changed to TRUSTED and what is use of TRUSTED. Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

MATERIALIZED VIEWS

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

DISK LAYOUT RAID LEVEL

: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

UTF8 or AL16UTF16

Title: Deleting files on w2k Hi, We need to store the unicode data in column defined as varchar2 datatype so we have to use unicode data set. In 9i which is the preferred value for (NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET) UTF8 or AL16UTF16 and why? Thanks -Harvinder

DISK LAYOUT

Title: RE: Deleting files on w2k Hi, We have to performance benchmark test for our application . We have to check only scalibiliy and performance and not much concern for reliablity. We have 10 36G hard disks(Fiber Channel array) and 2 18G(Internal boot disks).4 400MHZ cpu's Expected

Partitioning Questions

: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E

DBCA (DATAFILE SIZE PROBLEM)

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

FILE SIZING

tablespaces . which option is better for large database Uniform size or Autoallocate. Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

SRTIPE SIZE

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Update table problem

://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

NUMBER PROBLEM

is not working as it it giving error table column should be empty. Tables have more than 10 million rows. Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

LARGE DATAFILES

Hi, Is there is any drawback in using datafiles of big sizes. Our tablespace size is about 180G so does it okay to use data files of sizes 20G. Is 20G or 20G can give us some benefit. Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder

ERROR RUNNING BATCJ JOBS

Title: How to backup MTS database with RMAN Hi, We are running batch jobs (SELECT/INSERT) since friday and it runs fine for first 3 days and now we start getting following errors: 1) ORA-01460 SQLSTATE 42000 2) function sequence error SQLSTATE HY010 3) value out of range error - SQLSTATE

SQL PROBLEM

Title: MS access Hi, Favour me insuggest ahint in writing a sql forfollowing scenaio: Table A has 2 columns ord_id and line_id example rows are: ord_id line_id 17 null null42 TableB has columns ord_id and line_id ord_id line_id 17 42 17 43 1744 I have to write a sql to count(*)

problem starting oracle database

control file in init.ora same error... i am using startup pfile ...so it is using proper init.ora file What might be the cause... Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services

how to run procedure containig REF CURSOR as datatype

must have same datatype as corresponding expression. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: how to run procedure containig REF CURSOR as datatype

getrateschedules_pkg.getrateschedules(1,2,3,sysdate,4,io_cursor); end; / ORA-01790: expression must have same datatype as corresponding expression. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858

what to put in place of null

-06512: at line 1 what to replace null with.. dd1 has only 2 columns dd2 and dd3. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

how to connect from oracle to sql server database

to change. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

how to execute ref cursor using dynamic sql

Hi, I got the following code from metalink whci says we can't use ref cursor directly in dynamic sql earlier than 9i.. but following code don't seems like working: error is DECLARE * ERROR at line 1: ORA-01001: invalid cursor ORA-06512: at line 22 execute immediate 'declare v_cursor

problem with dynamic sql

://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

pl/sql problem

-06512: at line 16 What might be the reason Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

pl/sql error

improve this code Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

set feedback off in procedure

Title: Current Osuser Hi, Can we use the following commands inside the pl/sql procedure.(due to application requirement) set feedback off set fedback on If yes at what point in procedure. Thanks Harvinder

how to insert quote in a column

Hi, I have a column defined as varchar2..i need to insert name like 'joy' in it with quote how can we insert quote(') to column. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network

RE: Calling Stored Proc in SQL Server from Stored Proc in Oracle

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: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

user defined data type

Hi, Developers need a datatype which only stores the time portion of date i.e. HH24:MI:SS... Any ideas how to create this data type. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network

Issue with Global temporary table

Hi, We have 3 tables involved a query. If all the tables are permanent then we have a explain plan with very less cost and query runs very fast BUT if we use 1 global temporary table..explain plan is different with high cost...and it seems it don't use index for other tables also...

unable to logon to database

Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

PERFORMANCE QUESTION

very high about 24567 - 38987.. What can be the possible cause of increasing DB FILE SEQUENTIAL READ... We are running same set of queries for testing.. Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL

Using User Defined functions or not

the performance ..Does it advisable to use extensive use of UDF in code Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

how to kill Distributed transaction

: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E

32 or 64 bit

Title: Message Hi, How to check the database and sun unix system is 32 bit or 64 bit. Thanks --Harvinder

Install hanging issue

see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

unable to apply patch

HI, When we try to apply patch 9.0.1.2.0 on 9.0.1.1.1 oracle we got error: There are no patches that need to be applied from patch set Oracle9i Patch set 9.0.1.2.0. Earlier we are able to apply the same patch on other machine. What might be the possible reason for this error? Thanks

Restrictng tables during export/import

; END exclude_table; Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Primary keys

) on history table. OR do we should leave history tables without primary key Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

USER DEFINED FUNCTIONS

Hi, We are evaluating the usefullness/drawbacks of using UDF's. Is there any case study on any site which shows some scenarios of using UDF's in Queries. Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat

cursor not closing

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

Complete Refresh of Materialized view taking long time

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

distributed transaction fails

what is the new parameter. Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

unable to apply patch

HI, When we try to apply patch 9.0.1.2.0 on 9.0.1.1.1 oracle we got error: There are no patches that need to be applied from patch set Oracle9i Patch set 9.0.1.2.0. Earlier we are able to apply the same patch on other machine. What might be the possible reason for this error? Thanks

CURSOR_SHARING=FORCE

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

cursor not closing

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

ORA-00600 while running query

: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E

8.1.6

experience. Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

system requirement for performance testing

the reason for each request. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: Data Transfer to Oracle 8i from SQL server 6.5 and back

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: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: starting up 8i on Win2000 Problems

(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Why are my indexes being ignored?

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: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network

help needed in data datatype

Hi, I have a table with colum defined as date datatype..for example create table dd(dd date); when we insert into this table like : insert into dd values('04-jul-01'); when we do select as: select to_char(dd,'DD-MON- HH24:MI:SS') from dd; the result displayed is : TO_CHAR(DD,'DD-MON-Y

Stand alone Procedure v/s Package Procedure

Hi, What are the advantages/disadvantages of using procedures in a package as compare to stand alone procedures in application. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network

lock problem

the batch updates. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

ERROR IN INSTALING PATCH 8.1.6.3.0

might be the reason. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED

: mts_dispatchers = TCP,5 mts_max_dispatchers=50 mts_servers=20 mts_max_servers=50 LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000) (Port=1521))) Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL

MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED

: mts_dispatchers = TCP,5 mts_max_dispatchers=50 mts_servers=20 mts_max_servers=50 LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000) (Port=1521))) Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL

RE: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED

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

RE: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED

mts_servers=20 mts_max_servers=50 LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000) (Port=1521))) Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858

listener problem......

TNS-12541 no listener why is it trying to use listener on port 1521 while local_listener specified 1526... How to resolve the problem... Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat

RE: listener problem......

specified 1526... How to resolve the problem... Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: listener problem......

ONLY 1 PORT 1526 SPECIFIED IN TNSNAMES.ORA.. -Original Message- Sent: Wednesday, July 25, 2001 5:02 PM To: Multiple recipients of list ORACLE-L Do you have the second port defined in your tnsnames.ora? -Original Message- From: Harvinder Singh [mailto:[EMAIL PROTECTED

ora 12704 - character set mismatch when select nvarchar2 column

Title: Oracle pricing Hi, I have a table t_base_props with 3 columns defined as NVARCHAR2(256)... When i try to select directly from table like select nm_display_name from t_base_props...the query is properly executed but when i try to use ncarchar2 columns in follwing query i am

what is wrong in query

Title: RE: STOP THE PRESS!! Hi, I have a table t_acc_usage having column tx_batch defined as raw(16).. when i am running the following code i am getting error: SELECT ( (SELECT count(usage.id_sess) from t_acc_usage usage WHERE usage.tx_batch = hex_to_raw (ltrim('%%VARBIN_BATCH_ID%%',

  1   2   >