Re: Tablespace layout

There is no advantage at all in making extent sizes a function of db_block_buffers. I agree, to a certain extent (no pun intended), with the idea of using dedicated tablespaces. I prefer to use dedicated tablespaces for all significantly large tables, where the value for significantly large is

Unix-script

Hallo, Can anyone give me an eaxmple of a iunix script, which checks if the file in unixsystem exists and if it does then it runs th esqlloader script, which loads data into a database table.? Thanks in advance. Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: RE: Permanent Tablespace for sorting.

Thanks Christopher. Useful information. -Original Message- Sent: Tuesday, August 28, 2001 7:26 PM To: Multiple recipients of list ORACLE-L When it is perm, you need to recovery it like a normal tablespace if moving it or recovering, unless you offline it or rebuild the control file,

Re: Windows application - Linux server

Hi, I can recommend the OFC (the Oracle Class Library for Windows platforms). It's stable and caters to Oracle's capabilities. We used it and it's great. And ... yes, use a RAD tool like C++ - Builder. Creating GUIs with VC++ is a pain. | Regards,

RE: RE: Permanent Tablespace for sorting.

Title: RE: RE: Permanent Tablespace for sorting. How do we check on the ST enqueue contention? rgds amar -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 10:33 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: Permanent

RE: RE: Permanent Tablespace for sorting.

Title: RE: RE: Permanent Tablespace for sorting. Thanks Cris and Conner, I was concerned about the performance implications between the two, even if minor. rgds amar -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 10:33 PM To:

Re: Convert 7.3 users to 8.17 users

Hi, I can't test on 7.3 anymore but try following kind of script (it seems to work between 8.0 8.1 databases ** ORACLE_SID=EWIP export ORACLE_SID sqlplus -s username/password EOF set term off echo off

RE: Migration of simple snapshots

In your case, i would have used offline instantiation. Have a look at the replication manual! Cheers -Original Message- From: Mike J Kurth [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 18:51 To: Multiple recipients of list ORACLE-L Subject: Migration of simple

How to select and display 10 records at a time from a table using sql query

Dear DBA Gurus, How do I select and display 10 records at a time from a table using sql query only? Thanks and Regards, Ranganath DISCLAIMER: This correspondence is confidential and intended for the named recipient(s) only. If you are not the named recipient and receive this

RE: OT : kernel using 75% of CPU

Agreed - and Sun doesn't handle getting close to the edge at all well imho. Recently upgraded a db on (2.6) server from 8.0 to 8.1.6 and it went from running fine to running like an absolute dog - kernel thrashing exactly like our initial poster reports... ... The problem? java_pool_size (and

RE: OT : kernel using 75% of CPU

OK, If you're not using JServer/Aurora (whatever it's called this week), you can drop the size of your Java pool, I usually have mine set to 2M on such databases without any trouble. Is the Java running on the Oracle server? The way to see what Java is actually doing is to use the Java

Re: Unix-script

[EMAIL PROTECTED] wrote: Hallo, Can anyone give me an eaxmple of a iunix script, which checks if the file in unixsystem exists and if it does then it runs th esqlloader script, which loads data into a database table.? Thanks in advance. Roland There is a script named upload.ksh on

RE: Rename Constraint

Hamid, Check this out: http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci759997,00.html HTH Mark -Original Message- Sent: Tuesday, August 28, 2001 22:24 To: Multiple recipients of list ORACLE-L Hi all, Is any body know what's the easiet way to rename a constraint name i

Re: How to select and display 10 records at a time from a table using sql query

select * from ( select column1, column2 from my_table order by 1) where ROWNUM 11; Look at manual how to use ROWNUM. It's ease to make mistakes with it. JP Dne st 29. srpen 2001 10:55 jste napsal(a): Dear DBA Gurus, How do I select and display 10 records at a time from a table using

rman restore question

Hi, If I need to do an rman restore to another server, do the filesystems need to be a replica of the original??? Is it possible to restore to different disks?? Any help would be greatly appreciated!! Rgds FAwzia This message is confidential and is intended for the addressee only;

RE: How to select and display 10 records at a time from a table u

Title: RE: How to select and display 10 records at a time from a table using sql query If you are talking of only sql query, then it not feasible to show 10 records at a time and then wait for user to press a key to show the next ten records (if that is what you mean). You may use sql*plus

RE: How to select and display 10 records at a time from a table u

set pagesize 10 set pause on select ... enter return to display next page of results. - Mike. -Original Message- Sent: 29 August 2001 09:55 To: Multiple recipients of list ORACLE-L using sql query Dear DBA Gurus, How do I select and display 10 records at a time from a table

RE: !! *Very* important Oracle-L message !!

-Original Message- Sent: 28 August 2001 23:29 To: Multiple recipients of list ORACLE-L Ok, now that I have your attention, please read the following message from Bruce Bergman, owner of fatcity.com. It concerns the future of this list. Please read the entire message before

Spooling output of a select statement to a file through stored procedure

Dear DBA Gurus, How do I spool output of a select statement to a file through stored procedure. The stored procedure should take the directory and path of the file to be spooled to on the client machine. I know we can do this using UTL_FILE package. But I don't want to write to a file

RE: Burning game CD's

We wuvs you Mladen, you ickle fwuffy bunny... :0) g -Original Message- Sent: Tuesday, August 28, 2001 8:34 PM To: Multiple recipients of list ORACLE-L Wow! I have fans! This will further inflate my already healthy ego -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: DBMS_JOB Help

Hi, You need to find the job number, then use DBMS_JOB.REMOVE(). This is all in the documentation: http://technet.oracle.com/doc/oracle8i_816/server.816/a76956/jobq.htm#10 57 Note that the job will complete before being removed from the queue. g -Original Message- Sent: Tuesday,

Fwd: Re: How to select and display 10 records at a time from a table using sql query

Does anybody know how to do it better way? But this will return only the first ten rows not subsequent sets. How do I display rows from 11 to 20, 21 to 30 and so on? ROWNUM is counting output tuples. You cannot use ROWNUM 10. I think you have to order select by your primary key, make filter

Re: HP-UX

Ed, the real problem is it's not just this patch... there is a list of 10-15 patches which all give this error message. I am tempted to just go ahead and try the install anyway, how seriously could things go wrong :-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

Re: rman restore question

Yes, you can lo+ok at note 73974.1on Metalink to find out how to put the datafiles in different places in the copy database. This note tells you exactly how to do it, but when you 'switch' that datafiles you have to repeat the set newname... command and then switch each individual file. HTH,

Re: Tablespace layout

Don, By uniform extents, do you mean all extents in the same tablespace being the same size? Or do you mean having a choice of say three different sizes in on tablespace but sticking to those sizes? That seems to be the crux of the disagreement amongst our team. Thanks for your

RE: RMAN tuning

Michael, You might look at the BLKSIZE parameter. I did some basic tests using NT and the EDM client, and found that setting the BLKSIZE to 2 Meg was the fastest for my installation. I think the default is 64k. You set the parameter like: allocate channel d2 type 'SBT_TAPE' parms

RE: conversion from public to private synonym

Title: RE: conversion from public to private synonym A private synonym cannot have the same name as the object. You will have to change dependent code if your public synonym name was same as the object name. rgds amar -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]]

results of analyze

Good morning all, Someone asked me where the results of analying tables and indexes goes. Can anyone tell me what table(s) holds the statistics generated. Thanks, Ruth B. Gramolini ORACLE DB2 DBA VT Dept. of Taxes ph# 802.828.5708 fax# 802.828..3754 [EMAIL PROTECTED] -- Please see the

RE: Tablespace layout

Lisa, I have a copy of the paper you refer to and have read it a couple of times. We've gone over this issue many times in our team but our other two DBAs remain unconvinced. Perhaps I need to actually give them a copy of the paper. As I said, the crux of the issue is whether we should only

RE: Fwd: Re: How to select and display 10 records at a time from a table

Does anybody know how to do it better way? You can do it (under SQL*Plus) by running @next10ini then @next10 and then / repetitively, where next10ini.sql is : -- -- next10ini.sql -- -- To be called ONCE before calling repetitively next10.sql -- (to be called

Re: HP-UX

Stuart, I'm not an expert in these matters, but I've just installed hp-ux 64-bit using the June release, and including the three large-scale quality patches. During installation I noted that swinstall was giving me message like: 298 files skipped out of 673 I think this meant it was simply

Drop Recreate table or alter table drop column. Which is

Hi Gurus, If the table is empty U need to drop one of the columns, do you 1) alter table tab_name drop column col_name or 2) drop recreate table I use option (1). Which is a better choice ? TIA Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

RE: Re[2]: Preventing logins from applications

Title: RE: Re[2]: Preventing logins from applications In oracle 8i, you may take a look at product_profile table. You can prevent users from using sqlplus by adding the following in this table: INSERT INTO Product_profile (product, userid, attribute, char_value) VALUES

RE: results of analyze

Hi Ruth. {user|all|dba}_tables, {user|all|dba}_columns, {user|all|dba}_indexes Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 29, 2001 9:41 AM To: Multiple recipients of list ORACLE-L Good morning all, Someone asked me where

RE: results of analyze

XXX_TABLES, XXX_INDEXES, you can read the statistics from these views Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275

RE: results of analyze

Ruth, Those are in sys.tab$ and sys.ind$. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Ruth Gramolini [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 8:41 AM To: Multiple recipients of list

Re: Tablespace layout

Cherie, I created a test database for our developers that contains all of the production tables and data. The production is Oracle 7.3.4 on Novell and the test is 8.1.7 on Linux. Being that I am limited to the number if disks that I have available and I needed to use all available space

MySQL anyone?

Hi. does anyone know anything about MySQL? I was assigned to a pilot to see whether this is something my company would want to use. Does anyone use it? Any good/bad opinions? TIA Gene = __ Do You Yahoo!? Make international calls for as

RE: results of analyze

Ruth, the results are stored in the USER_TABLES and USER_INDEXES views. below are some of the columns that get populated when I issue the following command: dbms_stats.gather_table_stats('schemaname','tablename'); hope this helps 09:28:15 WTWD descr user_tables Name

OCP Study Materials - Your Opinion

I found both of these OCP study materials on Amazon.com and would like your opinion of them. OCP: Oracle8i DBA Cert. Kit: Study Guide by Chip Dawes Book and CDROM from Sybex OCP: Oracle8i DBA Virtual Test Center from Sybex Your comments will be very helpful. Thanks, Ken Janusz, CPIM --

financial problems with fatcity.com

I think that much better than voluntary contributions will be some s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I am sure that everybody working with Oracle and living in US or UK or other developed country can afford such fees. We will not need to charge people from

RE: results of analyze

Title: RE: results of analyze Ruth, do you mean tables other than dba_indexes, dba_tables, dba_ind_partitions, dba_tab_partitions, etc., etc?? Here's a good one. The dba I worked with (certified, no experience) tried to tell me that when you analyze it adds columns to the table. Yea,

Re: results of analyze

In addition the INDEX_STATS view will be populated by the VALIDATE INDEX INDEX_NAME; command. It will have a most one row in it, so you need to check it after each validate. Jared On Wednesday 29 August 2001 07:00, Paul Baumgartel wrote: Hi Ruth. {user|all|dba}_tables,

alternative rows

Hi lists can anybody post me to find alternative rows in a table. 1,3,5 ... or 2,4,6 srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

Re: Drop Recreate table or alter table drop column.

if you're using 8i, then option 1 is fine, if 8.1 then option 2 is your only choice. joe [EMAIL PROTECTED] 08/29/01 10:21AM Hi Gurus,If the table is empty U need to drop one of the columns, do you 1) alter table tab_name drop column col_name or 2) drop recreate tableI use option (1).

Re: results of analyze

Hi DBA_TABLES DBA_INDEXES ORACLE 8.0.5 Jack Ruth Gramolini [EMAIL PROTECTED]@fatcity.com on 29-08-2001 15:40:33 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van

Re: MySQL anyone?

It depends on what you want to use it for. See http://www.phpbuilder.com/columns/tim2705.php3?page=1print_mode=1 for one opinion. -Joe - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 10:00 AM Hi. does

Re: results of analyze

Thanks all, know I can at least give an intelligent anwer. Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: Drop Recreate table or alter table drop column. Which

In an 8i database, dropping a column is certainly preferred over a rebuild, because if you drop re-create the table, you have to re-create all grants, indexes, triggers and constraints. Since the table is empty (you said so) you will not fragment any data (row chaining and alike).

RE: conversion from public to private synonym

a private synonym can certainly have the same name as the object does. Unless you mean that the same user owns the object AND the synonym. But in that case, why would you want a synonym. In fact, I used to set up test environments this way. One schema owned the objects. I created public

An OPS tnsnames question

Dear list ! I've got an OPS database named OPS with 2 instances OPS1 and OPS2 . I want the users to connect to OPS1 and ONLY if it is down , to connect to OPS2. It's Oracle 8.0.5.1 on NT4. I put the following lines in clients' tnsnames.ora file : OPS.world = (DESCRIPTION_LIST =

Re: 817 Intermedia on AIX

You may want to connect as ctxsys and query the user_libraries view to make sure the library paths are pointing to your new 8.1.7 Oracle_home. Just a thought. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth INET: [EMAIL PROTECTED] Fat City Network

Re: Drop Recreate table or alter table drop column.

New Bee, If the table has had the permission granted to the users then it would be better to drop the column. If you drop the table and recreate then you have to regrant the permissions. Also your packages could very well be invalid if you drop the table and recreate. ROR mª¿ªm [EMAIL

Re: RMAN tuning

Tom, Does this only work for tape? Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 9:10 AM Michael, You might look at the BLKSIZE parameter. I did some basic tests using NT and the EDM client, and found that

Upgrade of database

Can anyone point me towards the documentation for upgrading Oracle 8i, from 8.1.6 to 8.1.7. Thanks in advance Steven H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

RE: financial problems with fatcity.com

Maybe Larry could spare a few bucks. Heck, think of the amount of time that this list saves Oracle support! Dave -Original Message- Sent: Wednesday, August 29, 2001 10:48 AM To: Multiple recipients of list ORACLE-L How about Corporate Sponsorship? -Original Message- Sent:

RE: financial problems with fatcity.com

Whats that first part of your domain address there Alex :-) Perhaps you could help the list out !! -Original Message- Sent: 29 August 2001 16:16 To: Multiple recipients of list ORACLE-L I think that much better than voluntary contributions will be some s*u*b*s*c*r*i*p*t*i*o*n

Re: !! *Very* important Oracle-L message !!

I didn't put OT in the header because I think this is very on topic. I will be emailing Bruce to see what he needs, or feels is a fair contribution for my participation in this list through the years. I have gained so much from the members of this list. Without those who participate, both

Re: An OPS tnsnames question

try with: OPS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp) (HOST = DB1) (PORT = 1526)) (ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT = 1526)) ) (CONNECT_DATA = (SERVICE_NAME = OPS)) ) - Original Message - To: Multiple recipients of list

Re: !! *Very* important Oracle-L message !!

Can we just start pledging ..We have got to keep this form going under. Ideas . Anjan Jenner Mike wrote: -Original Message- Sent: 28 August 2001 23:29 To: Multiple recipients of list ORACLE-L Ok, now that I have your attention, please read the following message from Bruce

help execution plan changes when using a dblink

Hi, We face the strange problem that an executionplan is changed recently without any reason. Now it runs with a full_table scan and it did not do so. The query is executed through a dblink and is part of a batch. - nothing has been changed recently in the app everybody agrees on here, -

RE: MySQL anyone?

My entire site (www.vampired.net) is mySQL driven, the articles, scripts, all content is dynamic via PHP and mySQL. It is a great database if you are doing something like what I have done, but if your building an application, it generally isn't a good choice. It does not have transaction

Re: HP-UX

Jonathan, Thanks for the advice, it worked a treat... Used SWINSTALL interactively and the error messages I then got told me that all the patches I was trying to install had been superseded by other patches already on the system... Thanks again... - Original Message - To: Multiple

RE: results of analyze

Paul, You mean user_tab_columns.avg_col_len instead of user_columns, right? I'm glad to say that your typo made me look at this table again, and I found this usefull column! Wish I had seen it last week when I was calculating how much disk space I am going to need for a new DB. I had to come

RE: HP-UX

Okay, I just installed patch PHCO_21187 on a test workstation. It went in okay but when I tried to swinstall it a second time I got the patch match operation failed to find patches for target message , apparently because the patch is already installed. I'm guessing that the patches or

RE: OT RE: RE: How do you audit a DBA?

Actually, if my company is any indication it's not a matter of whether they think the DBA can be trusted it's a matter of being afraid of being sued if *everything* isn't monitored and audited. Our audit department's current target is the IS Unix Admin group. They're insisting that expensive

RE: DDL CHANGES IN A REPLICATED ENVIRONMENT

Barry; We never did put together bi-directional replication, but in our single directional case we ended up making any DDL changes on BOTH systems. Process: 1. Stop Replication on selected object 2. Make changes on Primary 3. Make changes on Secondary 4. Make changes to replication

RE: financial problems with fatcity.com

How about Corporate Sponsorship? -Original Message- Sent: Wednesday, August 29, 2001 11:16 AM To: Multiple recipients of list ORACLE-L I think that much better than voluntary contributions will be some s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I am

LinuxFS for Oracle

I am about to attempt an Oracle installation on SuSE Linux 7.2. I need to pick a file-system: ext2 or reiserfs. Does anyone have any comments to share? All I can see from the docs is: Oracle8i Server must be able to verify that file writes have been made to disk. File systems that do not

Re: !! *Very* important Oracle-L message !!

On my web page I maintain an Amazon.com payments paybox, which is for collecting anonymous donations. I think if Bruce sets up a paybox for each list he hosts free of charge, and included a pledge request in the list footers, there will be a steady stream of donations. Amazon calls this the

RE: alternative rows

For even numbered rows . select col_1, col_2 from (select col_1, col_2, rownum rnum from my_table) where mod(rnum, 2) = 0 For odd numbered rows ... select col_1, col_2 from (select col_1, col_2, rownum rnum from my_table) where mod(rnum, 2) 0 A from clause select is

RE: Drop Recreate table or alter table drop column. Which is

Because of any synonyms (which are based off of object numbers), Option 1 is the only way to go. That is of course unless you want to perform extra work dealing with the synonyms. -Original Message- From: CHAN Chor Ling Catherine (CSC) [SMTP:[EMAIL PROTECTED]] Sent: Wednesday,

RE: financial problems with fatcity.com

I for one would even agree to , say , a 25$ a year fee. This is a very good site and there are a lot of good ideas bandied about here every day. Kevin -Original Message- Sent: Wednesday, August 29, 2001 10:16 AM To: Multiple recipients of list ORACLE-L I think that much better than

RE: MySQL anyone?

Title: RE: MySQL anyone? Attached is a note from another list member, Guy Hammond. I agree with most of what Guy says, except that MySqueel does have master-slave replication (though slave cannot be a writeable slave). And I'd add no point-in-time recovery, no incremental backup capability,

RE: financial problems with fatcity.com

What're you, communist? I'd be willing to pay a subscription fee, but not if it were subsidising politically correct nonsense. g -Original Message- Sent: Wednesday, August 29, 2001 4:16 PM To: Multiple recipients of list ORACLE-L I think that much better than voluntary contributions

RE: financial problems with fatcity.com

Title: RE: financial problems with fatcity.com Alex, that is an excellent idea! I second that notion. I have learned just as much if not more from this list than the average $40-80 dba book out there (101 tuning and dba excluded, I've just ordered practical 8i and await that one). I think

RE: financial problems with fatcity.com

Yeah...like maybe Oracle? Or Quilogy (used to be Solutech)...they do Oracle training there in Mission Valley. The downside of that would be the advertising... --- === Michael P. Vergara Oracle DBA Guidant Corporation

RE: financial problems with fatcity.com

I seldom chime in, but I feel no truer statement was made. Especially since you are more likely to get a right answer from this list. -Original Message- Sent: Wednesday, August 29, 2001 12:43 PM To: Multiple recipients of list ORACLE-L Maybe Larry could spare a few bucks. Heck,

RE: !! *Very* important Oracle-L message !!

Just publish the address where to send the money orders to and my $20 will be on it's way tomorrow. -Original Message- From: Anjan Thakuria [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Subject: Re: !! *Very* important

help execution plan changes when using a dblink

-Oorspronkelijk bericht- Van: Jeroen van Sluisdam Verzonden:woensdag 29 augustus 2001 17:02 Aan: '[EMAIL PROTECTED]' Onderwerp:help execution plan changes when using a dblink Hi, We face the strange problem that an executionplan is changed recently without any

RE: !! *Very* important Oracle-L message !!

I agree to David. We should basically have Bruce decide what is the amount needed to maintain this list. Also I would think since most of us are using this site on a day to day basis, It wouldnt be fair that one person paying 25$ and another person pays nothing. My 2 cents would be Since Bruce

RE: results of analyze

That command is deprecated, but still exists. I believe that the replacement is ANAYZE TABLE xxx VALIDATE STRUCTURE CASCADE; -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Subject:

RE: help execution plan changes when using a dblink

Have had problems before where anything over a db link was flaky explain plan wise. If you can have the basic query as a view stored remotely on the db you link too it should work more consistently. Iain Nicoll -Original Message- Sent: 29 August 2001 17:01 To: Multiple recipients of

Re: !! *Very* important Oracle-L message !!

As I see it, he needs $500 per month for 4 or 5 months. Lets just round that to 6 months times $500 or $3000. I don't know how many people are on his 60+ mailing list but just guessing, I believe if only 1/4th the people contributed $1 per month for 6 months or just $6 that would cover it.

RE: financial problems with fatcity.com

I would quite happily pay a subscription fee of £12 per year, or a squid a month :) Damn, let's face it - you couldn't buy a decent Oracle book for that, yet you have most of the more prestigious authors as members of this list - interactively!! Mark me up for a subscription. If you can't sort

Re: financial problems with fatcity.com

I second that motion. I just spent over $100 to get my 2 boys signed up for Cub Scouts and one of them has weekly dues of $1.00. For me it $12/yr would be worth it. Maybe offer a lifetime membership of $25 or something. My 2 cents worth Stephen Andert [EMAIL PROTECTED] 08/29/01 08:15AM I

Re: alternative rows

select * from ( select rownum,a,b,c from table) x where mod(x.rownum,2) = 1 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 5:35 PM Hi lists can anybody post me to find alternative rows in a table. 1,3,5 ...

RE: financial problems with fatcity.com

Title: RE: financial problems with fatcity.com And.. uh... Ivan, Please don't feel like you have to share any more lap dancing experiences. ;-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 29, 2001 9:51 AMTo: Multiple recipients

RE: alternative rows

How about analysing the table, finding out the total number of rows within the table, and then using the SAMPLE clause with a value of 50%? Mark -Original Message- Shrinivas (MED, Keane) Sent: Wednesday, August 29, 2001 16:36 To: Multiple recipients of list ORACLE-L Hi lists can

RE: !! *Very* important Oracle-L message !!

Jared/Bruce, Count me in. I would suggest a standard amount of say US$20 (or more) per month and see a show of hands (including mine), and take it from there. For convenience's sake, I suppose this will mostly be from US based Listers. C'mon guys and gals - we don't even have to dig deep into

RE: An OPS tnsnames question

Hi Claudio ! Thanks a lot for your reply. Another question ,please : How can i define SERVICE_NAME = OPS ? I have 2 instances named OPS1 OPS2 , so , for example , in listener.ora on DB2 i have : LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT = 1526)))

RE: 817 Intermedia on AIX

Title: RE: 817 Intermedia on AIX Also - I ran into this problem on hp/ux: you may have to create the library hard coded with the oracle home path. REferencing $ORACLE_HOME (in user_libraries) did not work. Lisa Koivu The Bootylicious DBA Ft. Lauderdale, FL, USA -Original Message-

Novice Question

Hello gurus I am in a position to export a user and drop it then create again and import it. Why I am doing this is because I want to change the default tablespace of the user to a different one and also its tabel are out of extents. Now , my question ; may be very stupid though, Would it

RE: !! *Very* important Oracle-L message !!

I would let Bruce speak for himself but I have to assume that it would be a lot of work and hassle to set up a subscription and then deny access to those who have not paid. Is that true, Bruce. If so, perhaps we should all just voluntarily send in some money. $25 would be a drop in the bucket

RE: financial problems with fatcity.com

I think we should request Jared to decide about it for a possible solution and we should back him with any financial support to keep this fantastic list/forum alive Regards MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed,

RE: !! *Very* important Oracle-L message !!

I think a subscription is a decent suggestion. I know Bruce wants to keep it free but it still sounds the most feasible to me. After all the electronic friends I have made on the list, and of course its primary aim as a second-to-none technical resource/forum, I would hate to see it go. Regards

FW: An OPS tnsnames question

Hi Claudio ! Thanks a lot for your reply. Another question ,please : How can i define SERVICE_NAME = OPS ? I have 2 instances named OPS1 OPS2 , so , for example , in listener.ora on DB2 i have : LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT = 1526)))

!! Keeping the list alive

This list is apparently a more valuable resource to many of you than I realized. I'm literally bowled over by the generosity. I've received so many emails about this that I really can't personally reply to them all right now. Many of you have asked some questions I would like to answer now.

RE: awk, sed, windoze, sql*loader, other fun stuff

Title: awk, sed, windoze, sql*loader, other fun stuff try perl. www.activestate.com www.cpan.org www.perl.com it's free and easy to load. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 29, 2001 2:27 PMTo: Multiple recipients of list

ODBC link from Oracle to Access

Hi all, We are having a terrible time using and ODBC link to bring down some very large tables into ACCESS. Our users want to know why they are experiencing timeouts and other problems. Does anyone have a simple answer to why ODBC links to get very large tables is having these problems .

  1   2   >