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 tha

64-bit OS

ACLE-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 REMOV

char vs. varchar in a data warehouse

.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 from this mailing

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

Does anyone know what I can do to get the > installer to realize that I do have the server installed? > > Thank you - > Lisa > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: YTTRI Lisa &

AQ using a trigger?

lease 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

Upgrade and it says it doesn't need it

do to get the installer to realize that I do have the server installed? 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: (858) 538-5051 San Diego, Calif

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

se 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 / Mai

char vs. varchar2

thing, 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

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

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

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

RE: Database Recovery - any options?

it can 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 o

Database Recovery - any options?

ious day? 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: YTT

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

-- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name

Advanced Queueing

RACLE-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 R

RE: UPgrade or Reinstall ?

ted both from a time 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 --

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

UPgrade or Reinstall ?

Yttri 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 Inter

RE: BMC Patrol DBXray / CA Unicenter

#x27;) and in the message 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

RE: BMC Patrol DBXray / CA Unicenter

but they both seem to do a lot. I've been asked to look 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://

RE: BMC Patrol DBXray / CA Unicenter

ge 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 PROTECTE

RE: BMC Patrol DBXray / CA Unicenter

job... Just my .02 Lisa Koivu 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 U

BMC Patrol DBXray / CA Unicenter

rohibitive, 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

32-bit Oracle on 64-bit Unix

hanks- 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

Multiple instances - Sun Solaris

se 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 / Mai

RE: Oracle and MQ

issue 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

ndering 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

RE: OMW

ase 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: equivalent of LPAD in Transact SQL

I believe you would 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 inappropriat

RE: SQL Loader questions

ammer been 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 -

SQL Loader questions

ecial 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:

RE: ORACLE VS. SYBASE

g). -- 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 ---

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-- Publi

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 ta

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 c

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 datat

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 t

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 repl

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 hav

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

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

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

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

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 instinc

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 produc

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 [Note:

OT: ODBC version errors

Title: OT: ODBC version errors Hi everyone - I have several developers telling me that their web applications (some are purchased packages and some are developed in-house) do not work with Oracle ODBC drivers if they are version 8.  Every one of their applications seems to run fine with th

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

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 sa

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 exa

RE: RMAN

t thinkin outloud again.  -Original Message- 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 differen

RE: RMAN

Title: 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 instances.  I had installed 8.1.6 RMAN, but it won't let me register the 8.1.5 version in the catalog.  Does anybody know of a workaround - short of upgradi

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 8.