Breaking down values in a large table

Listers, I have a table of 125M rows (not partitioned) which I am exporting. I want to break the export into 4 dmp files using the query command on the pk column. I am looking at how the best way of finding the values of the PK (number) which are at 25%, 50% and 75% ish for the table

RE: Breaking down values in a large table

://www.orafaq.net -- Author: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: RMAN compatibility issues

You can upgrade the 816 catalog to be 817 compliant with the command RMAN upgrade catalog You need to be connected to an 8.1.7 target first to do this. It effectively recreates two packages DBMS_RCVMAN and DBMS_RCVCAT John -Original Message- Sent: 20 November 2002 16:39 To: Multiple

RE: Enabling export transportable tablespaces

Banarasi Are you using the Standard Edition of 8i, if so then tts is not available. You need the Enterprise edition HTH John -Original Message- Sent: 19 November 2002 13:18 To: Multiple recipients of list ORACLE-L Hi gurus please help me!! I was using ORACLE 8.1.7 on window NT 4.0

RE: Query elapsed time

Dick V$session_longops has a column elapsed_seconds and a sid column HTH John -Original Message- Sent: 15 November 2002 18:59 To: Multiple recipients of list ORACLE-L Quick question, Does anyone know of a location in the V$ tables where the elapsed time of the current query is

RE: listener.log parsing utility

Patrice, I wrote the enclosed awk script to check the listener log and count the number of connections from each target. I am sure it could be adapted to suit your needs The first few line of output looks like Service :Host :User :tcp:ip address :No of Connections

RE: cant set multiblock read count 8 !!!

Rahul, I believe there is an O/S maximum setting of this parameter to be 64K (this covers AIX and HP and and may affect others) This fits in with your finding so I am sure it is correct John -Original Message- Sent: 12 November 2002 09:11 To: Multiple recipients of list ORACLE-L list

RE: SQL loader

Hello Nirmal, The FILLER command is available in sqlloader to allow you to miss a field out something like LOAD (field 1 ... field2 ... dum_rec FILLER, field3 ) may work but I am not sure that this will work in 7.3 of Oracle as I think FILLER came out in 8.0x However an easy way ( I was going

RE: Data Purging Strategy

In response to a post on data purging Tim Gorman wrote some on SAN-based disk, some on NAS-based storage. Can someone please explain the differences between these technologies please. My understanding that a SAN is a group of disks which are available on a network and are not 'owned' by a

RE: Data Purging Strategy

Hey Dennis, Mark Leith is the only person on this list allowed to mention 3rd party products. I am sure he bought the franchise from Jared :) John -Original Message- Sent: 06 November 2002 14:15 To: Multiple recipients of list ORACLE-L Prem - You are receiving some excellent advice

RE: OCP Exams - What to study out of?

Just bought Oracle Press 9i New Features by the illustrious Robert Freeman. Seems good and I have also seen another Oracle Press Book 9i New Features Exam Guide by Daniel Benjamin. This follows the Corioulus format of a chapter and questions and a big test at the end. The worrying thing about

RE: ORA-01089

Don't know the exact circumstances but the following note from Metalink (1014091.102) may be appropriate However the best way to learn anything is to ask the senior DBA what he meant. An explanation from him may include looking at the alert log and the scripts that were used. That is more than

RE: OCP Exams - What to study out of?

Denham, I have just passed my 8i upgrade exam and added some notes to a page about getting OCP certification. It can be accessed on http://www.hcresources.co.uk/ocp.htm http://www.hcresources.co.uk/ocp.htm Hope you find it interesting John -Original Message- Sent: 05 November 2002

RE: ORA-02050

Ray, I think you need to check DBA_2PC_PENDING on both the local and remote database to see if anything is still in there. That gives the osuser, terminal and host name so you may be able to get something from that. Of course if there is nothing in that table then the transaction has been rolled

RE: Stand-by database implementation ...

One of the best sources of information is a white paper by Lawrence To called Graceful Switchover and Switchback for Standby Databases (Metalink note 90817.1) Another one under the White papers sectiopn is note 91570.1 but I have not looked at that John -Original Message- Sent: 29

RE: dropping multiple tables

No specific way of deleting selected multiple objects as far as I am aware. You could drop a tablespace including contents if you wanted to delete all objects in that tablespace or you can drop user cascade. The best bet is to create some dynamic sql to just create a script Something like the

RE: Please help, comment required urgently

Thanks for your contributions on this Tim (and on everything else you respond to). These little tips of how to analyze statspack reports properly all add up and whilst I did look at the report and I did glean some of you what suggested I certainly did not pick up all that you spotted John

RE: Difference - Rebuild and Analyze index

I think you are correct Charlie, In 8i statistics can be collected when you are creating or altering an index. You must use compute statistics (estimate is not an option). You can rebuild an index and compute statistics, however you cannot do it using the online keyword John -Original

RE: Certifications Exam Discount Code

For Oracle Partners the code OPP is supposed to give 35% discount. It worked for me with no questions asked John -Original Message- Sent: 16 October 2002 22:26 To: Multiple recipients of list ORACLE-L Hello List, Code OTN 20 gives 20% discount. Somebody posted a code for 30% discount

Re: Multiple Listeners

There has been much discussion regarding single or multiple listeners and there seems to be a split between those who advocate one method over the other. I am currently working at a site with a large number of systems/databases. They are well organised and one of the standards that is

RE: [Q] Public and private rollback segment?

Private ones have to be specified in the init.ora file as well John -Original Message- Sent: 17 October 2002 17:10 To: Multiple recipients of list ORACLE-L Can't remember where I copied this from, but I believe it came from metalink. I don't have a version associated with it, so

RE: Difference - Rebuild and Analyze index

Marul, These are 2 different utilities with 2 different functions and end results Analyze schema with compute looks at all the indexes in that schema , reads every block and produces statistics which the cost based optimiser can use to determine the best execution path Rebuilding an index can

RE: Drop snapshot ORA-03113 - part 2

Have you tried execute sys.dbms_ijob.remove(xx); An undocumented provedure that I picked up on from this list a few weeks ago John -Original Message- Sent: 16 October 2002 17:04 To: Multiple recipients of list ORACLE-L DBA_JOBS shows that there is job associated with phantom refresh

RE: Verrrry interesting article at MetaLink

Jared, You should feel upset as well as flattered. In my view you have a strong case against Oracle for some form of compensation, as a minimum you should be credited in the article. Whether you can win against a big corporation is another matter of course. I and many others can confirm that the

Loading a flat file into Oracle

Santosh. Putting a subject on your e-mails is useful to everyone I suggest you look at sqlloader. There are some good pages on the FAQ associated with this site http://www.orafaq.com http://www.orafaq.com HTH John -Original Message- Sent: 10 October 2002 11:59 To: Multiple

RE: Shutdown/Startup user

Sean, The role sysoper is already provided Details are There are two main administrative privileges in Oracle: SYSOPER and SYSDBA These are special privileges as they allow access to a database instance even when it is not running and so control of these privileges is totally outside of the

RE: How much memory is an oracle shadow process using

Thanks for your script. The whole site is an excellent resource. Thanks Tim, I have run your script and also run a query against statistic 15 and 20 from v$sessstat (max UGA and PGA memory used ) SQL SQL select name,statistic#,sum(value/1024/1024) Curr Mb 2 from v$sesstat a, v$database c

RE: How much memory is an oracle shadow process using

Thanks for the help Igor but I have managed to work that bit out for myself. I did think that the posting was reasonably comprehensive and I also mentioned what the 2 statistics were used for. Perhaps the only thing I did not mention was that these specific queries are running against an 8.1.7.3

RE: Database is 32 or 64 Bit ?

I posted the note below a few weeks ago, hope it helps John Listers, Here is a little summary of commands to identify the bit version of an o/s and 2 methods of identifying whether a database is a 32 bit or 64 bit installation Operating System Compaq Tru 64 - will be 64 bit HP-UX

How much memory is an oracle shadow process using

I know this has been discussed before and I have monitored the discussions but I am not sure that I have seen a clear summary and set of conclusions. I am trying to identify how much memory is used by the instance and all connections. I can show sga to give a total memory of the base instance

RE: rman fun :), nightmare and long

The controlfile gets backed up automatically when you do a RMAN full backup. I have been having a debate this morning regarding a situation where we do weekly full backups using RMAN and and a daily RMAN archivelog all delete input. I contend we should do a archivelog all delete input INCLUDING

RE: Why do I receive the mails late?

I have raised this before and never seen a good explanation. It is very frustrating to see a reply to a post prior to the post appearing. What is even more frustrating is when you hit the send button and realise you have made a mistake or mistyped something. There is no way of withdrawing it and

RE: Remember me? Oracle DBA veteran considering getting certifi

Paula, Your experience sounds very similar to mine which I documented on http://www.hcresources.co.uk/ocp.htm http://www.hcresources.co.uk/ocp.htm . I used the Exam Cram series and was very happy with them. I am booked for the 8i upgrade next week but despite using 8i for however long it has been

RE: datafile sizing question

We tend to use multiples of 1Gb and add 1 Mb to the file so that we get 2001, 10001 Mb etc Solaris 2.8 LMT uniform extents range from 64K to 20Mb John -Original Message- Sent: 25 September 2002 19:44 To: Multiple recipients of list ORACLE-L We created two datafiles of 16GB+64K all

RE: datafile sizing question

Yes, 10Gb datafiles. I think we have a 35Gb datafile somewhere but I have not looked at that database myself John -Original Message- Sent: 26 September 2002 12:03 To: Multiple recipients of list ORACLE-L 10001Mb? the uniform extent sizes map to what I'll be using as well. good to

RE: datafile sizing question

Tim, I cannot speak for the 35Gb datafile which is a one-off but for the systems where we have datafiles files 4Gb we invariably use EDM to break a mirror and then RMAN proxy against that. The mirror is then kept off-line until we are ready to do the next backup. At that point the mirror is

RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?

Hemant wrote Therefore, to reduce the contention for the hot blocks, I decide to have only 1 row in each block. Normally, with a *NEW* table, PCTFRE 99 and PCTUSED 1 would ensure that I have only 1 row per block. But if I have a large number of blocks in a few extents created when PCTFREE was

RE: patch backout

Managing patches with Oracle Applications is always a difficult task. The various sites I have worked on seem to have the same general policy 1)Do not apply a patch unless absolutely necessary. A lot depends on the type of patch, ie a simple fix is different from a big patch that can have

RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?

No, it is not retrospective. You are setting parameters to be used when the next extent is created. A better example is when setting next extent size to be different than the existing extent size (dictionary managed tablespaces only). It does not alter all the existing extents it only works on

RE: excessive SMON on openvms

Ron, Is it normal for your system manger to suspend Oracle processes? John -Original Message- Sent: 23 September 2002 20:24 To: Multiple recipients of list ORACLE-L List, I have a new server that I installed Oracle 8.1.7.3 with partitions and LMT. Some of the tables are quite large(

RE: DBA work load

I assume it is when penalty payments come into play when SLA targets are not met. Therefore payments for provision and support of an Oracle database are rebated John -Original Message- Sent: 24 September 2002 14:03 To: Multiple recipients of list ORACLE-L What is a rebatable SLA?

RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?

Well I was sure about it until you had the temerity to question me :) I think we agree on extents sizes not being changed after the event so it is now a discussion on whether changes to a pctfree/pctused are retrospective. I contend that if a table is fully loaded upto its pctfree/pctused limits

RE: Data file size growing causing high disk space.

David, Have you got autoextend on the datafiles?. Are you sure the datafiles are growing and it is not that somebody has placed an export dmp file there (just guessing that from the name of the filesystem!!) I am not sure what you when when you say you have datafiles saved there?. Are they the

oraperf report - 2 queries

I have just tried using www.oraperf.com again after about a year since the last time. The output both in terms of formatting, readability and comment are much improved on what was already a valuable resource Well done Anjo 2 questions that the list (or even Anjo) may be able to answer for me

RE: runInstaller - Version to use

The installer in 8.1.7.0 goes into the oui (Oracle Installer directory) If I go to $ORACLE_BASE (which contains directories for my various installations 8.0.6, 8.1.7.4 etc) there is a directory called OraInventory that contains a file called oui.loc. Cat that file and a variable INSTLOC tells

RE: Moving to UK - what are Oracle contracts like?

Grant, I agree with Lewis, things are tight here. Very hard to find work and you have to compete hard on rate to have a chance. You have to work as a ltd company - does not cost much to set up , or use an umbrella company. I would recommend joing the Professional Contractors Group

How to tell if an o/s and oracle installation is 32 or 64 bit

Within sqlplus desc v$session and look for the definition of saddr (if raw(4) then 32 bit else if raw(8) 64 bit) John Hallas Office: ( 016356 ) 77929 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services

RE: Bitmap Header in a Uniform LMT?

I have been looking at LMT recently I created a 10001M datafile at 8K block size for a 64K locally managed extents Noticed from dba_free_space that the largest contiguous free space was 3968M Dumped the file header and got the same results as Paul / Jeremiah but I did note that for a 8k block

RE: RMAN: How to restore backup to a different box

Helmut, Check out the newname command that can be used when duplicating a database set newname for datafile 1 TO '$ORACLE_HOME/dbs/newdb_data_01.f'; set newname for datafile 2 TO '$ORACLE_HOME/dbs/newdb_data_02.f'; set newname for datafile 3 TO '$ORACLE_HOME/dbs/newdb_data_11.f';

RE: Performance Problem after Migration

Scott, I don't understand I have tried to capture a session, but I need to get a repository up to look at the trace that was generated. No mention of Oracle versions or even O/S levels but I am sure you have Statspack available which should give you a good start. So have an overall view of

RE: Oracle Heterogenous Services

And is it needed?. I am sure I have set up odbc connections between Oracle 8i databases on Unix and Access/Excel and I have never heard of Heterogeneous Services before -Original Message- Sent: 31 July 2002 13:24 To: Multiple recipients of list ORACLE-L I did a bit of research on

RE: There are even more plots to go around.

Well I would not like to get stuck in a corner with you at a party Eric I thought it was a good light-hearted read but I am very superficial (on the surface of course) John -Original Message- Sent: 31 July 2002 10:53 To: Multiple recipients of list ORACLE-L insipid, boring, devoid of

RE: TRANSLATE

Not very elegant but it works create table test (a varchar2(30)); SQL insert into test values 2 ('comma'||chr(44)||'squote'||chr(34)||'dquote'||chr(39)) 3 / 1 row created. SQL select * from test; A comma,squotedquote' select

RE: Faster Sqlloader Question

See Oracle SQ Loader - The definitive guide by Jonathan Gennick Amazon URL is http://www.amazon.com/exec/obidos/ASIN/1565929489/qid%3D1028034789/sr%3D11-1 /ref%3Dsr%5F11%5F1/104-2680480-7921519#product-details Also there is a good review (and examples) by a member of this list - Stephen Andert

RE: pfile/spfile Sync Problems

John, I have been discussing this with a colleague and our question is - what are you hoping to achieve? If you are using a spfileSID.ora file then that will be used every time you startup so in what circumstances would you use the pfile? PS one suggestion re the problem creating the trigger is

RE: ONLINE index creation in 8.1.7.2

Rich, There was a definite bug with online index creates in 8.1.7.1. I think it was fixed in 8.1.7.3 but I am sure it is OK in 8.1.7.4 John -Original Message- Sent: 29 July 2002 16:29 To: Multiple recipients of list ORACLE-L Hi all, Has anyone experienced problems using the ONLINE

RE: Select Query - Help required

A similar question was asked a while ago and I kept the answer as I thought it might be useful The following PL/SQL snippet should demonstrate a way to do what you want set serveroutput on 100 Declare sn varchar2(2000); cursor c_devices is select name from ashoke; Begin for

RE: where should i start to learn to become a DBA?

Well you started off in the best position for a DBA Martin, looking down on the rest of them :) John -Original Message- Sent: 25 July 2002 14:04 To: Multiple recipients of list ORACLE-L In my case, I was invited to a meeting attended by 6 people. The meeting room had 5 chairs. When

RE: Rant

Referring to the last answer about getting a coffee I don't actually think that is a bad answer!! If he meant I will not rush in and do something rash, rather I will plan what I am going to do and check the book to make sure that I am correct then I think that is a perfectly acceptable approach.

RE: OFF TOPIC:Be careful from www.crescent.cc company

Surely in your case that is all hypothetical isn't it Lee :) -Original Message- Sent: 18 July 2002 14:49 To: Multiple recipients of list ORACLE-L Caveat Emptor my friend. I would have never have sent either money or educational qualifications (esp. originals) either domestically or

RE: download leads to sales call

Yes, that tend to do that with the less experienced, I think they call it hand holding :) -Original Message- Sent: 10 July 2002 01:08 To: Multiple recipients of list ORACLE-L oh yea they call me everytime i download something. joe Jonathan Gennick wrote: Last week I downloaded

RE: DB_FILE_NAME_CONVERT issue

If you have a proper OFA setup then the problem is not to big. The syntax is db_file_name_convert=('/vobs/oracle/dbs','/fs2/oracle/stdby') log_file_name_convert=('/vobs/oracle/dbs','/fs2/oracle/stdby') where you are changing files that are in /vobs/oracle/dbs on prod to /fs2/oracle/stdby/ on

RE: OCP discount

OPP gets you 35% discount (state member of OTN) John -Original Message- Sent: 05 July 2002 16:13 To: Multiple recipients of list ORACLE-L Anybody knows of a current magic code for a discount on OCP exams. I am particularly looking into the 8i DBA upgrade if this does matter. Thanks.

RE: LogMiner errors

David, I recall that there is a limit (42 characters?) on the name of the dictionary file. 2 ways round it. Create the file in the top level ie /export/dict.ora or create a symbolic link with a shorter name. I have a page on my web site which mentions this problem (www.hcresources.co.uk).

RE: Count rows in textfile

Try the following which will give the number of line in the file cat filename | wc -l HTH John -Original Message- Sent: 03 July 2002 09:43 To: Multiple recipients of list ORACLE-L Anyone whom has a good example on how to check how many rows (without opening the file) does a text

RE: OPS and redos

Thank you Scott for supplying a well-written summary of SCN usage within OPS nodes. I was interested in If the gap in the log sequence gets to big Oracle will force the idle node to do log switches I was not aware of that and whilst I believe you, I cannot see what the reason behind it is.

RE: how to tell if OPS

I know it means either logging or or searching a init.ora file but how about select name,value from v$parameter where name = 'parallel_server'; I cannot see anything obvious from ps -ef John -Original Message- Sent: 03 July 2002 16:18 To: Multiple recipients of list ORACLE-L Is

RE: dbms_space_admin.tablespace_migrate_to_local

John, Funnily enough I was just looking at this in the docs. It appears you can specify a extent size but not whether auto allocate or uniform. But the docs do state Tablespaces migrated to locally managed format are user-managed which I think gives you the answer. To migrate a tablespace 'TS1'

RE: RE: Difference Between DBMS/RDBMS

Didn't Larry call you direct to let you know Mike?. Very inconsiderate of him -Original Message- Sent: 26 June 2002 11:44 To: Multiple recipients of list ORACLE-L Live and learn =) I wasn't using VMS at the time but all the same, I'm surprised I haven't heard about it. Many thanks,

RE: Flush Shared Pool Area

Normally this is done when you are getting ORA-4030 (maybe ORA-4031 as well) errors. Basically the shared pool is fragmented and a object is trying to load but cannot find sufficient contiguous free space. Flushing the shared pool clears everything out and the package should load. Bear in mind

RE: SQL*LOAD question

See post below from Stephen Andert (21/6/02) David, start shameless self-plug I wrote an article last year about tuning SQL*Loader. It is at http://oracle.oreilly.com/news/oraclesqlload_0401.html I experienced a huge improvement in performance and others have told me that they were able to

RE: HP-UX 11.0/8.1.6.2.0/Optimizer

Ferenc, Looks like you got your way with the result. Depressing but true What happened to your web site, is it still up and if so what is the URL Regards John -Original Message- Sent: 25 June 2002 13:33 To: Multiple recipients of list ORACLE-L Mike Siebel does not support CBO

RE: Urgent : UTL file problem

I think a '/' is missing after vijay. The documnentation states "The file location and file name parameters are supplied to the FOPEN function as separate strings, so that the file location can be checked against the list of accessible directories as specified in the initialization file. Together,

RE: ora 24314: service handle not initialized, when connecting as

Version of database?. Have you set ORACLE_HOME as well as ORACLE_SID? What command are you typing. Are you running from an authorised account that allows internal connection (within the dba group) John -Original Message- Sent: 21 June 2002 13:37 To: Multiple recipients of list ORACLE-L

RE: Data Types

Concepts manual VARCHAR2 and VARCHAR Datatypes BM_707The VARCHAR2 datatype stores variable-length character strings. When you create a table with a VARCHAR2 column, you specify a maximum string length (in bytes, not characters) between 1 and 4000 for the VARCHAR2 column. For each row, Oracle

RE: Performance Tuning and Backup Recovery

Here are replies to a couple Sam, 1) If optimiser mode is chose and any table in a query has stats then CBO will be used. If stats do not exist on any table Oracle has a hard-coded default value which is 100 if I recall a note on here correctly. If stats do exist but they are very old then they

RE: AW: off topic: anyone form Amsterdam, Holland / other maj

Funny being a non-American I understood the sentence to mean the opposite you did :) -Original Message- Sent: 11 June 2002 16:49 To: Multiple recipients of list ORACLE-L Stefan, I was in Holland some years ago, alright many a year ago (1983). I did not find the people there

RE: Oracle 32 Bit running on Solaris 64 Bit

Title: Oracle 32 Bit running on Solaris 64 Bit As far as I am aware there is no advantagein running 32 s/w on a 64 bit o/s. In fact the reverse is true, there could be significant disadvantages. Any impact would be at a very low level and not noticeable from a user perspective (unless data

RE: How to move 200 GB db from prod to dev?

Title: How to move 200 GB db from prod to dev? A few options. Do you use RMAN for backups? , if so duplicate the database and rename the files as part of that process. Otherwise clone the database by copying the files at the o/s level and change the instance name. Several documents on

RE: Re: Textfile into oracle

Roland, If you are saying that you have 100 columns in the spreadsheet but you only want to copy 9 columns into a table with 9 fields then you have 2 choices. Reduce the spreadsheet to only 9 columns (by copying to another worksheet) and then saving as a CSV file and importing by sqlloader. I

RE: Upgrade Question

may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: Networking problem

Title: Networking problem Just a couple of thoughts to try and narrow the problem down. 1) Have you tried a single client to the 8.1.7 database and then to the 9.2 database. If so then is it disconnecting from both or just the 9i one. That would be a test worth trying as you are then

RE: updated rows count

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: Question on V$ping table

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: John Hallas INET: [EMAIL PROTECTED

RE: Shared Pool Tuneup

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

RE: Trigger or ????

Title: Trigger or Why not set a dbms_job up to recreate the sequence or even a cronjob which is quite easy to set to run at 00:01 John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Burton, Laura L. Sent: 14 May 2002 15:58 To: Multiple

RE: Prod problem, please help!!! Any resolution?

Title: RE: Prod problem, please help!!! Any resolution? Glad you asked Hannah because I was wondering the same John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: 01 May 2002 13:18 To: Multiple recipients of list

RE: Prod problem, please help!!!

, 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: John Hallas INET: [EMAIL PROTECTED] Fat City

RE: 9i new features, the saga continues?

Joe, That feature was really useful and interesting. I would be pleased to see you continue it John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jack C. Applewhite Sent: 25 April 2002 16:33 To: Multiple recipients of list ORACLE-L

RE: Get the Latest Date

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

RE: 1Z0-007 Exam

Ken, If this is the 9i upgrade exam then there was a discussion on this recently (about 3-4 weeks ago) Search the archives for a post by Mike Hateley and responses from Robert Freeman. If is not the 9i upgrade which exam is it? John -Original Message- From: [EMAIL

RE: Developer access in test database

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

RE: SQL statement with hints or without hints

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

RE: Solaris 2.8

, 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: John Hallas INET: [EMAIL PROTECTED] Fat

RE: Another RMAN Problem --- Urgent !!

on the server. They could then take a database dump with their tool and extract the lost records. This is my script which I compiled with help from Metalink and an old post from John Hallas (the backup of our target database is taken on tape with Veritas Netbackup) : #!/bin/ksh rman target

RE: Another RMAN Problem --- Urgent !!

a point of time (as on Wednesday night) to a different location on the server. They could then take a database dump with their tool and extract the lost records. This is my script which I compiled with help from Metalink and an old post from John Hallas (the backup of our target database is taken on tape

RE: Another RMAN Problem --- Urgent !!

have raised this question before with Oracle and I did get an answer as to why you still needed to connect to the target database. I cannot remember what the answer was but I though it pretty weak at the time. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John

RE: SQL*Loader

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: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: Another RMAN Problem --- Urgent !!

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

RE: SQL Tuning - How to avoid TOCHAR function against a date

://www.orafaq.com -- Author: John Hallas 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

  1   2   >