RE: filesystemio_options question

Don't understand why would he want to set it to none. I don't see any benefit of doing that. By setting it to none, he disables Async IO and Direct IO. A metalink discussion says you would do it to avoid IO related OS bugs. Were there any IO related problems with that system? Maybe someone

Re: filesystemio_options question

John, This is set to take advantage of the file system access mechanism. For Solaris9, this is recommended to be SETALL, not NONE. This is nothing to do with using a SAN, We use Hitachi 9800 with SunFire 15 Solaris 9 and we have set it to SETALL. Hope this helps. Arup Nanda -

Re: View Question?

Yo, Oracle 7.2 supported updatable views. Some restrictions have been lifted in later versions, others NOT. Mogens Hamid Alavi wrote: List, Oracle8i support insert/updatable view or NOT? Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 ===

Re: View Question?

USE INSTEAD OF TRIGGERS . - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 07, 2003 2:45 PM List, Oracle8i support insert/updatable view or NOT? Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095

RE: SQL question avoiding 2 views and not in

Thanks for the where clause and to all who respond, I'll check into fine grained access control (dbms_rls). --- Khedr, Waleed [EMAIL PROTECTED] a écrit : Add this to where clause: group decode(user,'typical',380,-100) Instead of -100 use any number not used by the groups. Also read

RE: SQL question avoiding 2 views and not in

: [EMAIL PROTECTED] Subject: RE: SQL question avoiding 2 views

RE: SQL question avoiding 2 views and not in

Title: RE: SQL question avoiding 2 views and not in OLS -- Oracle Label Security... I think that's the key you are looking for. -Original Message- From: Stephane Paquette [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 11:59 AM To: Multiple recipients of list ORACLE-L

RE: SQL question avoiding 2 views and not in

Add this to where clause: group decode(user,'typical',380,-100) Instead of -100 use any number not used by the groups. Also read about contexts and grain level security. Waleed -Original Message- Sent: Friday, December 13, 2002 2:59 PM To: Multiple recipients of list ORACLE-L Hi,

RE: SQL question avoiding 2 views and not in

Title: RE: SQL question avoiding 2 views and not in Hi Stephane, This may be more effort but have you considered having a security table to join to in the one view, instead of two views? Multiple views can really hose the optimizer, as I am sure you know. However adding a table

RE: SQL question avoiding 2 views and not in

Title: RE: SQL question avoiding 2 views and not in dbms_rls is cheaper to use ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN

RE: SQL question avoiding 2 views and not in

Title: RE: SQL question avoiding 2 views and not in Has anyone used context and fine-grained security? I seem to remember the performance hit was not minimal when using this functionality. -Original Message- From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]] Sent: Friday, December 13

RE: SQL question avoiding 2 views and not in

: [EMAIL PROTECTED] Subject: RE: SQL question avoiding 2 views

RE: OMF question

There is a OMF related parameter called db_create_online_log_dest_n. This defines where the online redo logs are created. The value n can vary from 1 to 5 and it allows for upto 5 multiplexed copies opf each redo log group member. HTH John -Original Message- Sent: 03 December 2002

Re: OMF question

Its in the 9.2 doco hth connor --- Tinu !@#!^% [EMAIL PROTECTED] wrote: Hi ! I 've a question regarding OMF realted parameter CREATE_DB_ONLINE_LOG_N. Now y is'nt this parameter mentioned in the list of parameters in the Oracle Documenttion cd of 9i. Is it obsolete or oracle does not

RE: OMF question

John , I meant the same param.apologies ,i misplaced db and create. Is this parameter obsolete (with 9i) coz its not mentioned in the Documentation (9i) list of initialization parameters. Only db_create_file_dest is present in the doc. Thanx ! best regards Tc On Tue, 3 Dec 2002 [EMAIL

Re: OMF question

And each of the threads can be defined as either mandatory (the archiving/copy has to succeed for the database to continue running) or not. Mogens [EMAIL PROTECTED] wrote: There is a OMF related parameter called db_create_online_log_dest_n. This defines where the online redo logs are created.

RE: OMF question

It is documented in Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02. Check it out at http://tahiti.oracle.com - Kirti -Original Message- Sent: Tuesday, December 03, 2002 8:49 AM To: Multiple recipients of list ORACLE-L John , I meant the same param.apologies ,i

RE: basic question about db_name and sid

First, it is true that you can have a different SID than your database name. This is usually not recommended because it causes a lot of confusion, but it is possible and there may be some reason out there to have them different. In that case I wouldn't be the one who can tell you why. The

RE: important question about SID environment variable (NT)

Are you talking about ORACLE_SID? It gets stored in the registry under HKEY_LOCAL_MACHINE - SOFTWARE - ORACLE - HOMEID If you want to set it via environment variables so that it is accessible to all DOS shells for a particular login, you can right click on MY COMPUTER, go to PROPERTIES -

Re: basic question about db_name and sid

SID identifies instance, whereas db_name identifies database. It is possible that two or more instances point to one database. HTH, Krishna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 25, 2002 6:04 PM First, it is true that

RE: Updated Question (sorry for the spam)

Not until 9i. I hope I can at least take partial credit for that, as I requested that functionality in a TAR when we were at 8.0. :) HTH! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA

RE: Partition Question

05, 2002 4:09 PM Para: Multiple recipients of list ORACLE-L Asunto: Re: Partition Question I agree... What are you trying to accomplish with partitioning? Partitioning by year / month / day / whatever can make it easy to truncate / archive old data. The only trick is to create new partitions

Re: More question about TEMP

Ron, Data files in this case would be visible in dba_temp_files The object will exist after the session has ended but it will release any space if the session created rows in that object. In other words as you create more rows, it will allocate extents, as soon as your session ends it will

Re: Partition Question

cc: Sent by: Subject: Re: Partition Question [EMAIL PROTECTED

Re: Partition Question

It depends on your reason for partitioning -- if you mean to drop a partition in the future (to roll off the 1999 data or whatever) then the ID range is potentially a valid approach, as long as ID is serial. If you just want to put chunks on different disk volumes, you could use the type or even

RE: Trivia question - not of any practical use.

You are right Marc!! It was the login.sql file. If I remove the file, it works fine. Does this mean that the default value of ECHO is OFF? Suppose ECHO is set to ON deliberately, then while running the temp.sql script the 'SET ECHO OFF' statement will always be echoed, isn't it? Thanks regards,

Re: simple ? question

Stephane, you are right, after I talked to the developer. She is totally confused by alias name, dbname, schema name. She is referring database name. joan Joan Hsieh wrote: Stephane, Well spoken- my bad. Our developer threw me this question when I was just leaving from work. (I copied

Re: Trivia question - not of any practical use.

The easiest solution I can think of is to set spool off within the script. Dennis Charu Joshi wrote: Dear Listers, Given below is a script that I execute from within SQL*Plus for WinNT: temp.sql: - set echo off set pagesize 0 set feedback off SELECT * FROM tab WHERE

Re: Trivia question - not of any practical use.

I don't get that when running on W2K. Are you executing a login.sql or glogin.sql script first? How are you invoking your temp.sql? Using the @ on the command line or redirecting input or typing it in directly? What version of sqlplus? I tried it with 8.1.6. Marc Perkowitz - Original

Re: simple ? question

Joan Hsieh wrote: Hi Listers, I am trying to find a way to know the schema name. Say, if I logged in as jjin01@ngd. When I run a program, how can I get the schema name which should be ngd? If I logged in as bkrasnof@pr, in this case, the schema name will be pr. Thanks in advance,

Re: simple ? question

Stephane, Well spoken- my bad. Our developer threw me this question when I was just leaving from work. ( I copied from her email) Now I am at home to look it over. I am not clear what she asked for. I think she wants to pass a variable based on the @xxx to access this schema. I will make it

Re: simple ? question

Stephane, Well spoken- my bad. Our developer threw me this question when I was just leaving from work. (I copied her email to the list) Now I am at home and taking a chance to look it over again. I am not sure what she asked for. My guess is she wants to pass a variable based on @xxx to access

RE: ROWID question?

Title: ROWID question? Thanks for everyones input! -Original Message-From: Denham Eva [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 22, 2002 4:49 PMTo: Multiple recipients of list ORACLE-LSubject: ROWID question? Hello Gurus Does Oracle reuse ROWID "numbers", once

RE: Elementary question about triggers

You could use VPD (virtual private database, AKA fine-grained access control AKA row-level security) to control exactly which rows a given user can delete based on a function using the business rule which determines which rows they are authorized to delete. This works from 8i onward, but there

Re: ROWID question?

Title: ROWID question? If you have timestamp-type column (let's call it "date_column") and what to keep the record with the newest date, then you should use this column in your DELETE statement (instead of ROWID): DELETE FROM tablename a WHERE date_column (SELECT MAX(b.date_column)

Re: ROWID question?

Hi, Space is reused therefore ROWID are reused. You can certainly modify your delete duplicate routine for special cases to include record must have max date. Rick

RE: ROWID question?

Title: ROWID question? The script you are using will achieve your goal. It's a pretty common one to remove dups. ROWIDs will be reused once Oracle reinserts a row into the 'hole'. However, for the duration of the transaction, this will not be the case. Since the transaction could be

Re: ROWID question?

Denham, At the risk of going slightly off-topic. If the number of rows you are expecting to keep is relatively small, it might be much quicker to create a temporary table with the rows you wish to keep, truncate the main table and re-insert the rows back in. Of course this approach presents

RE: ROWID question?

Title: RE: ROWID question? Yes, Oracle can re-use a rowid. -Original Message- From: Mark Richard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 22, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: ROWID question? Denham, At the risk of going slightly off

RE: Sql question : use of SUBSTR/INSTR functions

Try this. It uses the INSTR function to determine the start and end of the SUBSTR. 1 select substr('333.22.1.000',1,instr('333.22.1.000','.')-1) octet1, 2 substr('333.22.1.000', 3(instr('333.22.1.000','.',1,1) + 1), 4(instr('333.22.1.000','.',1,2)

Re: Sql question : use of SUBSTR/INSTR functions

Hi Johan, Try this: SELECT SUBSTR('127.0.0.1',1,INSTR('127.0.0.1','.')-1) ,SUBSTR('127.0.0.1',INSTR('127.0.0.1','.')+1,INSTR('127.0.0.1','.',1,2)-(INSTR('127.0.0.1','.')+1)) ,SUBSTR('127.0.0.1',INSTR('127.0.0.1','.',1,2)+1,INSTR('127.0.0.1','.',1,3)-(INSTR('127.0.0.1','.',1,2)+1))

RE: Sql question : use of SUBSTR/INSTR functions

Hello, Try this (take a hard look first, as I cranked this out quickly while doing other things): substr(ip_addr,1,instr(ip_addr,'.',1,1)-1 get 1st octet substr(ip_addr,1,instr(ip_addr,'.',instr(ip_addr,'.',1,1)+1,1)-1 get 2nd octet

RE: Sql question : use of SUBSTR/INSTR functions

Anybody have a quick and dirty to parse the 4 octets of a typical IP address How about this... FUNCTION f_ip_to_number ( p_ipNVARCHAR2 ) RETURN NUMBER IS v_ip_segment1 NUMBER := SUBSTR (p_ip, 1, INSTR

RE: Elementary question about triggers

It is meant to be a 'selective' deletion i.e. some rows should be allowed to delete where as others shouldn't be. Thanks for your replies. Regards, Charu. -Original Message- Sent: Monday, October 14, 2002 8:30 PM To: Multiple recipients of list ORACLE-L Why not just remove delete

RE: Elementary question about triggers

Title: RE: Elementary question about triggers Basics: 1. Delete trigger doesn't delete the row, the DELETE command does it. 2. DELETE command invokes the delete trigger (if the trigger conditions are met). Solution: 1. Revoke delete priv so no deleted can take place. 2. Create a before

Re: Elementary question about triggers

Here's one way: drop table d; create table d( x integer ); create or replace trigger d_nodelete_trg before delete on d begin raise_application_error(-2,'No Deletes Allowed!'); end; / show error trigger d_nodelete_trg Jared Charu Joshi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]

RE: Elementary question about triggers

CREATE OR REPLACE TRIGGER temp_trig BEFORE DELETE ON temp_tab FOR EACH ROW BEGIN RAISE_APPLICATION_ERROR(-2,'Do not delete ...'); END; / Bala. -Original Message- Sent: Monday, October 14, 2002 1:14 PM To: Multiple recipients of list ORACLE-L Dear Listers, I hope you won't

RE: Elementary question about triggers

Why not just remove delete authority from anyone not authorized to delete from it ?? -Original Message- Sent: Monday, October 14, 2002 2:34 PM To: Multiple recipients of list ORACLE-L CREATE OR REPLACE TRIGGER temp_trig BEFORE DELETE ON temp_tab FOR EACH ROW BEGIN

Re: interview question ???

Is this for a job interview? I for one, am not going to help proliferate the number of DBA's that don't know what they're doing, when there are many available that do. If I'm way out of line here, then let me know, but this sure looks like a good opportunity to recommend some RTFM. Jared

RE: interview question ???

Leslie Instead of just providing the answers, I'll show you how to find them. Go to http://www.google.com, and search for Oracle block corruption and Oracle wait interface. You'll find several articles that will teach you more about these subjects. For the last question, click on

RE: interview question ???

Here, Here! Bravo! AMEN, Brother... I'm with you on this. -Original Message- Sent: Monday, October 14, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Is this for a job interview? I for one, am not going to help proliferate the number of DBA's that don't know what they're

RE: interview question ???

Seems in line to me... There is a big difference between Help me with this problem at my current job and Help get this job that I'm not qualified for... Tim -Original Message- Sent: Monday, October 14, 2002 6:29 PM To: Multiple recipients of list ORACLE-L Is this for a job

RE: interview question ???

reminds me of my most favorite BAD review of DBA 101: I consider myself as an Oracle DBA beginner and want to lie on my resume. Though I have completed the whole book I still feel confused about the Oracle architecture and basic Oracle DBA commands. This book is not a good reference book for a

RE: interview question ???

I like Tom Kyte's suggestion: Here's a pencil and paper. Diagram out Oracle for me. Show me the various sets of files, and the different processes that make up the instance. Breifly explain what type of information is in each file or set of files, and the purpose of the various background

RE: interview question ???

Agent's email address, please... :) Thank you ! :) ;) - Kirti -Original Message- Sent: Monday, October 14, 2002 4:44 PM To: Multiple recipients of list ORACLE-L Hi, My agent asked me these couple of questions through email, can any one give me some idea? Thank you! Leslie

RE: TSPITR Question

Welcome back Babette! Jared Babette Turner-Underwood [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/01/2002 07:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: TSPITR Question Also only

RE: Index question

Thanks you all for your response Ofer -Original Message- Sent: Thursday, September 19, 2002 3:23 PM To: Multiple recipients of list ORACLE-L Testing against 8.1.7.4, the drop index was successful and an error was reported by my long running query: ERROR: ORA-08103: object no

RE: TSPITR Question

Also only available on Enterprise Edition. - Babette -Original Message- WILLIAMS Sent: Monday, September 30, 2002 10:03 PM To: Multiple recipients of list ORACLE-L Brian - Since nobody seems to have responded to your question, yes, there are plenty of opportunities for gotchas with

Re: RMAN Question

No, you can't do that. I just run a OS job everyday which removes the old backups to make room. HTH, Ruthg - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 30, 2002 5:28 AM Hi ALL Is there any way with RMAN to overwrite the

RE: TSPITR Question

Brian - Since nobody seems to have responded to your question, yes, there are plenty of opportunities for gotchas with TSPITR. To recover deleted data, you may want to take a look at LogMiner. Less risk. Normally, to recover deleted data, you will be performing the TSPITR on a test (or recovery)

RE: SQL question

It is a little awkward, but a union in an inline query may do the trick: 1 select a.code 2 from (select '10' code from dual union 3select '20' code from dual union 4select '30' code from dual union 5select '40' code from dual union 6select '50' code

RE: SQL question

1700 values? I sure hope you like to type... Could you create a text file of the table values and compare those against a text files of the possible values? This would require O/S level privs. -Original Message- Sent: Monday, September 23, 2002 11:38 AM To: Multiple recipients of list

RE: SQL question

If the set of values is not too big and fixed you could do the minus using dual e.g. (select 'A' from dual union select 'B' from dual union ... select 'Z' from dual) minus select code from table -Original Message- Sent: Monday, September 23, 2002 5:28 PM To: Multiple

RE: SQL question

Dan (and Charlie), Thanks. Good suggestions, but the IN clause contains just over 1700 values. Puzzling, huh? steve --- Fink, Dan [EMAIL PROTECTED] wrote: It is a little awkward, but a union in an inline query may do the trick: 1 select a.code 2 from (select '10' code from dual

RE: SQL question

files of the possible values? This would require O/S level privs. -Original Message- From: Steven Haas [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 11:38 AM To: Multiple recipients of list ORACLE-L Subject: RE: SQL question Dan (and Charlie), Thanks. Good

RE: SQL question

Title: RE: SQL question select * from(select 'a' from dual union select 'b' from dual union select 'c' from dual ...) minus select distinct code from table / HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot

Re: SQL question

Jonathan Gennick has an excellent article in Oracle magazine (sept./oct.), which should help. He demonstrates two approaches: with and without pivot table. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

RE: SQL question

Title: RE: SQL question Steve, select 'select a.code ' || chr(10) || ' from(' || from dual union select distinct 'select ' || || code || || ' code from dual ' || chr(10) || 'union' || from my_code_table union select ')' || chr(10) || 'minus' from dual / select 'select distinct

RE: SQL question

: Any clod can have facts, but having an opinion is an art! -Original Message- From: Steven Haas [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Subject: RE: SQL question Dan (and Charlie), Thanks. Good suggestions

Re: SQL question

Sorry, forgot to provide a link: http://otn.oracle.com/oramag/oracle/02-sep/o52sql.html Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 23, 2002 2:33 PM Jonathan Gennick has an excellent

RE: SQL question

what are the 1700 values if the are all alphabetic and not too long you could do something like the below though it's all getting a bit long-winded select chr(65+(floor((rownum-1)/676)))||chr(65+(floor((mod(rownum-1,676))/26)))||ch r(65+(mod(rownum-1,26))) from addresses -- any table big

RE: SQL question

Title: RE: SQL question Maybe I think differently, I usually let server think about size or the number of clauses ... if you have codes in a table what's wrong with ... select distinct code from my_code_table minus select distinct code from my_data_table / ??? Raj

RE: sqlplus question

Title: RE: sqlplus question SQLPlus outputs data in columns based on their Maximum length or the COLUMN format set in SQLPlus. Value of SQLPlus COLUMN attribute takes precedence. Even when you do a substr() based on length, SQLPlusdoesn't calculate the length of the maximum length value

RE: Index question

Ofer, Testing against 8.1.7.4, the drop index was successful and an error was reported by my long running query: ERROR: ORA-08103: object no longer exists Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On

Re: Index question

I think it's not possible. Query will lock an index in some way, so you cannot drop it until query releases it because DDL will not be able to accure exclusive lock on the index. I'm not sure when query releases index lock. I would say at the end of a query but may be wrong. Alexandre -

RE: Index question

The Query will be re-parsed. As soon as u do a DDL, the dependent queries in Shared SQL area are invalidated. Regards Naveen -Original Message- Sent: Thursday, September 19, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Good morning, Suppose there is a long running query

RE: Index question

Sorry for the mis-interpretation. I thought the question was if the same SQL statement is re-executed after dropping the index. regards naveen -Original Message- Sent: Thursday, September 19, 2002 5:28 PM To: Multiple recipients of list ORACLE-L The Query will be re-parsed. As soon as

Re: Index question

Testing against 8.1.7.4, the drop index was successful and an error was reported by my long running query: ERROR: ORA-08103: object no longer exists Is this because the index is locked by query only when it's used? From one side looks reasonable, but from another - no good someone can drop

RE: sqlplus question

The only method I know of is to concatenate the fields together in one column. If there is a way to have variable sized SQL*Plus column formatting, I'd love to see it...seriously...it would be cool. Until then... 1 select substr(ename,1,length(rtrim(ename))), job 2* from emp SQL / SMITH

RE: sqlplus question

If you want only 4 bytes, us the SUBSTR function to take only what you need. SQL select ename, job 2 from emp; SMITH CLERK ALLEN SALESMAN WARD SALESMAN JONES MANAGER SQL set colsep '|' SQL / SMITH |CLERK ALLEN |SALESMAN WARD |SALESMAN JONES |MANAGER SQL

RE: sqlplus question

Subject:RE: sqlplus question If you want only 4 bytes, us the SUBSTR function to take only what you need. SQL select ename, job 2 from emp; SMITH CLERK ALLEN SALESMAN WARD SALESMAN JONES MANAGER SQL set colsep '|' SQL / SMITH |CLERK ALLEN |SALESMAN WARD

RE: sqlplus question

Bill couldn't you just concatenate the fields together with your delimiter between. e.g. select fld1||'|'||fld2||'|'||fld3 I think the trimspool is just trailing blanks so unless you made that the last field output you'll get this behaviour. Iain Nicoll -Original Message- Sent:

RE: sqlplus question

I am spooling my sqlplus output to a file with no headings and all the fields separated by a delimiter. I have a field that is defined as varchar2(56), but typically only 4 or 5 bytes are filled. Oracle recognizes that and if you select length(fld1) from the table, you will get 4.

RE: sqlplus question

I am spooling my sqlplus output to a file with no headings and all the fields separated by a delimiter. I have a field that is defined as varchar2(56), but typically only 4 or 5 bytes are filled. Oracle recognizes that and if you select length(fld1) from the table, you will get 4.

RE: sqlplus question

select substr(ename,1,length(ename)), job from emp; From: Bob Metelsky [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: sqlplus question Date: Thu, 19 Sep 2002 08:18:51 -0800 I am spooling my sqlplus output to a file

RE: sqlplus question

. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 19, 2002 9:51 AM To: '[EMAIL PROTECTED]'; Carle, William T (Bill), ALCAS Subject:RE: sqlplus question If you want only 4 bytes, us the SUBSTR function to take

RE: sqlplus question

set Trimspool on will only trim the empty spaces at the end of each line. The only way i know to trim in between the lines is to concatenate all the columns SELECT column_1 || '|' || column_2. FROM . Naveen -Original Message- Sent: Thursday, September 19, 2002 9:49 PM To:

Re: sqlplus question

-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: sqlplus question Date: Thu, 19 Sep 2002 08:18:51 -0800 I am spooling my sqlplus output to a file with no headings and all the fields separated by a delimiter. I have a field

RE: sqlplus question

Title: RE: sqlplus question Use rtrim and ltrim are you sure data was loaded with spaces? -Original Message- From: Yechiel Adar [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Subject: Re: sqlplus question Tried

RE: recovery question - I know I am missing something

What I do and have just done a couple of days ago is copy your latest redo log into the suggested name below '/u07/oracle/testdb/8.1.7/dbs/arch1_1.dbf' and do your recover again. Worked fine for me HTH Lee -Original Message- Sent: 12 September 2002 19:38 To: Multiple recipients of

RE: recovery question - I know I am missing something

I think you need the online redo log file that was current when you did shutdown abort. This is provided it was not recycled! Waleed -Original Message- Sent: Thursday, September 12, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Database 8.1.7 Cloning a database that was

RE: recovery question - I know I am missing something

Let me clarify a bit. I cloned the database from coldbackup . I opened the database fine, but I goofed up the name. I shutdown the database, it hung so I did a shutdown abort and forgot to open it up normally before I tried to rename the database. I don't have any archive files created by

RE: recovery question - I know I am missing something

select * from v$logfile. Specify the current logfile. From: Kathy Duret [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: recovery question - I know I am missing something Date: Thu, 12 Sep 2002 11:08:33 -0800 Let me clarify

RE: recovery question - I know I am missing something

Kathy, Let me clarify a bit. I cloned the database from coldbackup . I opened the database fine, but I goofed up the name. I shutdown the database, it hung so I did a shutdown abort and forgot to open it up normally before I tried to rename the database. I don't have any archive

RE: recovery question - I know I am missing something

I ended up giving it one of the log files but they all said stale so it took me a couple of tries. Thanks! Kathy -Original Message- Sent: Thursday, September 12, 2002 11:38 AM To: Multiple recipients of list ORACLE-L Database 8.1.7 Cloning a database that was brought down using

RE: Replication question

Paul - I don't know multimaster replication, so bear with me. I am thumbing through my copy of Oracle Distributed Systems by Charles Dye. Does your question relate to how propagation is controlled? I think propagation is controlled by scheduled jobs. Take a look at the procedure

RE: Export question on excluding certain schema

Thanks Kirti ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is

RE: Export question on excluding certain schema

Raj, The answer is: Yes. You will need to edit catexp.sql to rebuild internal view to exclude interested owner#. This is as simple as it gets! - Kirti -Original Message- Sent: Thursday, September 05, 2002 8:43 AM To: Multiple recipients of list ORACLE-L Is it possible to exclude

RE: Replication question

Paul, The procedures are executed by a special internal trigger. These triggers are also NOT dropped by catrepr.sql (yes, I found out the hard way!). It is documented in metalink. HtH, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Wednesday,

RE: Replication question

Title: RE: Replication question Great book, I have it too! -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Paul - I don't know multimaster

<    1   2   3   4   5   6   7   8   9   10   >