RE: Old INACTIVE and KILLED sessions

Henry, I have found that on certain versions of Oracle on NT (specifically 8.1.6) that expiry time does not work. So if you set this parameter in SQLNET.ORA and you do not see dead connections being removed then you're probably experiencing the same bug (acknowledge by Oracle support but they see

RE: Anyone used Fail Safe for NT?

Earl I've just done it on a 2 node Win2k cluster but supporting a single database - and it REALLY was easy. Can't see any reason why it shouldn't be easy with more than one DB onthe cluster. Regards -Original Message- Sent: 05 March 2001 22:46 To: Multiple recipients of list ORACLE-L

Woohooo An ORA-600

Hi Guys & gals, Today - I got my very first ORA-600 error - Who, I tell ya guys I'm so excited.. lol.. Now Because this is a test instance I don't really give a stuff whether I lose it or not, it seems to be up and running just fine, without any real problems. The only annoyance with hav

RE:can not mount database Exclusive

Shut down the database first and startup in exclusiv mode Chhers Ganti --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are n

RE: NUMBER datatype

99 > This is an elementary q. > > If i have a col of NUMBER data type what is the last number > that can be > stored > in this col. > > Ravindra > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ravindra Basavaraja > IN

RE: Old INACTIVE and KILLED sessions

You can also use profiles to do this. With profiles you can not only limit the amount of time connected, but also the ammount of resources the user can take. Before you start playing with these, make sure that you set the init parameter: RESOURCE_LIMIT = TRUE Then to create a profile: create pr

Re: _Help_Massive_Thangs !!!!

Sir Pather, the database is running on Oracle 806 and I have never used 8i before, except installing it. As I said before, auditing was switched on, but for only session. i.e. It tells you who logged on the system at what time but the action he/she is performing or performed. I still have to enabl

session commits when PC crashes

List, the oracle session will commit if the session is terminated by closing the window or re-booting the PC etc is there a way (parameter) to prevent this ? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Net

PLEASE HELP : Advanced replication question

Dear list ! Could not find this in the docs : it looks like i can replicate tables only among schemas with same names in different DBs    ( I.e i can only replicate SCOTT's objects into SCOTT schemas in remote DBs) Is this true ? If not , please advice what

RE: Old INACTIVE and KILLED sessions

Indeed I'd forgotten about them! However, in my experience this will only mark the session as being SNIPED - the disconnect will only happen when the user tries to do somthing after the SNIP has occurred. This can be a pain if the session is idle due to network failure, application GPF etc. Howeve

sqlforms3.0 error

Hi, I have created a database link between oracle 7.1.6 and oracle 8.1.6 I am running sqlforms3.0 from oracle 7.1.6 and accesing the database of oracle 8.1.6. I am encountering the following error when i am running the form "FRM-40505: ORACLE error -- unable to perform query". The error is execu

RE: Oracle Licensing

As luck would have it I was evaluating the prices of Oracle and then SQL Server today. My question at this point is, what kind of prices does Microsoft charge for support, I was pretending to purchase SQL Server and noticed that no mention is made about product support. Using the "Power Un

Re: session commits when PC crashes

Hi Rahul ! I guess it is not like that. Unless you enable autocommit your session will not commits on PC-crash or reboots. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, March 06, 2001 3:55 PM > List, > the oracle session will commi

Re: Oracle Licensing

Oracle has been riding the concept of "we're oracle so you want to use our database" for a long while. I'll be one of the last to condone sql-server(as i've recently had to work with it for a client, and i talked up oracle for a while) but Mr Larry is losing market share, check out any of the fin

Re: Woohooo An ORA-600

As i sat around and read the kernel source code(hahaha just kidding, although some days it would be easier to do that than work with metalink), here is what metalblank came up with: Note:109595.1 ALERT: ORA-04045 and ORA-600 [4882]on startup after applying 8.1.6.1.x patch Ty

RE: Old INACTIVE and KILLED sessions

Beware that SNIPED sessions could last forever when you limit the IDLE_TIME whether the users couldn't connect through the same connection. F.e. when you use sqlplus. Although the other profile limits work fine. Regards. > -Mensaje original- > De: Tim Onions [SMTP:[EMAIL PROTECTED]] >

RE: Woohooo An ORA-600

Hi Joe, Thanks for this, it seems it is this exactly, as it is being reported in the alert log on every instance of a startup. Attached is the trace file for your review - looks like a complete load of rubbish to me:) Thanks for your help.. Regards Mark -Original Message- Testa Sent:

RE: Old INACTIVE and KILLED sessions

I noticed last night that there is an item in the latest Oracle mag re. killed sessions. Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Trassens, Christian [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 7:35 AM

CDI-21600: A running generator or utility has failed...

Hi guys, I am getting the following (Designer 6.0, Win2000pro, 128MB RAM) generator error after generation tutorial module: CDI-21600: A running generator or utility has failed , It is Possible that the internal cache is now incosistant state. The message window after generation looks like this

Near-table/far-table join problem

We have a report running on database NEAR using table N1. This report does a join to a view in another database - FAR - using a database link to a view of a table F1_V. Fron SQLPLUS on NEAR I can select * from F1_V@FAR no problem. But when I do select * from N1 N, F1_V@FAR F where N.col = F.c

RE: 8.1.6.0 install problem - SOLVED! (maybe) - Follow-on

Follow-on question :: The libm module is used during the make command. Our security wonk wants to know if we only need this during install so he can delete it from the run-time system. My guess is yes we only need it for install - e.g. this is not dynamically linked at startup of either the AI

Re: Oracle Licensing

At 03:35 AM 3/6/01 -0800, you wrote: >my .02 is the whole power unit thing is a good concept but the $$ per >unit is way outta whack. the only reason i say that is its been hard >for oracle to denote when people were using more than the licenses they >bought were being used. I had always setup t

Differences between CTAS and alter table MOVE

HI: Can anyone the pros and cons of using the CTAS approach to reorganizing a table as compared to the alter table move command Oracle 8.1.5 tables size roughly 8gb Thanks __ Get your own FREE, personal Netscape Webmail acco

RE: Near-table/far-table join problem

Create a synonym for F1_V@FAR and reference the synonym in your query. Durinda -Original Message- Sent: Tuesday, March 06, 2001 6:46 AM To: Multiple recipients of list ORACLE-L We have a report running on database NEAR using table N1. This report does a join to a view in another datab

RE: Woohooo An ORA-600

Sorry list for the waste of bandwith there, I meant to send this direct to Joe, but forgot to change the address.. All this talk of ORA 600 's huh :0) -Original Message- Sent: Tuesday, March 06, 2001 12:21 To: Multiple recipients of list ORACLE-L Hi Joe, Thanks for this, it seems it i

RE: Old INACTIVE and KILLED sessions

Yeah I saw that too, the upshot being that you cannot speed the process of scrubbing these entries from v$session as they may be doing a long running rollback, but they will no longer hold any locks.. In 8i anyway.. As PMON will pass this process on to SMON to clean the processes up.. I also noti

Oracle Masters program

Does it still exist? I can't find reference to it anywhere in the new www.oracle.com layout. I am just curious - I had major problems with it when they informed me that taking Microsoft courses on NT wasn't good enough, to be certifiable as an Oracle on NT Master you had

RE: Woohooo An ORA-600

I have a similar sort of problem on 8.1.6 database which is Java enabled. Every time I startup or shutdown the database trace files are created and also errors in the alert log file. Trace file message is like this - although when I checked select * from dba_objects where object_name like '

8.1.7. Intelligent Agent

Where could I download a copy of just the 8.1.7. IA? OEM 2.2. happily tells me that I should use this version to monitor NT-related events. Too bad Oracle doesn't bundle the latest agents with the OEM package. Now I'll have to download Oracle 8.1.7. Patrice Boivin Systems Analyst (Oracle Cert

RE: 8.0 / 8i Bang for the Buck Features

This is not really what you are looking for, but may help -- the book "Oracle8 Design Tips" by Dave Ensor and Ian Stevenson had a good summary of the usefulness of the Oracle8 features for designs. This is 8.0, though, not 8.1. HTH, Diana -Original Message- Sent: Monday, March 05, 2001

Re: Anyone used Fail Safe for NT?

This was for a single database on a Compaq cluster (active/passive) but I don't see any problems with multiple databases.. I didn't do the install of failsafe, but it looks pretty straightforward. I got called in because the database wasn't failing over to the other server in the cluster. I had

bitmap index problem

Hi all, When I tried to build a bitmap index (8.1.5), I got this: ERROR at line 1: ORA-00439: feature not enabled: Bit-mapped indexes The error desc is: SQL> !oerr ora 439 00439, 0, "feature not enabled: %s" // *Cause: The specified feature is not enabled. // *Action: Do not attempt to use

RE: Oracle Licensing

Dennis, we have been through this over here in the UK too. It is Either Universal Power Units (UPU) OR Named Users, you would normally purchase the lower unless the figures were so close that you might as well go for unlimited users, especially if you expect to need more named users in the futu

RE: exporting MDSYS schema from an Oracle Apps 11i database?

Somewhere in the rdbms stuff (I can't remember where anymore) there should be a script to create MDSYS and ORDSYS. These should be used instead of exp/imp. >>> [EMAIL PROTECTED] 03/05/01 06:46PM >>> >-Original Message- >From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] >Sent: lundi, 5.

Re: bitmap index problem

Hi Leslie, What is your COMPATIBLE parameter set to in the init.ora file? -Rocky --- Leslie Lu <[EMAIL PROTECTED]> wrote: > Hi all, > > When I tried to build a bitmap index (8.1.5), I got > this: > ERROR at line 1: > ORA-00439: feature not enabled: Bit-mapped indexes > > The error desc is: > S

RE: Oracle Licensing

At 04:36 PM 3/5/01 -0800, you wrote: You should be able to find it at: http://store.oracle.com Thanks. It was that simple. [sigh] Shoot me now. Dennis Taylor In any human endeavor, once you have exhausted all possibilities and have failed, there will

RE: Oracle Licensing

Well, if you don't want product updates/upgrades for Oracle then you can knock about $15K off of that $45K for Oracle (and with SQL Server it looks like you can only upgrade the user licenses and not the processor licensing--looks like to upgrade you'd have to buy the new version anyways). Now for

RE: Oracle Masters program

As to whether or not it still exists...this should answer your question: http://education.oracle.com/masters/index.html -Original Message- Sent: Tuesday, 06 March, 2001 9:05 AM To: Multiple recipients of list ORACLE-L Does it still exist? I can't find reference to it anywhere in the n

RE: Oracle Licensing

At 03:00 AM 3/6/01 -0800, you wrote: > >As luck would have it I was evaluating the prices of Oracle and then SQL >Server today. > >My question at this point is, what kind of prices does Microsoft charge >for support, I was pretending to purchase SQL Server and noticed that no >mention is made

RE:CDI-21600: A running generator o

I faced the same problem. Just check the Oracle home in your registry. Otherwise Reinstall Designer on client machine. Cheers, -Anup -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Re: Oracle Licensing

Ingres used to do that for expiration date... you had to enter an authorization string when you installed the database. It would check and refuse to come up if the software expired. Except they a) never warned you you were close to expiration b) usually shut you down around 10AM EST so people

Oracle Long data type PROBLEM

Hi, I can't update or insert a table with long raw column. i have a error message : "ODBC Error Code = S1090 (buffer length) [Oracle][ODBC Oracle Driver] buffer length." thanx for your help :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: benajam lhoussain INET:

RE: Oracle Masters program

Program still exists, although Masters requirements change somewhat frequently, and at times are misleading. For instance, I'm pursuing Enterprise Scalable Master certificate and was under the impression that only 3 Master courses were needed, including Data modeling one. To my surprise, Oracle ki

Hi-speed data link

Hello, For some reason, I was under the impression that it was not that unusual to achieve a data transfer rate of 100-200GB/hour over some sort of data link between separate machines. However, I am finding it hard to confirm this. There is an individual here who claims this is not practical with

RE: bitmap index problem

Hi Leslie, It seems to be Standard Edition. You need EE for bitmap idx to be enabled. Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday, March 06, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Hi all, When I tried to build a bitmap index (8.1.5), I got this: ERROR

What database can I migrate to for Des/2000?

I have a 7.3.4 Oracle database (called CASE) on my Sun Solaris 2.6 operating system that contains my Des/2000 R2.1 repository. I'd like to migrate the 7.3.4 CASE database to 8.1.5. My question is this: Can the Designer/2000 R2.1 repository be hosted in an 8.1.5 database? If yes, do I have to

RE: exporting MDSYS schema from an Oracle Apps 11i database?

MDSYS and the others were created automatically when I created a 8.1.7 rel 3 database on NT 4.0 sp6a. The user MDsys ownes the tables: CS_SRS, MD$ (various) OGIS_GEOMERTY_COLUMNS, OGIS_SPATIAL_REFERENCE_SYSTEMS, SDO_GEOM_METADATA_TABLE, SDO_INDEX_METADATA_TABLE, USER_CS_SYS I have not done any t

RE: Oracle Licensing

Looking for a job in Oracle sales? This is a pretty convincing argument. Thanks for the additional info. >Jeffery Stevenson - [EMAIL PROTECTED] on 3/6/2001 10:10 AM writes us: >Well, if you don't want product updates/upgrades for Oracle then you can >knock about $15K off of that $45K for Or

Startup / shutdown using SQLPLUS

Hi: I am trying to startup and shutdown a remote database on NT using SQLPLUS. I can shutdown alright but while attempting to startup I get ORA-12154. I am connecting as internal . What am I doing wrong? Manas. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manas D

oracle-l@fatcity.com

Hi, What is the best way to Insert when we have '&' as part of our string. I want to frame INSERT statements such as the one below, and pass on to the user. insert_customers.sql: INSERT INTO customers (customer_name) VALUES ('Sun Microsystems'); INSERT INTO customers (customer_name) VALUES ('

RE: What database can I migrate to for Des/2000?

Only 8.1.7 version is not supported for Des2000 repository. You can migrate the existing v7.1.3 repository without any problem with migration utility or any means of migration. should work. -Original Message- Sent: Tuesday, March 06, 2001 1:16 PM To: Multiple recipients of list ORACLE-L

Oracle Installation on DiskArray -

Hi,   My company is planning to install Disk Array on Solaris. After that, I am going to install Oracle.   I just wanted to know whether is there any special consideration or steps to be taken to install Oracle on this Solaris? If so what are the steps? Where can I get that steps from?   I a

Re: Oracle Licensing

Sorry folks, I love Oracle, but UDB is getting attention, and IBM is giving their clients good old fashioned "customer service with a smile"... Original Message Follows From: "Joseph S. Testa" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMA

Mixed case table in Pro*Cobol

Trying to access a table via a DB_LINK. The table is mixed case so need the double quotes. SQL*Plus likes the statement but Pro*cobol apparently gets confused by the quotes. Any suggestions. 1784 EXEC SQL Error at line 1785, column 55 in file interface.PCO 1785

RE: [Q] why sequence number jump?

do ALTER SEQUENCE xxx nocache; -Original Message- Sent: Tuesday, March 06, 2001 2:35 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] We have ORACLE 8.1.6 on UNIX server. The database has been run 4 years no sequence number probem. Recently, user complaint on couple of sequence nuber jum

RE: Oracle Licensing

> NOT happy making for the DBA (me) Yeah, what if you needed a "temporary install" on a new machine to test something? Am I really expected to get a license for a temporary install? Suppose you want to test some UNIX parameters and you can't use the "Development" or "QA" servers? (Not to mention

oracle-l@fatcity.com

use SET DEFINE to assign a different character than '&', such as: SET DEFINE ! >>> [EMAIL PROTECTED] 03/06/01 03:07PM >>> Hi, What is the best way to Insert when we have '&' as part of our string. I want to frame INSERT statements such as the one below, and pass on to the user. insert_custom

RE: [Q] why sequence number jump?

Or, just say, "So what"? >>> [EMAIL PROTECTED] 03/06/01 03:13PM >>> do ALTER SEQUENCE xxx nocache; -Original Message- Sent: Tuesday, March 06, 2001 2:35 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] We have ORACLE 8.1.6 on UNIX server. The database has been run 4 years no sequence nu

rename database

Title: rename database Hello everyone - Is it possible to rename a database without recreating the controlfile?  I have a feeling it isn't, but can someone verify? Thanks Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL  33

Marc Andreessen speaks frankly at Oracle AppsWorld / RE: Oracle Licensing

re: Andreessen says software companies, customers act as adversaries backgrounder: ---begin excerpt--- http://www.infoworld.com/articles/hn/xml/01/02/22/010222hnandreessen.xml?p=br&s=4?0226mnlv (url may wrap) Thursday February 22, 2001 "NEW ORLEANS -- Marc Andreessen may have crea

RE: Oracle Licensing

My understanding of oracle licensing is that you pay (and pay and pay) for production, and sometimes test (kind of depends on if you are also using test as a backup of production), but not for development. So you buy support, licenses, etc. for the production boxes. Hence, the availability of fr

RE: rename database

Title: rename database Hi, Lisa, You can change database global name, but db_name change requires controlfile to be recreated.   Vadim Gorbounov Oracle DBA -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 06, 2001 3:40 PMTo: Multiple recipi

RE: [Q] why sequence number jump?

Sorry, overlooked this -Original Message- Sent: Tuesday, March 06, 2001 3:31 PM To: Multiple recipients of list ORACLE-L Or, just say, "So what"? >>> [EMAIL PROTECTED] 03/06/01 03:13PM >>> do ALTER SEQUENCE xxx nocache; -Original Message- Sent: Tuesday, March 06, 2001 2:35 P

RE: Oracle Licensing

I just went through this with Oracle and they want $$$ for all servers you are using; Production, QA, Test and development. -Original Message- Sent: Tuesday, March 06, 2001 2:40 PM To: Multiple recipients of list ORACLE-L My understanding of oracle licensing is that you pay (and pay and

Oracle Data Guard

Hi Gang, Can anyonepoint me to some documentation for this product? Technet seems pretty limited. TIA, -Rocky __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FA

RE: Oracle Licensing

That is also my understanding. You can download free stuff for 'play' purposes but not for commercial uses. Gotta pay for everything. Hey man, yachts are expensive. Jim >>> [EMAIL PROTECTED] 03/06/01 04:02PM >>> I just went through this with Oracle and they want $$$ for all servers you are u

oracle-l@fatcity.com

Title: RE: Insert & > -Original Message- > From: Krishna Rao K [mailto:[EMAIL PROTECTED]] > Sent: mardi, 6. mars 2001 12:07 > > What is the best way to Insert when we have '&' as part of > our string. I > want to frame INSERT statements such as the one below, and > pass on to the

RE: EMPTY_CLOB() call

Title: RE: EMPTY_CLOB() call > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: lundi, 5. mars 2001 12:37 > > Does anyone see error ORA-600 [19942] and ORA-600 [19944] > when the user try > to make the function call: EMPTY_CLOB() in and update statement

RE: Mixed case table in Pro*Cobol

Title: RE: Mixed case table in Pro*Cobol > -Original Message- > From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED]] > Sent: mardi, 6. mars 2001 12:07 > > Trying to access a table via a DB_LINK.  The table is mixed > case so need the double quotes.  SQL*Plus likes the statement > but

RE: 8.1.7. Intelligent Agent

You can get it from Oracle 8.1.7. distribution - do the custom installation and install only IA. Alex Hillman > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Boivin, > Patrice J > Sent: Tuesday, March 06, 2001 11:40 AM > To: Multiple recipients of li

RE: exporting MDSYS schema from an Oracle Apps 11i database?

Title: RE: exporting MDSYS schema from an Oracle Apps 11i database? > -Original Message- > From: Tim Sawmiller [mailto:[EMAIL PROTECTED]] > Sent: mardi, 6. mars 2001 07:25 > > Somewhere in the rdbms stuff (I can't remember where anymore) > there should be a script to create MDSYS and

OT RE: Marc Andreessen speaks frankly at Oracle AppsWorld / RE: O

Title: OT RE: Marc Andreessen speaks frankly at Oracle AppsWorld / RE: Oracle Licensing Nice. Make a cool hundred million, and THEN complain. But, I do agree w/Marc. ( I call him "Marc" only because he is a close personal friend. ) Guess we never DO hear from the "good guys" who do it ri

Re: Differences between CTAS and alter table MOVE

Hi If you have constraints enabled (primary, unique and referential), then CTAS approach needs reenabling them in the new table. This will take longer. But alter table does not need to disable or enable the constraints and hence alter table move would be more preferable.. Thanks Riyaj "Re-ya

Re: RE: rename database

Lisa - You can always keep the same db name on a different server and change the tnsnames.ora file to reference either db server. also set global_names=false. just my $.02 >>> [EMAIL PROTECTED] 03/06 4:02 PM >>> Hi, Lisa, You can change database global name, but db_name change requires contro

Re: OPS on AIX/rs600

Hi! This is our precise condition! For the last month IBM guys have been 'trying to give' us the planned hardware solution!! Please let me know about ur 'journey'! For starter a. Find out how IBM plans to provide u with 'shared disks' Please let me know their response!!! b.

More Metajunk frustration (at end of a long day...)

All, For those of us paying tens to hundreds of thousands of dollars for support, can we sue Oracle for not honoring support contracts and get rich quick? Considering that it's near impossible to create a tar, is this not a valid thought? And if we can't get rich quick, can we force them to no

RE: Old INACTIVE and KILLED sessions

Yes. Sniped sessions are not being cleaned out properly by pmon. We kill the os process associated with the connection using the following script and pmon cleans up after that . $ORACLE_HOME/bin/sqlplus -s / < $TMPFILE set pages 0 set feedback off select p.spid from v\$process p,v\$session s whe

RE: More Metajunk frustration (at end of a long day...)

Title: RE: More Metajunk frustration (at end of a long day...) MetaLoo MetaFoo that's great.. -Original Message- From: Yosi Greenfield [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 5:16 PM To: Multiple recipients of list ORACLE-L Subject: More Metajunk frustration

RE: Oracle Licensing

Eek. Yup, just looked at the licensing stuff on the website, and you seem to be right. Just did an inventory of my boxes, too, and believe it or not, I'm fully licensed. Weird. Believe me, that's through no fault of my own. ;-) Diana -Original Message- Sent: Tuesday, March 06, 2001 4

RE: Oracle Licensing

What about support? No one has addressed that yet. -Original Message- Duncan Sent: Tuesday, March 06, 2001 2:51 PM To: Multiple recipients of list ORACLE-L Eek. Yup, just looked at the licensing stuff on the website, and you seem to be right. Just did an inventory of my boxes, too, a

Oracle Installation on DiskArray

Hi,   Thanks to those who replied. I was wondering whether which RAID level to implement.   My database is not a very critical 24x7 database. It is a development database. There are going to be only a few users accessing this database. Infact the data as such is not very important as it is te

RE: NUMBER datatype

Hi Ravindra, The largest value the can be stored in an Oracle NUMBER column is 9.999e+125. If you use greater precision (and thus larger values) in INSERT and UPDATE statements they will either round down (silently) to this value or return an ORA-01426 (numeric

To paraphrase Mark Twain..

Lies, damned lies, statistics, damned statistics, and benchmarks. http://www.infoworld.com/articles/op/xml/01/03/05/010305opcringely.xml (paragraph named 'the redmond menace') Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL

RE: 8.0 / 8i Bang for the Buck Features

Diana, Good to see you back on the list. One of the DBA's has that book and will review it for applicable performance related info. I was able to get a couple of examples from Technet where they benchmarked a procedure using bulk binds against the same procedure not using bulk binds. The same ty

RE: can not mount database Exclusively

try connect internal first -Original Message- Setiawan Sent: Tuesday, 6 March 2001 1:25 PM To: Multiple recipients of list ORACLE-L Hi guys, I'm a beginner in Oracle. When I try to startup database via SVRMGR , there's error : "can not mount database Exclusively" Anybody knows why

Product for Field level security

Hi Guys, I am in need of solutions and ideas. We are developing a Datawarehouse and need to implement "Field level security". Read not Fine grained access control. We shld be able to control which application role shld see which fields from a table. Now the number of application roles can be c

Re: bitmap index problem

Rocky, compatible is compatible=8.1.5 --- Rocky Welch <[EMAIL PROTECTED]> wrote: > Hi Leslie, > What is your COMPATIBLE parameter set to in the > init.ora file? > > -Rocky > > --- Leslie Lu <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > When I tried to build a bitmap index (8.1.5), I > got >

How to kill Oracle 7 processes in Open-VMS (STOP /ID command does

Hi, I tried to kill the following process with the command => stop /id=0432, the process is still there. Any ideas how to kill the process ? Please advise. DS9_DEVDBA> show system OpenVMS V7.1-2 on node NIEDS9 7-MAR-2001 10:10:11.73 Uptime 3 17:40:37 PidProcess NameState Pri

error after creating second database

Wahai Guys, I created second database using Database Assistant on NT. There's no error when I create this 2nd DB. Then I make a host-string name 'dblokal2' for my second database. I can connect to my second db , but there's an error : the message written below : SQL> conn beng/bambang@dblokal2;

RE: No record in import help me please :..<(

Hi guys, Thank You Durinda.Jones Don.Jerman Dave Weber Gillies Garry Raghu Kota Ruth Gramolini Mohan, Ross And to all readers.. What I am doing now is to try write my own backup script and test it in my stand alone Sun Ultra 10 with Solaris 2.7 and Oracle 8.1.6 Thank you guys, for giving me sol

RE: No record in import help me please :..<(

Hi, Just some thoughts - at step 7 did teddy commit after the delete - if not other users / sessions would still see the records as present. The import found some records so their must be an emp somewhere. So, try another step from your dba account (sun) of select object_name, object_typ

Re: error after creating second database

READ the screen it tell you what to do: HINT: > You may need to run PUPBLD.SQL as SYSTEM Does it get more easier than that? if you dont understand, break out the documentation and start reading. joe Bambang Setiawan wrote: > > Wahai Guys, > > I created second database using Database

Connected users ??

Hi guys, It is possible to list all user that currently connected to my Oracle8i ? and what is the command or script or source of information ? Thank you, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: error after creating second database

"You may need to run PUPBLD.SQL as SYSTEM" seems pretty clear to me: NT inclined: set oracle_sid= sqlplus connect system/manager @%ORACLE_HOME%\sqlplus\admin\pupbld.sql; REM @D:\Oracle\Ora81\sqlplus\admin\pupbld.sql quit Paul Bambang Setiawan wrote: > > Wahai Guys, > > I created second dat

Comparison between BMC Patrol and some other performance tool

Hello every one, This one is may be a bit off topic but an important topic, for me at least. Is there some one out there who has made a comparitive analysis between BMC Patrol and some other performance tool? If some one has a report like that, would really like to see that report. I need to

Re: 8.0 / 8i Bang for the Buck Features

Larry, Watch out for non-unique table aliases used in a multi-tiered statement. (particularly if you're rolling statements dynamically) Query re-write needs to have the table (or inline view) aliases unique. That was the only hitch that I saw when upgrading from 7.3.4 to 8.1.6. Paul [EMAIL PRO

RE: Connected users ??

v$session will tell you this Try something like the following. Regards, Bruce Originally from Deepak Thapliyal on this list and since modified number of times by me. --- start here --- set pagesize 40 set linesize 500 SET FEEDBACK ON col username format a14 wrap col osuser format a11 col ter

Re: Connected users ??

Hi. I'm going to assume that you're running on NT and have OEM available. Try this: connect with DBA Studio expand the tree under Instance >> Sessions start sqlplus and run this set long 1000 set pagesize 999 select sql_text from v$sqlarea where sql_text like '%/* OracleOEM */%' / you'll

Comparison between BMC Patrol and some other performance tool

Hello every one, This one is may be a bit off topic but an important topic, for me at least. Is there some one out there who has made a comparitive analysis between BMC Patrol and some other performance tool? If some one has a report like that, would really like to see that report. I need to

Re: Product for Field level security

Check out www.teleran.com I believe their product(s) will do what you ask. Jared On Tue, 6 Mar 2001, Mandar Ghosalkar wrote: > Hi Guys, > > I am in need of solutions and ideas. > > We are developing a Datawarehouse and need to implement "Field level > security". Read not Fine grained access c

  1   2   >