RE: DB_FILE_NAME_CONVERT issue

Hi guys, Anyone that work in ASIA time please help me : ) Sinardy -Original Message- Sent: 08 July 2002 12:58 To: Multiple recipients of list ORACLE-L Hi guys, I try to create standby database and my datafile are all over my hard disk, what should I do to my DB_FILE_NAME_CONVERT to

RE: DB_FILE_NAME_CONVERT issue

Hi, I don't know the syntax you are looking for but you could explicitly rename every file in your RMAN script (set newname for datafile command) Jack

RE: Hints being ignored

I'm on 8.1.6 and the other day I was trying to use a hint on the GL_INTERFACE table from Oracle Financials (i know OF is rule based)that I had copied to another database instance and I couldnt get a hint to work. And i know that Hint is not SQL supported and therefore the syntax has to be 100%

RE: DB_FILE_NAME_CONVERT issue

Hi, I am not using RMAN, This is what I try to do. I try to create standby database manually 1. Copy all datafiles to new location (so call standby location) 2. create initstandby.ora (almost the same with the production) 2.a. DB_FILE_NAME_CONVERT = (production path, standby path) is one of

Comparison between Oracle 8 and Oracle 9

Hi everybody, Currently we are using Oracle 8.1.7 in our company and for a new datawarehouse project, a consultant company has suggested us to use Oracle 9. The have claimed that applications run much faster and it's more reliable etc... Of course I was not convinced. Could you please tell me,

AW: JDBC

Hi Antje Eventhough I never migrated Sybase (or SQL Server) code (JDBC/Java) to Oracle, maybe that helps anyway: In Transact SQL, you can actually return data from an anonymous block, that's correct. An equivalent to do this in PL/SQL might be the use of OUT parameters within stored

Oracle 9.2 and Solaris 9

Dear DBAs, anybody out there have experience/knowledge about the compatibility between Oracle 9.2 and Solaris 9 ? On the Metalink site the server certification matrix say projected and I'm confident that this will turn into Certified quite soon, but the direct experience it's a different

Dynamically preventing use of index

Title: Dynamically preventing use of index Hi, I have a table with two column, each having non-unique index. The following select is used to fetch records. The variables ‘var1’ and ‘var2’ are provided for execution. Only one of the two variables is provided. The requirement is to use the

RE: DB_FILE_NAME_CONVERT issue

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

How to administer OAS at server without using Browser ?

Hi DBAs, I would like to know the ways we can manage OAS ( ver. 4.0.8 ) without using Browser. For example, how do we create DADs without using browser admin utility. Is there any Oracle utility available to use at OS prompt? Possible ? Thanks, Arul. -- Please see the official ORACLE-L FAQ:

copy command

Notice taht there are limits to the copy command COPY The COPY command is not being enhanced to handle datatypes or features introduced with, or after Oracle8. The COPY command is likely to be made obsolete in a future release. Regards, Antje Sackwitz -- Please see the official ORACLE-L FAQ:

Re: Exporting stats for a production server to a dev/test server

Jack, Were your old statistics generated with the ANALYZE command? If yes, were you able to export ALL of the old statistics with the export option of DBMS_STATS before you actually analyzed with DBMS_STATS for the first time? If yes, after exporting them, did you delete the old statistics

converting fmt to fmb

Title: converting fmt to fmb Hi, may be a bit off topic. How can I convert my forms 6i FMT files to FMB files, from command line. In forms 4.5 this was feasible by using the following command, but I am unable to locate the command line option for Forms 6i. f45gen32 module=sync

RE: 2003 IOUG Meeting

Everyone: This is great!! Please pass the word on about IOUG-Live! Any help with marketing this extremely valuable event is greatly appreciated. Besides the one on one events, you can experience what others have called DBA Frenzy. Lots of people with varied opinions but lots of expertise.

Re: C++ classes

Waleed In version 9i there is very neat C++ classes for OCI to be able to access Oracle. Have a look at Oracle C++ Call Interface Programmer's Guide ( http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/appdev.901/a89860/toc.htm ). If you Khedr, Waleed wrote: Check this:

RE: converting fmt to fmb

Title: converting fmt to fmb Same way, just the executable name has changed. 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.

Re: Copy

Yechiel, No, it is available at 8.1.7 also, it worked through a dblink. I thought it will do it thru the local tnsnames. tks Ramon - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Sunday, July 07, 2002 7:33 AM Subject:

Re: Exporting stats for a production server to a dev/test server

Cherie, Great name. Our initial stats were generated with the ANALYZE command. We did export all the stats with the dbms_stats - one parameter of the GATHER_TABLE_STATS procedure is CASCADE, which picks up the index and column stats too. Please test first on your own system to make sure this is

Re: Copy

Rachel, Joe, Anjo and for all that reply, The only way it worked for me was using a dblink. As always tks for your comentaries !!! Tks Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, July 07, 2002 8:23 AM copy has been around

Re: insert nologging parallel/noparallel and archiving - thanks

Just wanted to thank Jack, Connor and Jared for their help!! Gene --- Jack Silvey [EMAIL PROTECTED] wrote: sorry, meant insert as select, not insert as append --- Jack Silvey [EMAIL PROTECTED] wrote: Gene, This sounds right. __ Do You

RE: converting fmt to fmb

Title: converting fmt to fmb Hi Amar, use the following to convert ur files ifcmp60 along with the various parameters that u want to pass regards, Ams. www.medicomsoft.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Amar Kumar

RE: Copy

Also, as the example points out, make sure you use the hyphen at the end of line if your command spans more than 1 line. -Original Message- Sent: Sunday, July 07, 2002 9:23 AM To: Multiple recipients of list ORACLE-L copy has been around for a lng time from the 8.1.7 docs COPY

Re:How to learn XML ?

TRY: http://www.w3schools.com/xml/ Dick Goulet Reply Separator Author: Eriovaldo Andrietta [EMAIL PROTECTED] Date: 7/7/2002 12:38 PM Hi friends : How can i do for learn XML ? Does anyone know some good site that teaches it for us ? Regards

RE: JDBC

Maybe I misunderstood what you guys are talking about. And sorry if that's the case. But you can call anonymous block and return data from Oracle to Java: CallableStatement stmt = conn.prepareCall( begin + open ? for select ename from emp; + end;);

Re:Adding Control files

Yechiel, Whether you have 1, 2, or a dozen controlfiles is a DBA's call, not someone who thinks he knows his stuff. I run my database with 2 control files, on different spindles of course and have no problems of contention there. Now you may be seeing contention with datafiles, redo log

Re: insert nologging parallel/noparallel and archiving - thanks

Gene, Glad to help. A word of caution, do consider the recovery aspects of nologging carefully before use. A backup immediately after the move might be prudent, or keeping the old data around as a fallback. Jack --- Gurelei [EMAIL PROTECTED] wrote: Just wanted to thank Jack, Connor and

When was analyze run last?

If there a way in 7.3.4 to tell the last time analyze was run on an index? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Increase size of REDO log

How do I increase size of redo logs and how do I create additional redo logs? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

AW: JDBC

Hi Richard You can do that. But I think it is recommandable to wrap up the PL/SQL and put it into packages. This way, your code is much better organized than having anonymous blocks throughout your Java code. Regards, Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298

download leads to sales call

Last week I downloaded Oracle9i for Linux from Technet. Today I just got a call from an Oracle salesperson wanting to know what I was doing with it. I suppose it's not unreasonable for them to call and ask what I'm doing with their software, but is it normal procedure? I can't remember whether

Re: HTTP Listener configuration assistant

On Wed, 03 Jul 2002 03:28:19 -0800, Conner McDonald wrote: I'll happily stand corrected but I didn't think the http component actually had its own assistant. Under my ORACLE_HOME/bin (92) I can only see You may well be correct, though the installer did seem to indicate that it was going to run

RE: JDBC

Stefan, Agreed. I am merely pointing out one can call anonymous block. Packages is the way to do it. Richard -Original Message- Sent: Monday, July 08, 2002 12:53 PM To: Multiple recipients of list ORACLE-L Hi Richard You can do that. But I think it is recommandable to wrap up the

Re: Increase size of REDO log

Nguyen, David M wrote: How do I increase size of redo logs and how do I create additional redo logs? Thanks, David -- ALTER DATABASE You must drop and recreate log files to change their size, which will bring you to force a log switch. -- Regards, Stephane Faroult Oriole Software --

Re: table size.

Hi all I have a table with 8 millions rows and I deleted the 500 million. Then I exported tables (300 mb) and imported into another schema. After that, the table size is still the same. I thought table size should be taken much less space. the storage clause for both table is the same:

RE: When was analyze run last?

Hi Smith, check LAST_ANALYZED column of DBA_INDEXES or DBA_TABLES I believe it shouldb be there in ver. 7.3. HTH Arul. -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: 08 July 2002 17:33 To: Multiple recipients of list ORACLE-L Subject: When was

Re: download leads to sales call

This is new. I downloaded it (W2K version) several weeks ago and didn't get a call. I've never gotten a sales call when I've downloaded software from technet. --- Jonathan Gennick [EMAIL PROTECTED] wrote: Last week I downloaded Oracle9i for Linux from Technet. Today I just got a call from an

Re: table size.

Sorry : table is 8 million rows and I deleted 5 million rows. - Original Message - To: [EMAIL PROTECTED] Sent: Monday, July 08, 2002 12:20 PM Hi all I have a table with 8 millions rows and I deleted the 500 million. Then I exported tables (300 mb) and imported into another

Re: When was analyze run last?

Looks into last_analysed column of user_indexes . -Bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 08, 2002 9:33 AM If there a way in 7.3.4 to tell the last time analyze was run on an index? Ron Smith -- Please see the official

RE: download leads to sales call

Hey Jonathan, I remember getting a call a long time ago. I basically told them I was a DBA and just wanted to mess around and learn the new features, etc. of Oracle. I guess they tagged me as such and have never called since. On the other hand, I guess if you said it was for project X, then

Setting db_block_size with installer

I am trying to install Oracle 9.2 on Solaris using dbca (Database Configuration Assistant) and didn't see a handy box to set the db_block_size. I just edited the initialization parameter, but when dbca started installing the database, it returned the errors: ORA-01503 Create controlfile failed

RE: When was analyze run last?

Nope, not in 7.3.4. Look in DBA_TAB_COLUMNS. It should have a last_analyzed column but I am not sure if this is specifically for the indexes last analyzed date. Dave -Original Message- Sent: Monday, July 08, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Hi Smith, check

Re: download leads to sales call

Hard to say. Did the caller give any clues? Did it sound like a We're curious how you're using our software? kind of question or a When will you be sending us a check? kind of question? Jared PS. Wow, 3 question marks in one sentence! Jonathan Gennick [EMAIL PROTECTED] Sent by: [EMAIL

RE: When was analyze run last?

Not there on 7.3.4.4. It seems that the only clue you get is in dba_tab_columns last_analyzed and that won't tell you specifically when an index was last analyzed. Iain Nicoll -Original Message- Sent: Monday, July 08, 2002 6:18 PM To: Multiple recipients of list ORACLE-L Hi Smith,

RE: table size.

500 mill? How did you do your export? Try compress=n -Original Message- Sent: Monday, July 08, 2002 1:23 PM To: Multiple recipients of list ORACLE-L Hi all I have a table with 8 millions rows and I deleted the 500 million. Then I exported tables (300 mb) and imported into another

otn downloaded software not supported at metalink

I stated in a tar last week that my installation source was cpio disk images downloaded from otn. The metalink analyst surprised me with: Because Oracle Support (direct) does not provide support for downloaded copies (see the license agreement on OTN) you must use the online support given by

RE: download leads to sales call

Uncle Larry is watching you!! Be afraid, be very afraid. Dave -Original Message- Sent: Monday, July 08, 2002 12:44 PM To: Multiple recipients of list ORACLE-L Hey Jonathan, I remember getting a call a long time ago. I basically told them I was a DBA and just wanted to mess around

Re: How to learn XML ?

Since you're on an Oracle list, I would recommend 'Building Oracle Applications with XML by Steve Muench. Great book, available at www.ora.com Jared Eriovaldo Andrietta [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/07/2002 01:38 PM Please respond to ORACLE-L To: Multiple

Re: table size.

mitchell wrote: Hi all I have a table with 8 millions rows and I deleted the 500 million. Then I exported tables (300 mb) and imported into another schema. After that, the table size is still the same. I thought table size should be taken much less space. the storage clause for both

RE: 2003 IOUG Meeting

If you have the money... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 11:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: 2003 IOUG Meeting I NEVER get to see every

Re: Increase size of REDO log

First, Check for the one that is not the current one. Select * from V$log; ALTER DATABASE DROP LOGFILE '/u01/oradata/orcl/redo01.log'; delete the file manually ALTER DATABASE ADD LOGFILE '/u01/oradata/orcl/redo01.log' size 30M; Change your size to your desire one. For the other ones do the

RE: When was analyze run last?

Title: RE: When was analyze run last? Ron, Others have mentions the LAST_ANALYZED column of DBA_INDEXES or DBA_TABLES. Sorry but no such columns in 7.3.4. You could look at the LAST_ANALYZED column of DBA_TAB_COLUMNS. It will tell you when the table was last analyzed and you might assume

Re[2]: How to learn XML ?

Jared, Agree, very good book, but then so is the site if your interested in some generic XML stuff. Like what the heck is this stuff?. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/8/2002 9:58 AM Since you're on an Oracle

RE: Oracle Applications Development Database Refresh

Jared, we do that here, but just: take a cold backup of the production db, lay it down over the old dev db (via scp or tape), and open it renaming with a backup cpontrolfile script. Works like a charm, though I'm not sure what applmgr steps are required. Scott Shafer San Antonio, TX

RE: When was analyze run last?

Ron, Iain is right. If you had analyzed with the default 'ANALYZE TABLE' which would have cascaded into an analyze of the indexes, then you can pick the date from DBA_TAB_COLUMNS for that table... John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a

RE: When was analyze run last?

it's in dba_tab_columns and user_tab_columns (not very covenient, but that's where it is) Barb -- From: Nicoll, Iain (Calanais)[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Monday, July 08, 2002 11:53 AM To: Multiple recipients of list

Re: table size.

When using delete , the highwater mark does not change, so the table still use what was allocated. export/import also does noty resize the table. One way to do it, would be to precreate the table with a smaller size then import the data. --- mitchell [EMAIL PROTECTED] a écrit : Sorry :

Re: Setting db_block_size with installer

Dennis, Does it really say '8182', or is that a typo? Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/08/2002 10:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Setting

RE: Increase size of REDO log

You also might need to do an alter database checkpoint; if you get a particular error when you try to drop the log (don't remember it offhand, I always recognize it when I see it :). Jay Miller -Original Message- Sent: Monday, July 08, 2002 2:04 PM To: Multiple recipients of list

RE: 2003 IOUG Meeting

Although it is not cheap to attend IOUG, I agree it is very worthwhile. If money is an issue consider: 1) Presenting - your conference fee is waived or reduced (for quick tips) 2) Volunteering - I volunteered when it was held in Denver and received $300 off for being a room monitor for a day

Re: table size.

Title: RE: table size. Hi Godlwski Thanks for your reply. This is not locally managed tablespace and num_rows are the same. Thefollowing result fromdba_tables. This big different is empty_blocks. I still confused why the size is the same but with much more empty_blocks. I think the

moving Vertias quick io files in oracle

I am trying to move some oracle files that have been quick ioed using Veritas. I have no problem creating quickio files or growing them but when I try to move them I get SQL / alter database rename file

Re: download leads to sales call

I have noticed that they are doing more followup and sales calls lately. Although I haven't downloaded anything recently they have been doing some periodic followup. Just trying to meet sales goals no doubt. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list

Re: download leads to sales call

A few months ago I purchased 9i on CDROM (to long to download at 31.2). I haven't gotten a phone call nor an e-mail about it. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 08, 2002 12:23 PM This is new. I

RE: Increase size of REDO log

Look on Metalink for Note # 30910.1 It's an excellent guide for recreating redo logs as well as other objects. Shirley -Original Message- Sent: Monday, July 08, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Subject:Re: Increase size of REDO log Nguyen, David M

RE: Setting Up EXTPROC

Look at note: 99136.1 on the metalink. It has also many references to other useful documents that might help. Regards, Waleed -Original Message- Sent: Monday, June 03, 2002 9:28 AM To: Multiple recipients of list ORACLE-L Hi all, I've recently been asked to set up an extproc

RE: table size.

This is expected behaviour. COMPRESS=Y doesn't make reference to the amount of space occupied by rows, just the amount of blocks allocated to the object as a whole. It's one of the great misunderstood parameters; really it should have been called COALESCE. Richard's suggestion will probably work

RE: Oracle Applications Development Database Refresh

Jared, I *think* this is 10.7 character. It would be if your users use a VT terminal emulator to access the application. Be aware though that a combination of Character/Smart client could exist... In this case, it does not matter though as the work that you would do will be the same. I

RE: 2003 IOUG Meeting

I realize that it helps that I don't have kids so I have spare cash (no cash is ever really spare and I have very old, very expensive cats) but it IS tax-deductible, at least in part and it's worth it. At least to me. and yes, I have gone and paid all costs myself --- [EMAIL PROTECTED] wrote:

Re: Setting db_block_size with installer

I just installed 9.2 this weekend and my database block sizes are 8k you need to set the blocksize on EACH tablespace. this is from memory, so assuredly not completely correct but should help point you in the right direction: for each tablespace, you can define where the datafiles are.

RE: Setting db_block_size with installer

Hello! So is there a DB_BLOCK_SIZE to set for the database? Or has that been deprecated? And from now you will have to set the block size for each tablespace? -Original Message- Sent: Monday, July 08, 2002 3:27 PM To: Multiple recipients of list ORACLE-L I just installed 9.2 this

Re: moving Vertias quick io files in oracle

Did you first move the file at the OS level? Kathy Duret wrote: I am trying to move some oracle files that have been quick ioed using Veritas. I have no problem creating quickio files or growing them but when I try to move them I get SQL / alter database rename file

RE: 2003 IOUG Meeting

That wasn't a dig at anyone, Rachel. It may be worth it, but if you don't have the means to begin with, you can't very well write it off. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 2:19

Re:RE: Setting Up EXTPROC

John, First question, is this the first extproc listener that you've setup on this server? If your configuring a second, you can't really do that as there can be one and only one extproc_connection_data entry in your tnsnames.ora file. What you need in this case is a new library that

RE: moving Vertias quick io files in oracle

Yes -Original Message- Sent: Monday, July 08, 2002 12:48 PM To: Multiple recipients of list ORACLE-L Did you first move the file at the OS level? Kathy Duret wrote: I am trying to move some oracle files that have been quick ioed using Veritas. I have no problem creating quickio

slightly OT, permissions unix/oracle puzzler

Ok, I log in as oracle, touch a file I get 664 permission on it. But when I create a file through OEM or a plsql procedure I get 644 permissions. My umask is 02. On another system - solaris everything ok. Both .profiles are the same. Sys admins no help. Any clues? Thanks, Kathy

RE: 2003 IOUG Meeting

-you can't very well write it off. Enron and Worldcom accountants can. ;o) Dave -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 2:39 PM To: Multiple recipients of list ORACLE-L That wasn't a dig at anyone, Rachel. It may be worth it, but if you don't have

RE: Increase size of REDO log

How about if I use LogMiner to read redo log to check which transaction had been modified in 5 days ago, how do I know which redo log to look at? Thanks, David -Original Message- Sent: Monday, July 08, 2002 1:04 PM To: Multiple recipients of list ORACLE-L First, Check for the one

RE: Oracle Applications Development Database Refresh

Gotchya. Thanks, that's why I wasn't sure what had to be done there. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: John Kanagaraj [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle

RE: slightly OT, permissions unix/oracle puzzler

Kathy, Ok, I log in as oracle, touch a file I get 664 permission on it. But when I create a file through OEM or a plsql procedure I get 644 permissions. My umask is 02. The umask value is overwritten by the program's mode of writing the file. In other words, umask is the default mode

STATSPACK and sppurge.sql

Hi all, I'm going to (finally!) be implementing STATSPACK on our 8.1.7.2.0 DB. The thing that kills me is all the junk that ?/rdbms/admin/sppurge.sql leaves behind! Is there any harm in deleting the rows from these tables: select table_name from user_tab_columns where

RE: STATSPACK and sppurge.sql

OK, it looks like I should probably leave STATS$DATABASE_INSTANCE alone and STATS$SQLTEXT will have to be dealt with, but the other tables? TIA*2! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA

RE: moving Vertias quick io files in oracle

This is what I did I created a file at the unix level using quickio in /u16 /opt/VRTSvxfs/sbin/qiomkfile -h 8k -s 100k atest.dbf Then created the tablespace atest with datafile /u16/oracle/proddata/atest.dbf To simulate moving a files I did the same thing in u18 /opt/VRTSvxfs/sbin/qiomkfile -h

RE: slightly OT, permissions unix/oracle puzzler

Ok then why would my oem on one solaris system write files as 664 and another write files as 644? both databases have '_trace_files_public = TRUE' parameter. both are writing out files using utl_file. The only difference is one sits on a Netapp filer. I am still confused. Kathy p.s. I

Re: slightly OT, permissions unix/oracle puzzler

for your permissions and umask use all four digits and see what happens. On Mon, 8 Jul 2002, Kathy Duret wrote: Ok, I log in as oracle, touch a file I get 664 permission on it. But when I create a file through OEM or a plsql procedure I get 644 permissions. My umask is 02. On another

Looking for book contributors

First of all, apologies to those I have talked to about helping with our new RMAN book. I've been searching for email addresses that I thought I had tucked away, and only found one. I know there were 2 - 3 other people who expressed a desire to help with our RMAN book project. So now, out goes

Error on creating index

Hi , I have a problem with creating an index ot table AAA with 40 records. After I write following sql and run it ORACLE stops. CREATE INDEX index_1ONUSER1.AAA ( field1,field2 ) I copied same table to user2 and when I write above sql it runs CREATE INDEX index_1ONUSER2.AAA

RE: 2003 IOUG Meeting

Try the off topic list. There are a number of 'faces' there. Jared Fink, Dan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/08/2002 11:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: 2003

Re: slightly OT, permissions unix/oracle puzzler

If you see perm diffs on the files written to NetApp, that could be the result of mount_nfs permissions. Kathy Duret wrote: Ok then why would my oem on one solaris system write files as 664 and another write files as 644? both databases have '_trace_files_public = TRUE' parameter.

RE: slightly OT, permissions unix/oracle puzzler

Hi Kathy, Ok then why would my oem on one solaris system write files as 664 and another write files as 644? both databases have '_trace_files_public = TRUE' parameter. both are writing out files using utl_file. The only difference is one sits on a Netapp filer. Was the

RE: 2003 IOUG Meeting

Hi, All. Before this thread ends, take a swing at this, please: Assuming one can only attend a single conference per year, which is a better value, IOUG or OpenWorld? Thanks. At 12:07 PM 7/8/02 -0800, you wrote: -you can't very well write it off. Enron and Worldcom accountants can. ;o)

Re: Error on creating index

Hello, What does "Oracle stops" mean ? If Oracle crashes without an error, check alert.log. If not, debug your session with event 1006 level 8 to see Oracle kernel events. regards... Ali TOYGAR wrote: Hi , I have a problem with creating an index ot table AAA with 40 records.After I write

Re: Error on creating index

Ali, Do you get an error message? If so, post it as that will help troubleshooting efforts. Is there already an index named index_1 in the USER1 schema? Just some ideas. Stephen [EMAIL PROTECTED] 07/08/02 02:04PM Hi , I have a problem with creating an index ot table AAA with 40

RE: Looking for book contributors

Robert - I had spoken with you about the book at the IOUG, and gave you a copy of the outline I had been toying with. You had mentioned that you might like me to possibly contribute some information on Veritas NetBackup. Would that still be possible? Brian

RE: Looking for book contributors

Sorry, all... That was obviously a message meant only for Robert... Stupid hotkeys... -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original Message- Robert

RE: Oracle Applications Development Database Refresh

Thanks Scott, but the applmgr stuff is where the details are. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/08/2002 11:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle Applications

RE: moving Vertias quick io files in oracle

Kathy, I am assuming that you did a cp and not a mv to get the file into /u18 from /u16. If you do an ls -ltra in both directories (u16 u18) is there an atest.dbf and a .atest.dbf in both directories (atest.dbf links to .atest.dbf::cdev:vxfs:)? The error seems to imply that the original

RE: Oracle Applications Development Database Refresh

Thanks John. Definitely not NCA. Definitely not using terminal emulation, so it must be the smart client. I'll take a whack at it using your instructions as soon as I can get to it. The dev instance is on the same (underpowered) box as production server. I don't yet know if this simplifies

Re: slightly OT, permissions unix/oracle puzzler

Kathy, I'm going to assume that what you're trying to do is create UTL_FILE files that have group r/w permissions. As others have pointed out, you're being thwarted by the perms of the oracle process. Here's how I've overridden that in the past. Assuming your directory is

RE: Oracle Applications Development Database Refresh

My apps person tells me that they just restore the db and the applmgr stuff works fine with 10.7. Its sloppier than restoring the appl_top as well, but works. 11/11i being an entirely different animal. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL

RE: STATSPACK and sppurge.sql

Jesse - I'm doing this from memory, so I may be off a little. Look at the table STATS$SNAPSHOT. Records in this table are related to the other tables that are populated each time a snapshot occurs (the magic of relationships). If you delete a row from this table, rows in the other tables are

  1   2   >