RE: Oracle AQ MQ Series

Title: RE: Oracle AQ & MQ Series Waleed - I tried implementing AQ to MQ with the MEssaging Gateway. I could not find anyone at Oracle to support it. When I would open a TAR, the analyst would come back and say 'this is not an Oracle product'. I finally got it escalated to the point that I

64-bit OS

: http://www.orafaq.com -- Author: YTTRI Lisa 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

char vs. varchar in a data warehouse

: YTTRI Lisa 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

RE: Upgrade and it says it doesn't need it

://www.orafaq.com -- Author: YTTRI Lisa 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

AQ using a trigger?

: http://www.orafaq.com -- Author: YTTRI Lisa 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

CA's Data Dictionary for Oracle v9i Poster

http://ca.com/products/posters/oraclev9i_poster_form.htm Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: Oracle Messaging Gateway

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

char vs. varchar2

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

Number of CPUs vs. Speed of CPUs

the number of CPUs should be? Thanks in advance - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Donald Burleson

Hi - Does anyone know if Donald Burleson has a website? If so, do you have the url? Has anyone read his book 9i Unix Administration Handbook? comments please... Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat

8.0.5 to 8.1.7 - export/import

database (using the 8.0.5 exp command) and then import into the 8.1.7 database on Unix (using the 8.1.7 imp command)? Thank you- Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Database Recovery - any options?

? This option is OK, since we are archiving, but it is time consuming because there are 8 databases on this machine, each with a large number of datafiles. I appreciate any help, comments and feedback! Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET

RE: Database Recovery - any options?

be avoided in the future. Jared YTTRI Lisa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/06/02 07:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Database Recovery - any options? Hi - We've

FW: rename foreign keys from system-assigned constraint names to

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

Advanced Queueing

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

UPgrade or Reinstall ?

Global Services Oracle Database Administration (262) 636-6797 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

oraInventory

IBM Global Services Oracle Database Administration (262) 636-6797 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: UPgrade or Reinstall ?

perspective and from the complexity of the tasks, as well as the probability that it will work. Thanks in advance for any input! Lisa Yttri IBM Global Services Oracle Database Administration (262) 636-6797 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa

RE: BMC Patrol DBXray / CA Unicenter

BODY, include a line 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: YTTRI Lisa INET: [EMAIL PROTECTED

RE: BMC Patrol DBXray / CA Unicenter

at alternatives (I'm sure the cost will be prohibitive, but we'll see). Also if you know of any comparable tools, I'm very interested to hear about them. Thanks much - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City

BMC Patrol DBXray / CA Unicenter

, but we'll see). Also if you know of any comparable tools, I'm very interested to hear about them. Thanks much - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: BMC Patrol DBXray / CA Unicenter

Certified Monkey Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: YTTRI Lisa [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 3:25 PM To: Multiple recipients of list ORACLE-L Subject: BMC Patrol DBXray / CA Unicenter Hi - Does anyone have experience

RE: BMC Patrol DBXray / CA Unicenter

(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: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

32-bit Oracle on 64-bit Unix

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

RE: Oracle and MQ

SQL to get it into the database. HTH Tony Aponte -Original Message- From: YTTRI Lisa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 11:50 AM To: Multiple recipients of list ORACLE-L Subject: OT: Oracle and MQ Hi - Does anyone have experience with using MQ w

OT: Oracle and MQ

this, but this means creating all our own error logic, etc. Does AQ fit into this scenario at all, or is that primarily for non-middleware queues? Any information / insight would be greatly appreciated. Thanks - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI

8i or 9i for Data Warehouse

if any of you have some advice (good or bad) regarding version 9. Any and all comments are appreciated. Thanks - lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: OMW

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

RE: equivalent of LPAD in Transact SQL

I believe youwould use the 'stuff' command. -Original Message-From: Suhen Pather [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 24, 2001 9:55 PMTo: Multiple recipients of list ORACLE-LSubject: equivalent of LPAD in Transact SQL List, Bit of an inappropriate

SQL Loader questions

keyword to do this - I can't seem to find anything on that either? Thanks in advance for any help you can give me. Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: SQL Loader questions

reading? as far as I know you can't add a column on the fly through a sqlloader control file, nor will oracle do an update to existing data. I'm not an expert, but I've never been able to do that --- YTTRI Lisa [EMAIL PROTECTED] wrote: Hi everyone - I need some help. We have an application

Recall: ORACLE VS. SYBASE

YTTRI Lisa would like to recall the message, ORACLE VS. SYBASE. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: ORACLE VS. SYBASE

-- Author: YTTRI Lisa 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

Import of sequences

Title: Import of sequences Hi - I have inherited an application and I'm trying to clean it up. I have received an export from the current database (to which I have no access). Everything was built as user SYSTEM. I can import all the tables and data onto a new server by listing all the

ksqsttyp in x$ksqst

Title: ksqsttyp in x$ksqst Hi - Where can I find out what the values mean in the ksqsttyp column on the x$ksqst table? I am having some waits associated with the value CF, but I don't know what that means. If anyone can help, I'd greatly appreciate it. Lisa

Oracle license costs

Title: Oracle license costs Hi - I'm sorry to bring this up again - I know it was discussed fairly recently .. Where can I find information on Oracle's new pricing structure? We are looking for additional licenses to run on a new Sun Solaris machine. I seem to remember that license

RE: Diffs in SQL*Plus formatting between 8/8i

Title: RE: Diffs in SQL*Plus formatting between 8/8i I noticed this same difference between versions 8.1.5 and 8.1.7. In 8.1.5, the substr() function (ie. select substr(column1,1,10) works just fine.but in 8.1.7 it seems to be ignored. Defining the column seems to take care of it. Lisa

sqlplus and substr command

Title: sqlplus and substr command Hi - Can someone tell me if sqlplus functionality has changed between version 8.1.5 and 8.1.7 (on Sun Solaris)? I have a couple of queries that used the substr function on some longer columns. When I run it against my 8.1.5 database, the substr works fine.

RE: CASE Expressions

Title: RE: CASE Expressions It must have been new with 8.1.6. I run it successfully on 8.1.6, but I get errors on 8.1.5. -- From: MacGregor, Ian A. To: Multiple recipients of list ORACLE-L Subject: RE: CASE Expressions Date: Monday, July 23, 2001 11:10AM CASE has been around since

Moving table with interMedia datatype

Title: Moving table with interMedia datatype Hi - I have a table that contains 1 column with an interMedia datatype (ordsys.ordimage) and a blob column. I want to move the data from the table in our test server to our production server. I don't think an exp and imp will work on these

Multiple Oracle Instances on NT

Title: Multiple Oracle Instances on NT Hi everyone - I have worked exclusively with Oracle on Unix, but not at all with Oracle on NT. Our users have come to us with a requirement to run an application with their database on NT. They want to build both a test and production environment on

RE: Oracle 8i database ER diagram

Title: RE: Oracle 8i database ER diagram Q-Designer is Sybase's PowerDesigner - same product, just remarketed by Quest. Although it's a good modelling tool for Sybase, it has its limitations when doing Oracle modelling. -- From: Adams, Matthew (GEA, 088130) To: Multiple recipients

Implementing Stored Procedures

Title: Implementing Stored Procedures Hi - I'd like some advice on implementing stored procedures containing application logic (ie. written by developers). We have several applications where the developers use stored procedures for much of their coding. We let the developers create or

OT: Tool needed for database access

Title: OT: Tool needed for database access Hi - We are a sybase and oracle shop. We are considering building a tool (probably web-based) to allow the Security group to set up new users and to allow the developers to add stored procedures as the schema owner, etc. We don't want them to have

Automatic password locking

Title: Automatic password locking Hi everyone - I am trying to implement a process on our production servers. If requested for emergencies, an id is automatically unlocked. This id was previously defined with all access (select, insert, update, delete) to all objects in a schema. I want

Free Java dba monitoring tool and Java source code

Title: Free Java dba monitoring tool and Java source code Hi - There was a post a couple of months ago from someone who had written this java tool and you could e-mail him to get a copy. Does anyone have his e-mail or a web site where the software can be found? Thanks - Lisa

Somewhat OT: Blobs and Ordimage types

Title: Somewhat OT: Blobs and Ordimage types Hi - We have an application group that is interested in storing documents in the database. Some of these documents are word docs or excel spreadsheets, while others are actual image files. We have looked into the interMedia ordimage type, which

Constraint dependencies

Title: Constraint dependencies Hi - When dropping and/or re-applying constraints for an entire schema, is there a dictionary table that can be queried (or some other way) to determine constraint dependencies - or do you just keep running the script until you do not get those errors? I would

BLOB vs. B-File

Title: BLOB vs. B-File Hi everyone - I'm looking for some information based on your experiences. We have an application that has large objects to store. They are wondering which way would be better - to store them as BLOBs within the database, or as bfiles outside the database. My instincts

FW: Dependent objects

Title: FW: Dependent objects Hi - Does anyone have (or know where I can find) a script to identify dependencies on a table? When we make table modifications, we would like to be able to run a script that recursively identifies dependent objects. We pulled one from Metalink, but it doesn't

Recovery Manager vs. SQL Back Track

Title: Recovery Manager vs. SQL Back Track Hi everyone - Currently we are doing backups manually, periodic cold backups, and hot backups in between - we are running in archivelog mode. We are running 8.1.5 and 8.1.6 (soon to be 8.1.7) on Sun Solaris. Today there are only a few small

Re: (Fwd) Use of third-party tools in Oracle environments [Note:4

Title: Re: (Fwd) Use of third-party tools in Oracle environments [Note:47292.1] Do you think this policy would apply to a tool like SQL BackTrack? -- From: Eric D. Pierce To: Multiple recipients of list ORACLE-L Subject: Re: (Fwd) Use of third-party tools in Oracle environments

export / import 8.1.5 to 8.0 ?

Title: export / import 8.1.5 to 8.0 ? Hi all - Is it possible to export an 8.1.5 database and import it into an 8.0.x database? Does the compatibility or anything else special need to be set in order to make this happen? Thanks - Lisa

RE: Extent allocation

Title: RE: Extent allocation I found a document on metalink #69343.1 that pretty much explains it. Unfortunately, it makes it sound like you can never be sure of the sizing you choose, because it looks at the size of the first two open blocks, rather than finding a block that fits what you

RE: RMAN

- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Yttri, Lisa Sent: Tuesday, February 06, 2001 4:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: RMAN Aren't there problems though, if you're running different versions? For example, we are running 8.1.6 and 8.1.5 database

Vendor Package Implementation Strategy

Title: Vendor Package Implementation Strategy Hi everyone - I posted this some time ago and didn't really get much response, so I'm trying again. For those of you that are implementing multiple application packages, how to you determine how many Oracle instances and servers to use? For

Extent allocation

Title: Extent allocation Hi - I am confused now about how oracle actually determines the size an extent should be. I have db_block_size set at 8192 and have defined a tablespace (and tables) at initial and next extents of 128K. When I do a show parameter db_file_multiblock_read_count it

RMAN

Title: RMAN Hi - I think I remember seeing this posted awhile back, but I do not remember the specifics. We have installed the RMAN catalog on an 8.1.6 server (UNIX). We are trying to register an 8.1.5 server, but it won't let us. I seem to remember that you have to run a script on the