RE: Function-Based Index not working
Re: Default Location of RMAN backup sets
Yes, those look like the backupset files. I don't know what the default filename format is, but the filename format and location are configurable via the format option. You should check out the sample Rman stored scripts in $ORACLE_HOME/rdbms/demo/*.rcv. For example I use this for my datafile backups: format '/backups/rman/df_d%d_t%t_s%s_p%p', where d=database name, t=timestamp, s=set#, p=piece#. -- Philip - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, August 31, 2002 1:13 AM What's the file name format of the RMAN backup set? I see files in there that I suspect are my backup sets but they have wierd file names. Such as: 01e1el7h_1_1 with no file name extensions. ltiu On Friday 30 August 2002 19:53, Philip Douglass wrote: Hmmm... IIRC they should be in $ORACLE_HOME/dbs - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 30, 2002 10:28 PM Hello, I took an RMAN backup of a database (for testing purpose only, thank goodness). The question is, where did RMAN put the backup set files? I read through an RMAN book and the official Oracle RMAN User Guide and neither mentions the location of the RMAN backup ?!! Thanks for any input. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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: Philip Douglass 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
Re: Default Location of RMAN backup sets
Check documentation for the composition of the %U filename format; I believe that it is the default... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, September 01, 2002 10:13 AM Yes, those look like the backupset files. I don't know what the default filename format is, but the filename format and location are configurable via the format option. You should check out the sample Rman stored scripts in $ORACLE_HOME/rdbms/demo/*.rcv. For example I use this for my datafile backups: format '/backups/rman/df_d%d_t%t_s%s_p%p', where d=database name, t=timestamp, s=set#, p=piece#. -- Philip - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, August 31, 2002 1:13 AM What's the file name format of the RMAN backup set? I see files in there that I suspect are my backup sets but they have wierd file names. Such as: 01e1el7h_1_1 with no file name extensions. ltiu On Friday 30 August 2002 19:53, Philip Douglass wrote: Hmmm... IIRC they should be in $ORACLE_HOME/dbs - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 30, 2002 10:28 PM Hello, I took an RMAN backup of a database (for testing purpose only, thank goodness). The question is, where did RMAN put the backup set files? I read through an RMAN book and the official Oracle RMAN User Guide and neither mentions the location of the RMAN backup ?!! Thanks for any input. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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: Philip Douglass 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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: Tim Gorman 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
convert long raw to varchar2
Dear List, This is what I'm trying to do in a stored procedure. 1) Read a long raw column from a table into a varchar2 variable. (Let's assume that each value contains a not-too-long text value.) 2) Parse it to create a bunch of insert statements and execute them. Step 2 is something I understand how to do. But, I've no clue how to do step 1. I've spent a few hours trying to figure out the tools I need for this. All my research turns up information on how to convert long raw to blob/clob etc. and the advantages of blob/clob over long raw and so on. My impression is that dealing with long raw is considered so basic that people don't even mention it :-) I'd appreciate any pointers. Thanks for your time, - Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sun449 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
Re: convert long raw to varchar2
You convert LONG to CLOB and then read it into your character variable using DBMS_LOB.READ. Alternatively, you can use Java and/or EXTPROC. On 2002.09.01 15:48 sun449 wrote: Dear List, This is what I'm trying to do in a stored procedure. 1) Read a long raw column from a table into a varchar2 variable. (Let's assume that each value contains a not-too-long text value.) 2) Parse it to create a bunch of insert statements and execute them. Step 2 is something I understand how to do. But, I've no clue how to do step 1. I've spent a few hours trying to figure out the tools I need for this. All my research turns up information on how to convert long raw to blob/clob etc. and the advantages of blob/clob over long raw and so on. My impression is that dealing with long raw is considered so basic that people don't even mention it :-) I'd appreciate any pointers. Thanks for your time, - Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sun449 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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). -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
RE: Index hints?
Thanks all the responses. It's the syntax error like Naveen said. Oracle didn't detect the error, it just simply ignore the hints if the syntax is wrong. Thanks again, Chuan -Original Message- Sent: Friday, 30 August 2002 5:33 PM To: Multiple recipients of list ORACLE-L If you specify a hint Oracle is forced to use the index. Your hint's syntax is wrong. USE - /*+ INDEX(test index_a) */ Don't use the comma *** between the table name and the index name Naveen -Original Message- Sent: Friday, August 30, 2002 12:33 PM To: Multiple recipients of list ORACLE-L Hi, All, On a million row table, test, there is primary key on column a. when I run select /*+ index (test,indx_a) */ a, b, c, from test, according to Oracle, I should get the following explain plan. TABLE ACCESS BY INDEX ROWID test 1 INDEX UNIQUE SCAN PK_test 1 But I acctucally got : TABLE ACCESS FULL test 1 The database optimizer mode is choose, and I gathered the statistics on table and index using dbms_utitlity and analyze. In the session level, I also set optimizer_mode=first_rows to push optimizer to choose the index. According to Oracle Doc use hints to force the optimizer to use the optimal execution plan., to my understanding, the explain plan under such a situation, should be the first one. Does Oracle follow the hint? or to waht extents, it follows? Appreciated if someone guides me to the right direction. Chuan, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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). Unless otherwise stated, this e-mail does not represent the views of TransACT Communications Pty Limited. This text and any attachments of this e-mail are confidential and may be legally privileged. This email is for the use of the intended recipient only. If you are not the intended recipient do not take any action in relation to this email, other than to notify TransACT Communications by replying to this e-mail and destroying the original communication. Except as required by law, TransACT Communications does not represent that this transmission is free of errors, viruses or interference.
RE: convert long raw to varchar2
Am I missing something? this works for me: create table testlong (c1 number,c2 long raw); insert into testlong values (10,'0123456789abcdef'); declare m_c1 number; m_c2 varchar2(2000); begin select * into m_c1,m_c2 from testlong; dbms_output.put_line(m_c2); end; -Original Message- Sent: Sunday, September 01, 2002 3:48 PM To: Multiple recipients of list ORACLE-L Dear List, This is what I'm trying to do in a stored procedure. 1) Read a long raw column from a table into a varchar2 variable. (Let's assume that each value contains a not-too-long text value.) 2) Parse it to create a bunch of insert statements and execute them. Step 2 is something I understand how to do. But, I've no clue how to do step 1. I've spent a few hours trying to figure out the tools I need for this. All my research turns up information on how to convert long raw to blob/clob etc. and the advantages of blob/clob over long raw and so on. My impression is that dealing with long raw is considered so basic that people don't even mention it :-) I'd appreciate any pointers. Thanks for your time, - Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sun449 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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: Khedr, Waleed 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
Re: Default Location of RMAN backup sets
OK guys. I found it. Starting up RMAN with recovery catalog. the list backup command will list the backups and the locations and the file names. ltiu On Friday 30 August 2002 22:13, ltiu wrote: What's the file name format of the RMAN backup set? I see files in there that I suspect are my backup sets but they have wierd file names. Such as: 01e1el7h_1_1 with no file name extensions. ltiu On Friday 30 August 2002 19:53, Philip Douglass wrote: Hmmm... IIRC they should be in $ORACLE_HOME/dbs - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 30, 2002 10:28 PM Hello, I took an RMAN backup of a database (for testing purpose only, thank goodness). The question is, where did RMAN put the backup set files? I read through an RMAN book and the official Oracle RMAN User Guide and neither mentions the location of the RMAN backup ?!! Thanks for any input. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
RE: Index hints?
There is nothing wrong in having a comma in a hint: SQL create table test_hint ( c1 number not null , c2 number); Table created. SQL SQL create index testix1 on test_hint (c1); Index created. SQL SQL set autotrace on explain; SQL SQL select * from test_hint a; no rows selected Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE 10 TABLE ACCESS (FULL) OF 'TEST_HINT' SQL SQL select /*+ index(a,testix1) */ * from test_hint a; no rows selected Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=826 Card=164 Bytes=4 264) 10 TABLE ACCESS (BY INDEX ROWID) OF 'TEST_HINT' (Cost=826 Car d=164 Bytes=4264) 21 INDEX (FULL SCAN) OF 'TESTIX1' (NON-UNIQUE) (Cost=26 Car d=164) Regards, Waleed -Original Message- Sent: Sunday, September 01, 2002 9:28 PM To: Multiple recipients of list ORACLE-L Thanks all the responses. It's the syntax error like Naveen said. Oracle didn't detect the error, it just simply ignore the hints if the syntax is wrong. Thanks again, Chuan -Original Message- Sent: Friday, 30 August 2002 5:33 PM To: Multiple recipients of list ORACLE-L If you specify a hint Oracle is forced to use the index. Your hint's syntax is wrong. USE - /*+ INDEX(test index_a) */ Don't use the comma *** between the table name and the index name Naveen -Original Message- Sent: Friday, August 30, 2002 12:33 PM To: Multiple recipients of list ORACLE-L Hi, All, On a million row table, test, there is primary key on column a. when I run select /*+ index (test,indx_a) */ a, b, c, from test, according to Oracle, I should get the following explain plan. TABLE ACCESS BY INDEX ROWID test 1 INDEX UNIQUE SCAN PK_test 1 But I acctucally got : TABLE ACCESS FULL test 1 The database optimizer mode is choose, and I gathered the statistics on table and index using dbms_utitlity and analyze. In the session level, I also set optimizer_mode=first_rows to push optimizer to choose the index. According to Oracle Doc use hints to force the optimizer to use the optimal execution plan., to my understanding, the explain plan under such a situation, should be the first one. Does Oracle follow the hint? or to waht extents, it follows? Appreciated if someone guides me to the right direction. Chuan, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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: Khedr, Waleed 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
Re: working with datafile 2Gb in HadHat 7.3
This is a multi-part message in MIME format. --=002_Dragon033825381083_= Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: quoted-printable Adriano Freire=A3=AC=C4=FA=BA=C3=A3=A1 =A1=A1=A1=A1This is the limit of oracle8i in linux.Redhat support 2GB= file in kernel 2.4+, but oracle8i does not support it. Oracle 9i in linux can handle large files.I have a database= using one big 20G raw partition in production. =3D=3D=3D=3D=3D=3D=3D=3D 2002-08-29 06:53:00 =C4=FA=D4=DA=C0=B4=D0=C5=D6=D0=D0=B4=B5=C0=A3=BA =3D=3D=3D=3D=3D=3D=3D=3D Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using= datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2 =C0=F1=A3=A1 =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1zhu chao [EMAIL PROTECTED] =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-09-02 --=002_Dragon033825381083_= Content-Type: text/html; charset=GB2312 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META content=3Dtext/html; charset=3Dgb2312= http-equiv=3DContent-Type META content=3DMSHTML 5.00.3315.2870 name=3DGENERATOR/HEAD BODY bgColor=3D#eaeaeaFONT size=3D2FONT face=3D=CB=CE=CC=E5Adriano= Freire=A3=AC=C4=FA=BA=C3=A3=A1/FONT /FONT DIVnbsp;/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2=A1=A1=A1=A1This is the limit of oracle8i in= linux.Redhat support gt;2GB file in kernel 2.4+, but oracle8i does not= support it./FONT/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2nbsp;nbsp;nbsp; Oracle 9i in linux= can handle large files.I have a database using one big 20G raw partition in production./FONT/DIV DIVnbsp;/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2=3D=3D=3D=3D=3D=3D=3D=3D= 2002-08-29nbsp;06:53:00nbsp;=C4=FA=D4=DA=C0=B4=D0=C5=D6=D0=D0=B4=B5=C0=A3=BA =3D=3D=3D=3D=3D=3D=3D=3D/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2 TABLE width=3D100% TBODY TR TD width=3D100% BLOCKQUOTE style=3DBORDER-LEFT: #00 2px solid; MARGIN-LEFT: 5px;= MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px DIVFONT face=3DArial size=3D2Gurus,/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2I've some problems with= datafiles gt; 2Gb in HadHat 7.3. I'm using datafile type ext3 and= /FONT/DIV DIVFONT face=3DArial size=3D2when i try create a datafile= with 2Gb the database is catching./FONT/DIV DIVFONT face=3DArial size=3D2Anybody have the some= problem?/FONT/DIV DIVFONT face=3DArial size=3D2any= suggestion?/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Thanks/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial = size=3D2Adriano./FONT/DIV/BLOCKQUOTE/TD/TR/TBODY/TAB= LE/FONT/DIV DIV PFONT face=3D=CB=CE=CC=E5 size=3D2=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D= =3D =3D /FONT/P PFONT face=3D=CB=CE=CC=E5 size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2BR=C0=F1=A3=A1/FONT/P DIVnbsp;/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1zhu= chao/FONT/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2FONT face=3D=CB=CE=CC=E5= size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1/FONTA href=3Dmailto:[EMAIL PROTECTED];[EMAIL PROTECTED]/A/FONT/DIV DIVFONT face=3D=CB=CE=CC=E5= size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-09-02/FONT/DIV= DIVnbsp;/DIV/DIV/BODY/HTML --=002_Dragon033825381083_=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zhu chao 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
ArcServe 2000 Agent for Oracle
Hi, We are planning to use ArcServe 2000 Agent for Oracle to take Hot Backup of our one of the databases. I was wondering whether anybody encountered any issue? Thanks for youe feebback in advance. Jahan Environment: ArcServe 2000 Agent for Oracle Windows 2000 SP2 Oracle 8.1.7.2.1 Standard Edition Attention: = This e-mail message and accompanying data may contain information that is confidential and subject to legal privilege. If you are not the intended recipient, you are notified that any use, dissemination, or copying of any part of this e-mail message and accompanying data, is prohibited. If you have received this e-mail message in error, please notify us immediately and delete this e-mail message from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jahan Shanai 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
doubt in INDEX
1.) People are saying that if a table is indexed then the all the rowids will be changed , whether it is trueIf so , then how it is done , give example please. 2.)What are all the ways for the rowids to be changed Explain. Regards, Prakash. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: guess who 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
RE: doubt in INDEX
Prakash, Though i don't remember fully, but the ROWID consists of the Block Address, DataFile and other info. Rowid's change when the row is migrated to a different location. Since creating index doesn't migrate the row, if the table is indexed the rowid's wont change. Naveen -Original Message- Sent: Monday, September 02, 2002 9:43 AM To: Multiple recipients of list ORACLE-L 1.) People are saying that if a table is indexed then the all the rowids will be changed , whether it is trueIf so , then how it is done , give example please. 2.)What are all the ways for the rowids to be changed Explain. Regards, Prakash. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: guess who 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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: Naveen Nahata 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
Re: doubt in INDEX
Creat index will not change rowids. Rowids are not easily changeable. Here are the evil ways of changing rowids: a) alter table move .. b) Update moves the row from one partition to another. c) Update of the cluster key moves the row from one cluster block to another. d) Update of the primary key in an IOT (there are complications with IOT, so people should generally use urowid. If you are enableing constraints, you should generally use $ORACLE_HOME/rdbms/admin/utlexpt1.sql to create the exceptions table, so tthat EXCEPTIONS table is created with urowid) e) export/truncate/import Creating index does not change rowid. On 2002.09.02 00:13 guess who wrote: 1.) People are saying that if a table is indexed then the all the rowids will be changed , whether it is trueIf so , then how it is done , give example please. 2.)What are all the ways for the rowids to be changed Explain. Regards, Prakash. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: guess who 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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). -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
Unique value
Hi friends,
I have a tables A and B
DESC A
ID
NUMBER
NAME
VARHAR2(10)
DESC B
---
ID
NUMBER
SUBNAME
VARCHAR2(20);
In the above table B.ID is the foreign key to
A.ID.
How can I create unique value for B.SUBNAME based
on A.NAME.
Means , A.NAME has value
'"
andB.SUBNAME
has values '', '';
when I insert value again in B.SUBNAME as '' it should not agree for the
combination value of A.NAME(''),
but '' can agree when I enter value for A.NAME other than
''
Please give some ideas,
Thanks in advance
syed.
Great Oracle Developer/Admin Tool
Hey guys, This one is good!! Runs on Linux and Windows and maybe Solaris too. http://www.globecom.se/tora/overview.htm http://www.globecom.se/tora http://sourceforge.net/project/showfiles.php?group_id=16636 ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
Re: doubt in INDEX
Dear Guess Who, I don't think so. BTW, who are the people and why do they think so, we would love to see their explanation/theory. There could be several possibilities for having the rowids changed, like Exporting and Importing the tables, Moving the tables to diff T.S etc. Other ideas are welcome ... HTH, Rajesh - Original Message - Date: Sun, 01 Sep 2002 20:13:21 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 1.) People are saying that if a table is indexed then the all the rowids will be changed , whether it is trueIf so , then how it is done , give example please. 2.)What are all the ways for the rowids to be changed Explain. Regards, Prakash. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: guess who 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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). -- __ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
