Shared Pool fragmentation

variables, and keeping objects, but until I can modify all the apps, I would like to know a little before these errors happen.  Any ideas?   Thanks,   Rick Stephenson This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity

RE: table partitions

e the data/partition after it was 6 months old. Thanks, Rick Stephenson -Original Message- Sent: Tuesday, December 16, 2003 6:49 AM To: Multiple recipients of list ORACLE-L >From what I understood, he's asking how to put all January records in one partition, all Feb in another

table partitions

o partition the data. Thanks for your help, Rick Stephenson This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. This message contains confidential information and is intended only for the individu

Nested tables

in an Advanced Replication Environment.  The manuals say they support replicating nested tables, but do they really?   Thanks,   Rick Stephenson Oracle Database Administrator Ovid Technologies, Inc. [EMAIL PROTECTED]   This email and any files transmitted with it are confidentia

RE: Insert performance

I have already bumped that up quite a bit as well, but I still get many waits.   Thanks,   Rick Stephenson Oracle Database Administrator Ovid Technologies, Inc. [EMAIL PROTECTED]   -Original Message- From: Justin Cave [mailto:[EMAIL PROTECTED] Sent: Monday, September

Insert performance

uffer busy waits".   I have increased initrans, but am not sure where to go from here   Any ideas would be appreciated,   Thanks,   Rick Stephenson Oracle Database Administrator Ovid Technologies, Inc. [EMAIL PROTECTED]   This email and any files transmitted with it are co

RE: Importing Schema getting compilation errors on some

for the rest of the world to see - I love it here. http://www.nps.gov/glac/whatsnew/cam2_mcdonald.htm   Have an excellent weekend folks   Rick Weiss Helena, MT -Original Message-From: Scott Stefick [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 16:26To: Multiple rec

RE: Importing Schema getting compilation errors on some

Do you have execute privs set for MAILER.DBMS_OFFICE?? Does it exist on the second database?? Is the MAILER schema on the database? (I'm climbing my ladder of thoughts as I'd check them) Just a thought Rick Weiss Helena, MT USA -Original Message- Sent: Friday, April 04, 200

RE: Importing Schema getting compilation errors on some triggers

Scott: My first thought is to ask if there are any external references (other schemas, SYS packages, etc.) in the triggers that may not exist in TRAIN that do exist in TEST Rick Weiss -Original Message- Sent: Friday, April 04, 2003 13:14 To: Multiple recipients of list ORACLE-L Hello

Oracle OCI JDBC Driver Not Recommended for Multiprocessor Machine

th the OCI driver. On multi-processor configuations, synchronization points within Solaris used by the OCI driver become big bottlenecks and prevent scaling. We recommend using the thin driver in all cases.   Is this actually the case?  Does anyone have more information on this?   Thanks

Copying PL/SQL Objects

les, indexes on database B? I have thought about EXP/IMP, but the tablespace names do not match. Thanks Rick Weiss

Oracle JDBC thin driver

Oracle 9.2.0.2   Can the Oracle JDBC thin driver be used with RAC to setup failover and load balancing between instances in the same way the thick driver can?   Thanks,   Rick Stephenson   This email and any files transmitted with it are confidential and intended solely for

RE: POLL: Database to DBA ratio

Title: Message Not mention the afternoons at Big Sky and Bridger working as a ski run quality assurance tester!  ; )   Rick Weiss -- Helena, Montana   We know better -Original Message-From: Weaver, Walt [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 12:51To

RE: sql query: to_date() :ORA-01830: date format picture ends bef

You are comparing CHAR to DATE, you would need one of the following conditions 1- where DATECREATED = to_date('01-FEB-03 07:53:28','DD-MON-YY HH24:MI:SS') 2- where to_char(DATECREATED,'DD-MON-YYY HH24:MI:SS') = '01-FEB-03 07:53:28' to be able to complete

RE: Skill Sets - This may be a dumb question

my skills, but whatever it takes to keep the mortgage paid.   (Step down and don flame proof clothing)   Rick Weiss      -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 10:04To: Multiple recipients of list ORACLE-LS

RE: SQL question

exist. Thus, they both try and do an insert into the employee table. One will succeed and the other will fail. Is there away to avoid this scenario? I hope I made this a little clearer. Thanks, Rick Stephenson -Original Message- Sent: Monday, February 24, 2003 1:05 PM To: Multiple

RE: How long to hold onto old Oracle CDs?

Hey Tim: Which ones do you want?? V5 RDBMS on Macintosh??? I think I still might have a full set for that one available. I think I lost my Forms 2.0 and the Forms 2.3 addendum in my last move, but I might be per$uaded to venture to my storeroom to look for them. ;) Rick Weiss -Original

SQL question

?   Question:  How can I force connection B to wait for connection A to insert the new row before it does the select?   If I were updating the row, I could use the "for update" clause to force the wait.  Is there a clean way to do that for an insert?   Thanks for your help,   Rick

RE: Top 10 "normalised" down to Top 2

I would add a #3 to your list (yes my flame proof coat has been put on.) 3) Remember what is truly important in life (and if you can't think of anything important away from your workplace, you need to get away from the workplace.) My humble submission to such a list. Rick Weiss -Ori

RE: How long to hold onto old Oracle CDs?

Tim: I can't say that I can shoot BB's @ 10M, I prefer a .30 caliber @ 150 yds, although I must admit that I can't keep them inside the center hole at that distance. I do know they don't load worth a hoot with 3 or 4 extra holes in them ;} Rick Weiss -Original Messa

RE: Programming languages that make DBA's lives easier

FORTRAN - Only one or two of us left that have even heard of it, much less actually made $$$ using it Rick Weiss -Original Message- Sent: Thursday, February 20, 2003 10:59 PM To: Multiple recipients of list ORACLE-L Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote

RE: Teradata baned from IOUG???

The PHB is from Dilbert (Pointy Haired Boss) Rick Weiss -Original Message- Sent: Wednesday, February 12, 2003 8:04 PM To: Multiple recipients of list ORACLE-L PHB's? I looked it up and all I could find that fit was "Psycho Hose Beast". Is that correct? http://www.ac

RE: Oracle License for Training

A question for the DBA Gods on this list: Is it worth the time/effort to download MySQL and learn it? Is there going to be a viable (meaning $$) market for the product in the future? Or should I leave all the egg$ in the Oracle basket? Musing for fun and profit. Rick Weiss -Original

RE: Updating error

David: I would say that there is a foreign key on the originating_carrier column and the value 0110 does not exist in the parent table. Rick Weiss -Original Message- Sent: Tuesday, February 11, 2003 11:00 AM To: Multiple recipients of list ORACLE-L I attempt to update a record and

RE: Version Controlling in Oracle database - Ideas ?

th 15 developers working on various pieces of a system without problems. It does code management through a database repository, and it has a code debugger and analyzer available.   Rick Weiss   -Original Message-From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] Sent: Friday, Februa

RE: 8i: how to find current scn number?

ct * from scn; SCN - 98038268 1 row selected. 12:26:48 SQL> I hope that I haven't totally missed the question There's always more than one way to do the Oracle thing Rick Weiss -Original Message- Sent: Thursday, January 30, 2003 11:36 AM To: Multiple recipients of list O

RE: "Take Care of your DBAs"

iving Rick Weiss -Original Message- Sent: Thursday, January 30, 2003 9:01 AM To: Multiple recipients of list ORACLE-L You gentlemen do not know what it is like to have snow related traffic problems. In Atlanta a snow flake can cause a multi-car pileup with a 3 hour commute delay. Why just h

RE: "Take Care of your DBAs"

Although I might resemble that remark, I still welcome the opportunity to take fellow DBA's on a hike/hunt/fish expedition in Big Sky country. But you have to bring your own pepper spray and bear bells Rick Weiss -Original Message- Sent: Wednesday, January 29, 2003 3:30 PM To: Mul

RE: Case of the Missing Rows

Yes, only after an empty build from scratch No triggers at all on either table Rick -Original Message- Sent: Tuesday, January 28, 2003 11:34 AM To: Multiple recipients of list ORACLE-L swag -- is there a trigger on either of those tables? sounds like the possibility of an AFTER

RE: Case of the Missing Rows

up to mull over   No jobs scheduled except for RMAN level 0 on Friday mornings@ 5:30 and other daily level 1 cumulatives and a weekly full DB export on Fridays @ 2:30   Rick Weiss Oracle DBA -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28,

RE: Case of the Missing Rows

Title: Message Nope, .BAD file is empty, I have been experimenting this morning with cloning the table as suggested earlier, but every DDL statement against the table drops the rows (#'s 70-1417) of the ID PK Column. Still working on that angle   Rick Weiss -Original Me

Case of the Missing Rows

. There is nothing I have found in the UDUMP or BDUMP directories that would help. Has anyone else experienced this?? Thanks Rick Weiss

RE: Producing .mdb output from sqlplus or SQL or PL/SQL

Patrice: I have used the data extract function in EXCEL to select data from views and tables in my database using an ODBC connection. I imagine you could do the same thing from within ACCESS as well. You run the query and it populates the spreadsheet which can then be saved. Rick Weiss Oracle

Including properties in URL string

but the Oracle driver doesn't appear to allow this. Is it possible to pass properties in the URL String when using the Oracle JDBC thin driver? Perhaps I'm not using the correct syntax! Thanks, Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vaughn, R

RE: How to restrict a trigger from firing when the DML is done re

For advanced replication we have an IF statement to check if the DML came from a remote source: IF (DBMS_REPUTIL.FROM_REMOTE = FALSE) -- If the DML is local -- Do whatever it is you want to do END IF; Hope this helps. Rick Stephenson Oracle Database Administrator Ovid Technologies, Inc

RE: Mixing OLTP with DSS

needs. Thanks for the insight. Rick Stephenson Oracle Database Administrator Ovid Technologies, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 29, 2002 10:04 PM To: Multiple recipients of list ORACLE-L Rick - See the other message titled: Adhoc queries and limiting the amou

RE: 9i RAC

much until you actually see it running in your environment. I'm not concerned though because the sales people tell me it's the best thing since sliced bread. :) Rick Stephenson Oracle Database Administrator Ovid Technologies, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tue

Mixing OLTP with DSS

would be helpful.   Thanks,   Rick Stephenson  

Selecting a variable similar to a column

:= 'rick';    lv_LastName := 'stephenson';    dbms_output.put_line(lv_FirstName||' '||lv_LastName); end; /     be written something like this:   declare    lv_FirstName varchar2(20);    lv_LastName varchar2(20); begin    lv_FirstName := 'rick';   

Changing the SID of a database

the new db that way? Thanks for any help. Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Strange problem deleting rows

I created a procedure to remove up to 2.4 million records out of a 13+ million record table with bulk binds and forall. Figured that would be the fastest way. While doing this delete, other processes were accessing the table, but not the rows that were being deleted. Things went fine. Eventual

8i and Veritas NetBackup

Is anyone using this combination? We're having problems getting backups to work with 8i. It works fine with our 8 dbs, but when we try to backup the 8i ones, the control panel says the backup has started, but it doesn't finish and usually has a dead rman process on the db. We've working with V

Oracle error ORA-04031

I'm getting an ORA-04031: unable to allocate 8192 bytes of shared memory ("large pool","unknown object","sort subheap","sort key") error, and am having a hard time solving the issue. The SQL being ran is: SELECT COUNT(DISTINCT mail) theCount FROM Demo D WHERE (EXISTS (SELECT 1 FROM mails WHERE

How to do a bulk bind to load data into a table

I'm looking at a way to speed up a huge insert (100K records at a time). In looking at FORALL, it looks like it could do what I want, but I'm not sure how to set it up correctly. What I currently do is: set up a cursor, selecting the rows from table a for cursor_rec in cursor_data loop inser

RE: Export Problem - Urgent

You should try changing the nls_lang value on the client to match the server. Rick -Original Message- Sent: Friday, November 30, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Hi, I am trying to export a data from server and getting following error message: EXP-00041

RE: Script to Disable Constraint, Change Value, then Enable Const

David,   You need a semi-colon after line2 i.e., update table1 ...;   Rick -Original Message-From: David Wagoner [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 28, 2001 1:16 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Script to Disable Constraint, Change

RE: Doubts reg :Export and import

compress=y means all the extents will be compressed into a single extent. It has nothing to do with compressing .dmp file. Rick -Original Message- Sent: Wednesday, November 28, 2001 12:16 PM To: Multiple recipients of list ORACLE-L hi list, what is the exact use of mentioning

RE: Script to Disable Constraint, Change Value, then Enable Const

I have had the same type of requirement and decided to use deferrable constraints. Works great!   Rick -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 28, 2001 11:56 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Script to

OT: SqlSever 2000 question

ies in table2 for that ID in one record For ex. 1,SmithJ,TN,county1 | county2 | county3 | countyN Any ideas, Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Oracle 7.2 32 bit Oracle Ole Objects

Hi, Does anyone know how I can get a copy of 16 bit Oracle 7.2 Oracle Ole Objects to install? I know probably next to impossible to find but any help is appreciated. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL

RE: How Can I get A sequence Current Value in PROC

Does anyone know why Oracle forces you to use NEXTVAL before doing CURRVAL. I would think sometimes you would want to use CURRVAL without incrementing sequence first. Thanks Rick -Original Message- Sent: Monday, November 26, 2001 8:50 AM To: Multiple recipients of list ORACLE-L You

LMTs Uniform vs Autoallocate

Hi All, Does anyone know Pros/Cons of using Uniform vs Autoallocate extent allocation for LMTs? I know temp has to use uniform but are there are there other restrictions/recommendation for other tablespace types? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Command line utility to show installed Oracle software

Hi All, I have forgotten the command line utility to show installed Oracle software. Oracle 8.0.5/NT 4. Can someone tell me? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services

RE: SQL Query OutPut

In sqlplus BREAK ON deptno skip 1 SELECT deptno,empno FROM your_table ORDER BY deptno,empno; You may want to set pagesize,spool etc. Rick -Original Message- Sent: Thursday, November 15, 2001 5:05 AM To: Multiple recipients of list ORACLE-L Hi, I need the Query for the following

RE: import/export problem in oem

Do you have sysdba or sysoper privs and are you connecting to OEM with sysdba/ Rick -Original Message- Sent: Wednesday, November 14, 2001 12:31 PM To: Multiple recipients of list ORACLE-L hi,gurus help me ,in this problem through command prompt i got export/import facility

RE: Sqlimportante

You can try something like SELECT SUBSTR(field1,1,INSTR(field1,' ',-1)-1) FROM your_table; This are limitations. This assumes no trailing spaces and words are separated by a single space. If without limitations you could write pl/sql to do the same thing. HTH Rick -Origin

RE: Problems with Pro*C

Do you have userid between? All variables used in embedded sql must be declare in this section. EXEC SQL BEGIN DECLARE SECTION; EXEC SQL END DECLARE SECTION; Rick -Original Message- Sent: Wednesday, November 14, 2001 7:16 AM To: Multiple recipients of list ORACLE-L Hello I am a

How do you change default oracle home?

. That does not work. I could not find anwwhere is registry to set this. My ultimate goal is to run some Pro*C programs and use Ora9i as the default home. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City

IMP-00037 Character marker set unknown

Hi DBAs, I trying to import uncorrupted 8.0.5 export into a Oracle 9i database. I get a IMP-00037 Character marker set unknown. MetaLink says it may be corrupted. It is not so anyone have any other suggestions? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Where are the Import/Export utilities in 9i

r". I have never needed this before. How can I just do a simple import/export? Oracle 9i/Win 2k environment Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: inactive sessions

An INACTIVE status means that the process is still connected to Oracle but not running a query. These are valid connections and will not be cleaned up. It is the job of the pmon process to clean up dead connections. It usually wakes up approximately every 5 minutes. Rick -Original

Toad vs SQL Navigator

pros/cons,why purchase one over the other, etc. if they have used both of these products? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: what is the fastest way to update a big table with more than

When you create the new table with char(8), I would use varchar2(8) but, do a trim when inserting into the new table because in your old table since it is char(255) it is blank padded so you are trying to put length of 255 into a length of 8. HTH Rick -Original Message- Sent: Wednesday

RE: what is the fastest way to update a big table with more than 50000 rows and 20 columns

UPDATE join a SET a.source = (SELECT b.source FROM cs b WHERE b.totid = a.totid); Rick -Original Message- Sent: Wednesday, October 31, 2001 7:15 AM To: Multiple recipients of list ORACLE-L rows and 20 columns hi guys, i

RE: Consistent Gets

CONSISTENT GETS is the number of blocks accessed in buffer cache for normal queries (SELECTs without for update clause). Rick -Original Message- Sent: Tuesday, October 30, 2001 4:46 PM To: Multiple recipients of list ORACLE-L Hi. What exactly does "Consistent Gets" mea

RE: Oracle9i-Download

Title: Oracle9i-Download I had the same problem and gave up, submitted a tar to client relations and they sent complete 9i CD suite within a week.   Rick -Original Message-From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]]Sent: Friday, October 26, 2001 7:45 AMTo

RE: Database will not shutdown in Normal or IMMEDIATE mode

do backups. It is a beautiful sunny day in east TN. Thanks again, Rick -Original Message- Sent: Friday, October 05, 2001 9:20 AM To: Multiple recipients of list ORACLE-L Rick, By now, I hope your database is back in working order. My guess as to why you could not shut down your

Database will not shutdown in Normal or IMMEDIATE mode

NORMAL or IMMEDIATE. No other users/sessions on the system. I have done this many times but not working today. I need to do this because I want to do an offline backup. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL

RE: Dropping table is not completing

It just hangs and I am not sure what tables/views to query to find out what the problem is. Thanks Rick -Original Message- Sent: Thursday, October 04, 2001 2:30 PM To: Multiple recipients of list ORACLE-L What is the error? Or does it just hang? Have you looked at session wait events

RE: Dropping table is not completing

Joe,   It is just sitting there. I am trying to truncate then drop but truncating is just sitting there.  There are no constraints on this table and I am the only one accessing database currently.   Thanks Rick -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent

Dropping table is not completing

Hi All, I am trying to drop a table. It is not locked and has very few records in it. I am trying to drop it but it will not. What can I check to find out why it will not drop? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET

Write to file in XML format

Hi All, I wanting to read data from table(s) and then create an output file in XML format. I have never done it so does anyone have good examples or point me to some good resources. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard

RE: Repost: Nested loop in PL/SQL

Part of the code must be missing because plan_id cursor is being open/fetched but NOTHING done with it. Rick -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 2:29 PM To: Multiple recipients of list ORACLE-L The reasons this doesn't work are f

RE: Oracle -> SQL Server

Title: Oracle -> SQL Server I have not used it but Oracle Transparent Gateway can query against a SQL Server database. This is a very expensive product.   Rick -Original Message-From: Christopher Spence [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 02, 2001 2:41 P

RE: Migration v. Upgrade

Rick -Original Message- Sent: Tuesday, October 02, 2001 1:20 PM To: Multiple recipients of list ORACLE-L Erik - I believe the upgrade / recovery manual will have the more concise definition you seek. Look for the Oracle version you are on and the one you want to move to and it will tell

RE: changing the internal password

You can use the orapwd utility to recreate the password file. Rick -Original Message- Sent: Tuesday, September 25, 2001 6:45 AM To: Multiple recipients of list ORACLE-L Hello, I am trying to log in the sqlplus (from command line) as the internal user but I can´t remember its password

RE: ORA-04031

dbms_shared_pool package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the init.ora parameter "shared_pool_size". Rick -Original Message- Sent: Monday, September 2

RE: partition

In 8.0.x it will NOT do the update. I think in 8i it will but not sure.   Rick -Original Message-From: Maya Kenner [mailto:[EMAIL PROTECTED]]Sent: Monday, September 24, 2001 10:50 AMTo: Multiple recipients of list ORACLE-LSubject: partition Hello,   I have a

RE: inspdver... equivalent in 8i and above...

no longer provided.  However, information about installed products can be obtained by running the Oracle Universal Installer (runInstaller) and clicking on the 'Installed Products' button located on the opening screen.   Rick -Original Message-From: Anjan Thakuria [mailto:[EMAIL

RE: How to find the current instance name?

You can if you grant select privs. -Original Message- Sent: Thursday, September 20, 2001 8:50 AM To: Multiple recipients of list ORACLE-L i cann't access V$ views as an ordinary user, rt? > -Original Message- > From: Cale, Rick T (Richard) [SMTP:[EMAIL PROTECT

RE: How to find the current instance name?

You probably want to do the following. v$database.name is the database name not the instance name. Although most name the same but not required. SELECT instance FROM v$thread; Rick -Original Message- Sent: Thursday, September 20, 2001 6:55 AM To: Multiple recipients of list ORACLE-L

RE: sizeiof table!!!

Does anyone have a script that gives actual space used instead of size of extents allocated? Thanks Rick -Original Message- Sent: Wednesday, September 19, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Select sum(bytes) / 1048576 "Size in Mb" From dba_extents W

RE: Dump Oracle Tables To ASCII/Comma Delimited File

!! Please do not post Off Topic to this List !!Go to http://www.cybcon.com/~jkstill/util/util_master.html and download utility. It works well for this. Rick -Original Message- Sent: Thursday, September 13, 2001 9:20 AM To: Multiple recipients of list ORACLE-L Hi everybody, Can

RE: STOP THE PRESS!!

051 San Diego, California-- Public Internet access / Mailing Lists ---- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling o

RE: Sad News - Jets crashed into World Trade Center

(like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Netw

What is maximum length of sql statement sent to Oracle server?

Hi All What is maximum length of sql statement sent to Oracle Server 8.0.5? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: STOP THE PRESS!!

ou may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: query for top customer

SELECT customer,sales FROM (SELECT customer,sales FROM table_a ORDER BY sales DESC) WHERE rownum < 4; Must be running at least 8i for this to work Rick -Original Message- Sent: Monday, September 10, 2001 9:30 AM To: Multiple recipients of list ORACLE-L how to writ

RE: PK Violation on insert

)); The script UTLEXCPT.SQL located in home/rdbms/admin directory will create this table for you. 2. Capture records in violation into your created exceptions table ALTER TABLE.EXCEPTIONS INTO OWNER.EXCEPTIONS Rick -Original Message- Sent: Friday, September 07, 2001 8:41 AM

RE: ms acces

Supposely Oracle Migration Workbench will do this. You can get it from OTN. See http://technet.oracle.com/software/tech/migration/workbench/content.html There is also a tool with sql server client DTS that does a great job of this. Rick -Original Message- Sent: Thursday, September 06

RE: index in data tablespace ???

pool off substitute the with destination tablespace Rick -Original Message- Sent: Thursday, September 06, 2001 2:37 PM To: Multiple recipients of list ORACLE-L Hi all, I got bunch of indice reside in data tablespace. What's an easy, safy way to move them into i

Where are temp segments created?

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

RE: Alter tablespace add datafile

DY, 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: Cale, Rick T (Richard) INET: [EMAIL

RE: create sequence in PL/SQL anonymous block - needs to be in se

I do not know the history behind this thread but wouldn't this solution only work in a single user system? I can see problems in a mult-user system. Rick -Original Message- Sent: Wednesday, September 05, 2001 9:27 AM To: Multiple recipients of list ORACLE-L se like Connor said

RE: Column Name

If you have 8i you can add new column name,populate with old column data,drop old column. Rick -Original Message- Sent: Tuesday, September 04, 2001 2:38 PM To: Multiple recipients of list ORACLE-L List, Is there any way to rename a column without changing the position of column

Access to Oracle

Hi All, What is the best way to load Access tables into Oracle? I can do Oracle to Access Ok but not vice-versa. I could dump it out into csv and use sql*loader but hoping more for a more automated way. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

OT: Reverse engineer access database

Hi DBAs, Sorry for the OT post but can someone tell me how I can reverse engineer an access database to produce the sql code that will run in ACCESS or point me to a web site/user group/list server that may be able to help. Thanks Rick -- Please see the official ORACLE-L FAQ: http

RE: 9i NT

Scott, I would have to agree with Tom on this. If you have it setup correctly then starting the services WILL start the database. I have 8 instances and they all start if I start the NT services. Rick -Original Message- Sent: Friday, August 31, 2001 1:04 PM To: Multiple recipients of

RE: Export Problem

ified for the server in props$. Action: Change the client's value for NLS_LANG/NLS_NCHAR to server's value and retry the operation. Rick -Original Message- Sent: Friday, August 31, 2001 12:23 PM To: Multiple recipients of list ORACLE-L Hi List, I have problem wit

RE: 9i NT

Kevin, As you are probably aware by default when attempt to start an instance when starting the services, Oracle looks only in oracle_home\database for init file and parameter file(I cannot speak for 9i). Rick -Original Message- Sent: Friday, August 31, 2001 11:02 AM To: Multiple

  1   2   >