RE: High values

John, Look at the DECODE statement. You can use it in the ORDER BY clause. I would *never* insert a garbage value into a database column as you are talking about. How do you determine if it is truely garbage? You know of course, if you selected a high values value today, that next month that

Re: Lost ofall redo logs

Tom, that statement will open a can of worms(like a religion following) about if/when to backup redo logs. :) joe Mercadante, Thomas F wrote: I agree with you Joe. I would *never* use an undocumented parameter unless Oracle told me to (or unless I was testing something that I could

Re: Consulting Position Available-Oracle DBA/Developer/NYC

Does anybody know what table is in MS SQL instead of Oracle DUAL? Thanks JP On Friday 20 September 2002 14:53, you wrote: T is for trasnsactional SQL which is SQL Server and Sybase terminology. -Original Message- Sent: Thursday, September 19, 2002 7:13 PM To: Multiple recipients of

Re: Best method to move Filesystems to RAW Devices.

the first question is WHY go to raw devices?, OPS/RAC? other than those 2 reasons(and i'm not sure RAC requires it like OPS did), there is very little performance gain with the advances in filesystem types. just curious. joe Nat wrote: We are planning to move to raw devices for all our

RE: Lost ofall redo logs

Well, it didn't sound like he was using Rman (which does not backup redo logs). So I assumed that he was/should be using a cold-backup strategy - which, if it were me, would backup the redo logs. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, September

RE: count(*)

What about having a separate table with a single column and a single row to store only the count, and increment and decrement it using a row trigger on Insert and deletes? that way select count(*) will be very fast, the only ovehead will of the trigger, which i think should be offset by the

RE: Consulting Position Available-Oracle DBA/Developer/NYC

Hallo, What is dual? ;o) I don't think there is such a beast in SQL Server Dave -Original Message- Sent: Friday, September 20, 2002 8:43 AM To: Multiple recipients of list ORACLE-L Does anybody know what table is in MS SQL instead of Oracle DUAL? Thanks JP On Friday 20 September

migrated from 8.1.5 to 8.1.7 and Migration Assistant moved my $OR

can anyone tell me why this happened? Sebastian DiFelice DBA/Database Analyst Thomson Intelligence Data (617)856-1587 www.intelligencedata.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DiFelice, Sebastian INET: [EMAIL PROTECTED] Fat City Network Services

Backup Strategy - Informal Survey

I'd like to pose a question to you all and get your response. If you are running a database that is larger than 250GB, what place in your backup strategy does a logical export have? Do you do logical exports at all, and if so with what frequency? Do you feel that logical exports are an important

RE: migrated from 8.1.5 to 8.1.7 and Migration Assistant moved my

can you better explain what the question is? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, September 20, 2002 9:48 AM To: Multiple recipients of list ORACLE-L $OR can anyone tell me why this happened? Sebastian DiFelice DBA/Database Analyst Thomson

Re: Best method to move Filesystems to RAW Devices.

Dennis, Thanks for the reply. We have not done any benchmarks to find out if there is any performance gain. The main reason for moving to raw devices is to convert our existing database to function on OPS environment and then eventually to 9i RAC. After we move on to raw (without OPS), may be

RE: Consulting Position Available-Oracle DBA/Developer/NYC

Now I know. I assume that it's enough like SQLPlus that it seems familiar and different enough that you can really foul yourself up. Farnsworth,

Re: Best method to move Filesystems to RAW Devices.

Mark, Thanks for the reply. We are on AIX 4.3. We are not changing hardware when we move on to RAW devices. Our entire hardware is going to remain same. We feel dd is the fastest method of copying the files. But we need to figure out how many blocks we should skip in raw devices.(point 2 in

Re: Consulting Position Available-Oracle DBA/Developer/NYC

Jan Pruner wrote: Does anybody know what table is in MS SQL instead of Oracle DUAL? Thanks JP SQL Server does not have a dual table, pos... -- Give a man a fish and he eats for a day, show a man the net and he'll be preoccupied for month's. -- Please see the official ORACLE-L FAQ:

Re: count(*)

Tom, The sequences are transaction independant, so the trick with 'select sequence_name,last_number from user_sequences' will only work if there are no rollbacks after insert as well as no use of cache in sequence as you mentioned. Moreover, what if records get deleted? I guess this may be

Re: listener problem ???

Do you have a service like Oracle_HOMETNSListener? I assume that you must. You don't need a separate listener for each instance. What does the TNSNames.ora entry for LMANAGER look like?

Re: Consulting Position Available-Oracle DBA/Developer/NYC

Jan, There is no need for such table in SQL Server. If you need, you do just: select 'whatever' without from clause. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 20, 2002 9:43 AM

Re: Job postings was:Re: Lost ofall redo logsOTHER...

JT., Do you have any awareness of www.ORAFAQ.com Oracle-job.net? Thanx, Bill --- Joe Testa [EMAIL PROTECTED] wrote: Bill I'm kinda surprised no one has replied. I'm seeing pockets of oracle work in cols most of it is short-term(ie: 3 months). This is the best place to find what I'd

Re:Backup Strategy - Informal Survey

Robert, I don't do exports of our large production systems mainly due to the fact that I'd have to export them to tape and getting that much quite time, so as not to bump in to an ORA-01555 or have someone else hit a rollback segment issue, is impossible. Consequently two hot backups a week

RE: Consulting Position Available-Oracle DBA/Developer/NYC

there is no such beast as DUAL in MS SQLServer. if what you want is the result of a function just leave off the from clause like so: select getdate() -Original Message- Sent: Friday, September 20, 2002 8:43 AM To: Multiple recipients of list ORACLE-L Does anybody know what table is in

RE: migrated from 8.1.5 to 8.1.7 and Migration Assistant moved my

When I upgraded and migrated from 8.1.5 to 8.1.7 the Universal Installer/Migration Assistant moved my $ORACLE_BASE from /disk03/app/oracle to /disk03/app/oracle/product/8.1.5 (which is my $ORACLE_HOME) without prompting me for the move. SD -Original Message- Sent: Friday, September 20,

Query Tool That Reads LOBs, CLOBs, etc.

We have a development project that is using third party software. The tables include several clob datatypes. The project needs to identify a tool that allows a knowledgeable user can use to browse data in the CLOBs. Does anyone have any suggestions of tools to do this? Thanks, = Pete

Re: Best method to move Filesystems to RAW Devices.

Joe, We are planning to move to RAC. Per Oracle RAW devices is must for RAC. As you said, Yes there is little performance gain just moving to RAC and more work to DBA's/SA's. But this seems to be the main requirement for RAC. - Original Message - To: Multiple recipients of list

RE: Database Performance Tuning and Optimization: With Examples f

If sales from my Mastering Oracle8i book are any indication, the market for 8i specific books is long gone. :-( I'm thinking that the 9i specific book market will probably start to slow down (if it hasn't already) pretty soon. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX

RE: Query Tool That Reads LOBs, CLOBs, etc.

Title: RE: Query Tool That Reads LOBs, CLOBs, etc. I think latest version of TORA and TOAD can read it. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't

RE: Consulting Position Available-Oracle DBA/Developer/NYC

Tom - actually, the SQLPlus like thingie in sybase/m$ land is called isql (interactive sql). T SQL is the SQL dialect understood by those RDBMSs. so you type yout T SQL queries into isql. -Original Message- Sent: Friday, September 20, 2002 9:24 AM To: Multiple recipients of list

Re: Backup Strategy - Informal Survey

I do nightly exports of my large databases with ROWS=N. This way I can restore users, grants, indexes, table definitions, etc. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 09/20/02 10:13AM I'd like to pose a question to you all and get your response.

Re: Consulting Position Available-Oracle DBA/Developer/NYC

So Oracle statement SELECT TO_CHAR(33) FROM DUAL is in TSQL only SELECT CHAR(33); ? I was searching docs, but didn't find it. I know on Sybase SQL Anywhere is it DUMMY, but it doesn't work on MSSQL (and DUMMY is on MS SQL reserved word!!) JP On Friday 20 September 2002 16:18, you

Re: Backup Strategy - Informal Survey

Our db size is around 350Gig. We have stopped full logical exports since our database size has grown above 200 Gigs. It is just not feasible for us to do the full exports anymore, time it takes to export is too much. We use EMC/EDM bcv splits to do a hot backup every night. We shutdown our

Re: Consulting Position Available-Oracle DBA/Developer/NYC

Thanks. I tried it and it works, but I was not sure if it is right or not. JP On Friday 20 September 2002 16:18, you wrote: Jan, There is no need for such table in SQL Server. If you need, you do just: select 'whatever' without from clause. Igor Neyman, OCP DBA [EMAIL PROTECTED]

Re: Best method to move Filesystems to RAW Devices.

Nat, totally understand. joe Nat wrote: Joe, We are planning to move to RAC. Per Oracle RAW devices is must for RAC. As you said, Yes there is little performance gain just moving to RAC and more work to DBA's/SA's. But this seems to be the main requirement for RAC. - Original Message

RE: migrated from 8.1.5 to 8.1.7 and Migration Assistant moved my

Title: RE: migrated from 8.1.5 to 8.1.7 and Migration Assistant moved my i had the same issue where all my data files were moved to the same slice which fortunately i had a large slice. i ended up doing the manual upgrade steps through the Migration manual. -Original Message- From:

RE: Database Performance Tuning and Optimization: With Examples f

Robert - Maybe this argues for the book being really, really good, if a publisher decided to release it at this stage. If anyone has a chance to browse it, I would be interested. Say Robert, as a noted author maybe you could get your publisher to request a complimentary professional review copy??

Re:Backup Strategy - Informal Survey

Robert - My info: Oracle 8.1.7 E.E. Largest DB is 900gb Hot Backups 2x week Cold Backups 1x month Export Backups 1x week on selective schemas I do export backups for creation of test db's, recover data validation blunders, i.e. single object restores. Future plans are RMAN, RMAN, RMAN on 9i.

RE: Lost ofall redo logs

I'm not an expert so pardon me if i'm wrong. Why to copy the log files in case of a cold backup if the instance was shutdown cleanly(NOT ABORT)?? The d/b will be consistent so we don't need the redo-log files, isn't it? Isn't it that the DB update all the Datafiles headers with the checkpoint

DUAL Was: Consulting Position Available-Oracle DBA/Developer/NYC

As well as in MySQL There is no need for such table in SQL Server. If you need, you do just: select 'whatever' without from clause. Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

RE: count(*)

There is a difference between 10 and 120 minutes, especially on Friday. -Original Message- From: Anjo Kolk [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 3:03 AM To: Multiple recipients of list ORACLE-L Subject: Re: count(*) If you can live with 10 minutes, why not

RE: Backup Strategy - Informal Survey

An export with data will probably cause more headaches than it solves in large DBs. A logical export without data will also have limited use. It is quick to do and small but I suggest may be invaluable for various tasks. Mike Jenner Database Administrator -Original Message- Sent: 20

Stupid Bind Variable question

In any given SQL statement, do I need (or should I :^) ) create a bind variable for every literal value even if it is one of the following cases: 1) substring in a substr function 2) date/time format mask used in to_char or to_date function 3) comparison value in a decode/case statement

RE: Consulting Position Available-Oracle DBA/Developer/NYC

It is a reserve word but has no purpose that I can find. I'll dig deeper -Original Message- Sent: Friday, September 20, 2002 10:34 AM To: Multiple recipients of list ORACLE-L ARE YOU AN IDIOT? But MS SQL has DUMMY. I don't know why {if they don't have DUAL). Maybe

Re: Consulting Position Available-Oracle DBA/Developer/NYC

I think DUMMY is MS reserved word :-) And yes, SELECT CHAR(33) -- no semicolon will work. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 20, 2002 11:18 AM So Oracle statement SELECT

How to load text file into database table

I have a text file and need to load it into database table using sqlldr utility. Is there a way to load a text file? I know how to load csv file but not text file. *** Below is text file format. Date: Wed Aug 29 10:43:53 CDT 2001 Name: Paris By Night Email: [EMAIL PROTECTED] Phone:

RE: Best method to move Filesystems to RAW Devices.

Nat- You may want to check out a product from Veritas.. *Supposedly* their clustered file system product is *approved* with 9i RAC on a SUN platform.. This is strictly from the rumor mill and I have no solid documentation to confirm (CYA). I am actually in the beginning phases of a project to

RE: count(*)

Title: RE: count(*) That is the best advice yet. Duh for the rest of us. -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 10:53 AM To: Multiple recipients of list ORACLE-L Subject: RE: count(*) this is what Oracle

RE: Best method to move Filesystems to RAW Devices.

Nat - I haven't worked with raw for a few years, but from my dim recollection, since you are managing what is on the device, first the system administrator had to tell me how many blocks I could write to. I also dimly recall the AIX issue, but certainly couldn't recall the answer. Anyway, this

RE: How to load text file into database table

David - If the file is in just the format you show, my first impulse would be to use the perl script language to get it into a form that sqlldr could easily read. Perl is available on all platforms, including Windows. If you get ambitious, Perl can even directly insert the values into Oracle.

RE: DUAL Was: Consulting Position Available-Oracle DBA/Developer/

Ditto for PostgreSQL. For portability you can create a dual table but you have to ensure that it only has one row. ;-) I finding that portability between PostgreSQL and Oracle is easier than most... same to_date, to_char functions, and stuff. Seems like that's part of Postgres' strategy.

RE: Backup Strategy - Informal Survey

Robert I don't think a full export has a place since your largest tables are probably too large to reimport in a reasonable amount of time. I like Jay's suggestion though. But your original question wasn't about a full export, you just said export. My answer is a definite yes. Following

RE: Consulting Position Available-Oracle DBA/Developer/NYC

I think Dummy is a MS synonym April Wells Oracle DBA Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous -Original Message- Sent: Friday, September 20, 2002 11:13 AM To: Multiple recipients of list ORACLE-L I think DUMMY is MS

RE: count(*)

but sequences cannot be decremented by PREVVAL too, what about DELETIONS?! -Original Message- Sent: Friday, September 20, 2002 8:23 PM To: Multiple recipients of list ORACLE-L this is what Oracle invented SEQUENCES for! :) Tom Mercadante Oracle Certified Professional -Original

Re: Consulting Position Available-Oracle DBA/Developer/NYC

exactly, what I meant :-) just today I had to deal with the stupid SQL Server problem: once in a while it cannot find a stored procedure on the server, that nobody touches, and then (in 5min) it finds it - no problem. yes I'm lucky to work with both Oracle and SQL Server :-) (the second was not

RE: count(*)

Naveen - This approach would probably work fine as long as only a single process was running. If multiple processes were inserting rows (likely at the scale of millions of rows/hour), this new table would probably be the bottleneck. Each process must acquire a lock on this row of this table, so

RE: Lost ofall redo logs

Naveen, Why NOT take the redo log files in a cold backup? If you restore these cold backup files and intend to use them, you would then have to open the database with the RESET LOGS option to re-create the redo logs. This would then invalidate all of your archive log files. And Joe - thanks!

Re: Backup Strategy - Informal Survey

On Fri, 20 Sep 2002, Nat wrote: We use EMC/EDM bcv splits to do a hot backup every night. We shutdown our database once a week for half an hour for cold bcv splits. So far it has worked very well. Just curious, why do you do a cold backup weekly? Do you not trust your hot backups? --

How can I change Oracle as well as NT Domain passwords

Hi All How can I change passwords of a user of Oracle application as well as W2K/NT Login? Any utility in 8/8i can do this form me? Thanks in Advance Shiva B -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baswannappa, Shiva INET: [EMAIL PROTECTED] Fat City

Re: DUAL Was: Consulting Position Available-Oracle DBA/Developer/

We are using PostgreSQL, but still have problems with statistics. Sometimes after VACUUM ANALYZE optimizer doesn't use indexes and performance goes down. JP On Friday 20 September 2002 18:43, you wrote: Ditto for PostgreSQL. For portability you can create a dual table but you have to ensure

RE: count(*)

Naveen, Please read all the posts. That is the first question I asked. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, September 20, 2002 1:04 PM To: Multiple recipients of list ORACLE-L but sequences cannot be decremented by PREVVAL too, what about

Re: count(*)

Do you really need it? In case of huge DELETE statement you can always recreate sequence with START WITH primary_key+1. JP On Friday 20 September 2002 19:04, you wrote: but sequences cannot be decremented by PREVVAL too, what about DELETIONS?! -Original Message- Sent: Friday,

RE: Staspack Grapher/Viewer ?

Ah, that makes much more sense to me. That's more the idea I had in mind when I installed STATSPACK. That, and the ability to be able to look back in time to potentially see why our nightly jobs are still running at 8:00 AM. (insert system-stats-vs-session-stats argument here) :) Thanks,

Re: Backup Strategy - Informal Survey

No we do trust our hot backups. Our databases are mostly idle during early ours of Sunday between 12 AM - 1 AM. So we thought lets go for a cold backup on weekends. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 20, 2002 12:28 PM

Another Case Insensitive Question

Hello Everyone, Access 2000 on Windows NT Oracle 8.1.7.4.0 on HP-UX 11.0 64-bit Currently both the front end and back end are in Access 2000 and we are moving the back end to Oracle. I've got a situation here I'm not sure how to deal with. Does anyone know how to do case insensitive queries

RE: PL/SQL help

David- I've thought of both dbms_sql and dummy conditions too. Oracle Application reports use the dummy conditions all the time. I'm off to see if you can set cursor_sharing at the session level and not use bind params. I'm assuming no one else has figured this out either due to the lack

RE: Lost ofall redo logs

My long standing position on this is that you take backups so that Just in case something fails, you have the ability to recover. If something has failed, I want backups of EVERYTHING. I know I dont' need the redo logs, but I would feel awful silly if I needed them at some point but didn't back

RE: Backup Strategy - Informal Survey

Well I just happen to know of this great Oracle Press RMAN book due out in October! RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the

RE: copying all schemas except sys

Hi Well my import choked on the package SYS.DBMS_REPCAT_UTL so I assumed that there was SYS stuff in the full export. -Original Message- Gopalakrishnan Sent: September 19, 2002 3:43 PM To: Multiple recipients of list ORACLE-L Export program **never** exports the contents of SYS.

RE: copying all schemas except sys

Hi Well my import choked on SYS.DBMS_REPCAT_UTL so I just assumed that there was SYS schema stuff in the full export. I see now that the import must execute this package. This package was having a problem with the fact that the exported global name did not match that of the instance I was

RE: DUAL Was: Consulting Position Available-Oracle DBA/Developer/

Jan, Which version of PostgrSQL are you using? --Walt Weaver Bozeman, Montana -Original Message- Sent: Friday, September 20, 2002 11:35 AM To: Multiple recipients of list ORACLE-L DBA/Developer/ We are using PostgreSQL, but still have problems with statistics. Sometimes after

RE: Backup Strategy - Informal Survey

On our larger database we do exports of some of the smaller users which also have frequent changes. I wish I had some of the larger tables also, it would have saved a big headache last week getting one table restored (7 days to get the files restored from tape, 1.5 hours to modify the control

Re: Lost ofall redo logs

I agree, there is never a problem because you backed up redo log files. There could be a problem with inadvertently restoring them, covering up needed information in the current online redo logs. John [EMAIL PROTECTED] wrote: My long standing position on this is that you take backups so

RE: Another Case Insensitive Question

Title: RE: Another Case Insensitive Question Julie, Get a copy of Find and Replace by Rick Fisher. The url is below. With it you CAN change all those queries and reports in the Access FE. It's one of the best $37 an Access developer can spend. http://www.rickworld.com/products.html You

RE: count(*)

I think maintaining counts in other table (Naveen's approach) is more of an application issue. To avoid multiple processes waiting for a lock to update records in seperate table, you could have each process its dedicated row in a seperate table with the current count in it. A slight modified

Re: Best method to move Filesystems to RAW Devices.

Dennis, We are thinking of doing following steps for our RAW conversions. Let me know whether it makes sense, 1. Shutdown Database. 2. Take Full Backup 3. Setup all our raw devices ( properly corresponding to our original filesystem datafiles.) 4. Bring up the database in restricted mode. 4.

RE: count(*)

Title: RE: count(*) Hmmm ... everyone is throwing their ideas around ... so here is mine ... Hopefully on this large table you have a PK. 1. First time when you do the count(*) (I hope it will be 10 minutes), do it as follows ... select count(*), max(pk_column) from my

RE: Backup Strategy - Informal Survey

Nat Just a plug for always testing your backups, regardless of whether you are doing hot or cold. We do cold backups, and we test them from time to time by restoring them on a test system so the developers have some data to test against. Several times over the years we've found that a file

Re: Stupid Bind Variable question

Alan Davey wrote: In any given SQL statement, do I need (or should I :^) ) create a bind variable for every literal value even if it is one of the following cases: 1) substring in a substr function 2) date/time format mask used in to_char or to_date function 3) comparison value in a

RE: Lost ofall redo logs

John, seeing as your e-mail name is Ora NT DBA, you probably should have qualified your reply with as long as the DB is down. Backing up live Oracle files on Windows (even NTFS) is a recipe for disaster due to locking problems (with the OS/filesystem or the backup software, I'm not sure). We

RE: How to load text file into database table

Oracle sql*loader has many many features...at two of them are applicable in your specific case. You could use CONCATENATE or CONTINUEIF clauses of control file. These clauses help you wherever you have multiple physical records form one logical record. Cheers Viral Desai. From: DENNIS

Re: Best method to move Filesystems to RAW Devices.

I would change to the following: [EMAIL PROTECTED] 09/20/02 03:09PM Dennis, We are thinking of doing following steps for our RAW conversions. Let me know whether it makes sense, 1. Shutdown Database. 2. Take Full Backup 3. Setup all our raw devices ( properly corresponding to our original

RE: Best method to move Filesystems to RAW Devices.

Nat - I think your process looks fine, bearing in mind that I haven't used raw devices in years. Others on the list use raw on a daily basis, so may offer some suggestions. My question was much simpler. Suppose I have a 80-gig. device, and a 20-gig. datafile. Okay, my recollection is that I

Re: DUAL Was: Consulting Position Available-Oracle DBA/Developer/

7.0 JP On Friday 20 September 2002 20:29, you wrote: Jan, Which version of PostgrSQL are you using? --Walt Weaver Bozeman, Montana -Original Message- Sent: Friday, September 20, 2002 11:35 AM To: Multiple recipients of list ORACLE-L DBA/Developer/ We are using

RE: How to load text file into database table

Viral - I'm glad that someone a lot more familiar than I with SQL*Loader replied, and hopefully that will handle David's problem. I'm just curious about one thing, having encountered this sort of thing before. Can SQL*Loader handle the situation where some lines may not be present? For example,

RE: Best method to move Filesystems to RAW Devices.

Just keep in mind that you can not offline system tablespace ;) - Kirti -Original Message- Sent: Friday, September 20, 2002 2:44 PM To: Multiple recipients of list ORACLE-L Nat - I think your process looks fine, bearing in mind that I haven't used raw devices in years. Others on the

Re: How to load text file into database table

David, I don't know sqlldr that well, but a possible quick and dirty solution - is to load the text file into a one column oracle table, and then in a subsequent step, use SQL to move the data to the proper columns of the proper Oracle table. The ctl file from the first step would be something

RE: DUAL Was: Consulting Position Available-Oracle DBA/Developer/

Thanks, Jan. Are you still at work? --Walt (1.85254E-16ly tall) Weaver -Original Message- Sent: Friday, September 20, 2002 1:59 PM To: Multiple recipients of list ORACLE-L DBA/Developer/ 7.0 JP On Friday 20 September 2002 20:29, you wrote: Jan, Which version of PostgrSQL are you

Re: Best method to move Filesystems to RAW Devices.

Denis, Sorry I missed your main question last time. Each datafile in our database will represent a separate raw device. so question of overwriting files will never come. If I have 30 datafiles in 5 files systems, I will be creating 30 raw devices with properly sized devices to match my

RE: PL/SQL help

Title: RE: PL/SQL help Go to Tom Kyte's sight and look for contexts - he explains a way to build sql statements using native dynamic sql and refcursors and contexts where the select statement and predicate is variable and the output might also be variable. I get there by searching

Spool Oracle Tables into Excel Format

All, Is it possible to create Oracle reports into Excel format ? Is it possible to spool Oracle tables into Excel format? Thanks in Advance Bob __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the

RE: How to load text file into database table

Dennis, Absolutely, I agree. Perl is very handy and easy to learn..., You could use awk also on unix, pretty nifty stuff... To answer to your situation where the REASON line could be more than one/two/three or n lines- Yes, you could use CONTINUEIF. It provides a comparison operators (= and

Re: Best method to move Filesystems to RAW Devices.

Another option is to shutdown db, backup the files to tape, remove filesystems, create symbolic links named the same as your datafile names linked to the raw devices, restore files to symbolic links (i.e. raw devices), startup db. Just a thought. Gene [EMAIL PROTECTED] 09/20/02 04:20PM

Re:Spool Oracle Tables into Excel Format

Bob, You can create a CSV file from SQL*Plus with the following statement: select column_name||','||column_name||','||etc. from table_name where ..; Dick Goulet Reply Separator Author: Bob Robert [EMAIL PROTECTED] Date:

RE: Spool Oracle Tables into Excel Format

Sure. Use ',' as colsep, and have file extension csv. Jun -Original Message- Sent: Friday, September 20, 2002 4:33 PM To: Multiple recipients of list ORACLE-L All, Is it possible to create Oracle reports into Excel format ? Is it possible to spool Oracle tables into Excel format?

shared_pool error

Hi All! We get ora-04031 on Oracle816 on Unix. I'm aware that this is a bug about memory leak and we planing upgrade to Oracle 8173 to fix it. In a mean time I increased the shared_pool and shared_pool_reserved_size , and also ping some packages in. Now error sad that: enable to allocate 4096

RE: Spool Oracle Tables into Excel Format

Title: RE: Spool Oracle Tables into Excel Format There were some posts recently suggesting the spooling of the columns using a comma as a separator. But check out this article in XML Journal (http://www.syntelinc.com/syntel/english/0072/SYNT_XMLjrnl.pdf). It shows how to build

Re:Spool Oracle Tables into Excel Format

By the way, would you use replace to get rid of the commas withiin fields so that Excel reads it properly? [EMAIL PROTECTED] wrote: Bob,You can create a CSV file from SQL*Plus with the following statement:select

Re: Spool Oracle Tables into Excel Format

You can spool Oracle output into text files using SQL*Plus. Excel can handle plain text and Comma Delimitted Text files. RWB Bob Robert [EMAIL PROTECTED]@fatcity.com on 09/20/2002 03:33:24 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of

OEM - Change Management Pack - opinions, please

We're planning to revisit change management pack to see whether it's useful or not. Versions 2.0 and 2.1 were rejected as buggy and useless. Is anybody here using the Change Management Pack and what are the experiences? Please, do not use expletives in your replies.

RE: copying all schemas except sys

Try setting the GLOBAL_NAMES parameter in the init.ora file to FALSE for the target database. RWB Ben [EMAIL PROTECTED]@fatcity.com on 09/20/2002 01:21:34 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

RE: Authentication with Active Directory

Henry, I've been looking into something similar at a client. I think you want to look at external authentication. This will use your OS authentication, which in turn uses AD. The problem is that OS authentication is not very secure when using PC clients, so we are using Kerberos as well,

RE: How can I change Oracle as well as NT Domain passwords

Are you trying to change the Oracle and NT Domain accounts which are the same and you want the same password ??? If not, write a script or request that one be sent to you. -Original Message- Sent: Friday, September 20, 2002 10:31 AM To: Multiple recipients of list ORACLE-L Hi All

Re: shared_pool error

Greg: If the error is coming from DBMS_OUTPUT, then it is probably PL/SQL related. Try increasing the LARGE_POOL_SIZE parameter in the init.ora file. I would suggest setting it to at least 2MB. By the way, what are the shared_pool_size and large_pool_size parameters set to now? RWB Greg

  1   2   >