Re: How to improve the performance of Direct path Write?

Consider that direct path event are the ones involve in f.e. sort_direct_writes=TRUE in 8.0.X or 7.3.X. In 8i doesn't exist as a parameter. However it is feature included in the engine with default values for their buffers. Also insert /*+ APPEND */ or sql*loader direct=y generates that kind of

RE: Sizing a new server

Title: RE: Sizing a new server By the sounds of it, Kimberley was in a very similar situation to me when I was working for a semi-conductor manufacturing company afew years ago (the worst job I ever had).Basically money was no object and anything was feasible as long as the fab kept running

Re: Corrupt block in DBVERIFY

Jared and Ron, As Jared mentioned, dbv can incorrectly report corrupt blocks on an open datafile, although this is likely to happen only if there is heavy write activity to the datafile and dbv scans a block as it is being written. In which case scanning the file when the db is closed or

Re: Corrupt block in DBVERIFY

The workaround that first comes to my mind is to take all the objects of that tablespace and do an analyze .validate structure. Take into account that the validate structure clause locks the object. This could be a script for that: set pagesi 0 set feedba off spool validate.sql select

81714 aborted upgrade and core dumps on NT

Hi, I have just had the experience of upgrading to 81714, discovering a problem in our application that did not show up in any testing and having to go back to 815. The 815 instance is on a different server to the 817 instance and we still have the 817 instance available for further

arrays in PL/SQL

I want to create arrays of a user defined record in PL/SQL Do I need nested tables/varrays and therefore the Object option : do I need Enterprise Version is 8.1.7 John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City

Re: Corrupt block in DBVERIFY

Jared and Ron, As Jared mentioned, dbv can incorrectly report corrupt blocks on an open datafile, although this is likely to happen only if there is heavy write activity to the datafile and dbv scans a block as it is being written. In which case scanning the file when the db is closed or

Re: [Fwd: Importing data from dump exported with different character set]

Brijesh, The actual error number(s) would be more helpful ;) There are issues with exp/imp between single-byte and multi-byte character sets. Did you do a conventional or direct-path export? What are the OS's for the export and import db's? Have you tried explicitly setting env variable

RE: UNIX SA

Title: OT: UNIX SA The Solaris FAQ: http://www.science.uva.nl/pub/solaris/solaris2.html Sun's own documentation, all available online for free (in PDF too): http://docs.sun.com/ The "Ferrari book" is excellent, even tho' that's actually a Porsche on the cover:

Re: How to execute Unix Command/program within a pl/sql block.

Hi, you can't do this from PL/SQL but you can do it from Java and it's fairly easy too. I'm not able to check the name of the class tht does it but armed with the phrase java os command and either the Metalink or Ask Tom web site you should be able to track it down. Regards, Mike

Trigger help

Dear DBA Gurus, I have a table with two fields name and status. What I want to do is once the current system date rolls over from 30th to 31st the status should be entered as closed other wise from 1st to 30th the status should be entered as open. How do I do this using trigger or any

table aliases save time when parsing??

Hi, was reading CorrelatedSubqueries.pdf from oriolecorp. In fact it's good programming practice to use aliases in every situation where more than one table is referred to in a statement, since it saves time when parsing. Can some one please explain how it helps? cozI am anoviceOracle

Re: 81714 aborted upgrade and core dumps on NT

Bruce, Core dumps are even more of a pain on NT since they don't generate a helpful trace file as on other platforms. You should have a core.log file in one of the dump directories (core_dump_dest didn't work on NT, although I've heard it does on 8.1.7+, but haven't tested it). There should be

RE: UNIX SA

Andrey If you have some spare PC hardware lying around then consider installing a copy of Linux, purchase it or download it and burn your own distro. Get that installed and running and then get something like Oracle running on it set up and get apache running on it, Mysql and Postgress are

RE: arrays in PL/SQL

No, you can use PL/SQL tables for that. PL/SQL tables are the PL/SQL equivalent of arrays in other languages (well, it's about as close as you're going to get anyway). -Original Message- Sent: Tuesday, July 10, 2001 4:41 AM To: Multiple recipients of list ORACLE-L I want to create

Re: Help!

Malini, Personal Oracle is not designed for production use, but for development use. As such it doesn't allow more than one session to connect via the listener (I don't believe they've increased this limit with 8.x). Olite will work with Personal Oracle, but it's not very practical since you

Date / Time

Hello All I want to display the time elapsed between two dates - in days, hours, minutes and seconds. If I do select date1 - date2, the result is : 12.0194907 Is there a function that will turn the number of days into something more legible? Ideally i'd like to do ;

RE: Sizing a new server

Title: RE: Sizing a new server Bruce, It's going to be Unix, tru64. Unfortunately I will be stuck with some old hardware to start with - an Alpha, 8400, I believe maxes out at 8 cpu's, along with two old disk farms (compaq esa10k). I'm slapping together a bunch of old pieces of hardware,

RE: gzip does not want to work with files 2G

Yup, it's cos you have the 32-bit version. There's a large files version on http://sunfreeware.com/ if I remember correctly. HTH, g -Original Message- Sent: Tuesday, July 10, 2001 12:12 AM To: Multiple recipients of list ORACLE-L I have Solaris 5.8 angzip does not want to work with

Re: table aliases save time when parsing??

Well, it's not aliases themselves, but the practice of using aliases as prefixes, when referring to columns: SELECTt1.col1, t1.col2, t2.col1 FROM table1 t1, table2 t2 WHERE t1.col2 = t2.col2 that's what saves time when parsing: this way you tell the parser which table column list to look

RE: UNIX SA

Thanks Guy, I needed to a) spend money on books b) go blind reading docs online and c) lose what little free time/life I have left :) Okay, okay, so I probably won't read it all cover to cover. And I mostly likely won't understand even 20% of what I read. But it can't hurt in talking to my

Alert log scan script

Last week I was bit by a corrupt block on an index. I run Analyze every week which I found has been blowing up for some time due to the block corruption. Since Analyze does not create a log I did not know the Analyze was blowing up. Now I know that there are messages in the alert log that

RE: UNIX SA

Guy, You may already have this: http://www.amazon.com/exec/obidos/ASIN/1568842031/qid=994768530/sr=1-55/ref=sc_b_55/104-1460714-8103942 as it is currently out of print -- it's sitting on my bookshelf at home The Unix-Hater's Handbook Simson Garfinkel and Daniel Wiese Rachel From: Guy

Re[2]: table aliases save time when parsing??

Igor, Square hit as I remember it. I've read a couple of items from oriole corp and while I have never found anything they've written to be wrong, they have been less than completely clear on the why's and wherefores as in this case. Dick Goulet Reply

Re: UTL_SMTP

thanks arno it works like a charm coz I am a novice Oracle Certifiable DBBS - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 04, 2001 9:14 PM Try this one: create or replace PROCEDURE send2 (sender IN VARCHAR2, recipient IN

OEM 2.2 client for Sun

Title: OEM 2.2 client for Sun Hi gurus, We work with OEM 2.1 client on PC and Sun stations and we wish to upgrade to OEM 2.2 (we have DBAs on Sun stations). I can't find OEM 2.2 client for Sun on the Sun Solaris 8.1.7 CD pack, I can only find it for Windows. Is it just me or does Oracle

RE: table aliases save time when parsing??

Consider SQL select deptno from emp, dept; select deptno from emp, dept * ERROR at line 1: ORA-00918: column ambiguously defined The column deptno would be checked against one of the tables and would be found to be valid, but the checking cannot stop there. The other table must also

Re:O9i Licensing

Steve, I have heard nothing to suggest that Oracle is abandoning the standard vs. enterprise edition packaging. What I have heard and read at Oracle.com is that they are abandoning the Universal Power Unit in favor of Per Processor pricing. Namely there is today two license models that

RE: O9i Licensing

Thanks Rachel. Is there any breakdown as to Enterprise Edition vs Standard Edition features? Steve -Original Message- Sent: Monday, July 09, 2001 7:21 PM To: Multiple recipients of list ORACLE-L According to the 9i concepts manual, there is a standard and enterprise edition.

RE: UNIX SA

Here's a very readable one... http://www1.fatbrain.com/asp/bookinfo/bookinfo.asp?theisbn=0201353954vm= If the link doesn't stick, then just look for unix and redhat 'quickstart guides' on fatbrain.com They are cheap, readable and easy to reference. -- Please see the official ORACLE-L FAQ:

RE: gzip does not want to work with files 2G

I use version 1.3 for Solaris 5.8 - it is the same version that is on www.sunfreeware.com What version do you use and for which version on Solaris? Alex Hillman -Original Message- Sent: Monday, July 09, 2001 10:46 PM To: Multiple recipients of list ORACLE-L What version of gzip are

Oracle 8i on Linux (8.1.6 on RH7) - install help

RedHat 7.0 Running Oracle for Linux 8.1.6 - INSTALLATION HELP NEEDED! I am s close... Despite good install, including Net8, the sample db install hung at 80% completed. Now I am trying to startup nomount and create a dbase manually. I cannot STARTUP NOMOUNT PFILE= svrmgrl can

RE: O9i Licensing

Well, if you're lucky enough to use the Enterprise Edition you'll be saving money. We use the Standard Edition, and at this time it looks like it's going to cost us quite a bit more, actually, for a per-processor license. So, we're currently in delicate negotiations with our Oracle rep and

RE: can/do indexes chain?

Even for inserts, index key values cannot span multiple blocks. An attempt to create an index where a single key value won't fit in a single block will result in an ORA-1450 maximum key length exceeded. -- Anita --- Hillman, Alex [EMAIL PROTECTED] wrote: Update in the index is done as delete

Client Connection-SQLNET and?/or? ODBC.

Dear DBA Colleagues, Please pardon me if this question is a bit elementary, but this concerns applications connecting to Oracle. Most of our Oracle Apps are PowerBuilder-based such that we use the appropriate PowerBuilder DLLs and SQLNET on the Client to connect up to SQLNET and the Oracle

Re: Date / Time

Sajid, Unfortunately, I ran into the same problem. I didn't find anything to do it for me, either, so I had to write the pl/sql code. It is very long and messy, but can be done. When I did it, I didn't even attempt the days notation. Here is the code that I wrote:

Oracle DBA with Data Warehouse Exp.-Albany, New York

Healthcare solutions company in Albany, New York needs an Oracle DBA to join it's I.T. team. This company provides technical solutions to pharmacy, HMO and hospital clients. They are calling it a Developmental DBA: You will be responsible for all facets of development related to the logical

RE: Oracle support phone number

1-800-223-1711 (Silver) -Original Message- Sent: Monday, July 09, 2001 4:52 PM To: Multiple recipients of list ORACLE-L 1-407-240-8900 -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Monday, July 09, 2001 4:05 PM To: Multiple recipients of list ORACLE-L Could

RE: 81714 aborted upgrade and core dumps on NT

Are you running the 8.1.7 sqlnet clients and odbc drivers. We did have some as yet unexplained errors connecting older versions to 8.1.7 - most notably with large objects. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 3:05 AM To: Multiple recipients of list

RE: Sizing a new server

Title: RE: Sizing a new server Hi Lisa, That doesn't sound too bad, the 8400 is a solid piece of kit. 64-bit, up to 14 CPUs and 28G of memory. They have seriously good I/O bandwidth. Needs a three-phase power supply and weighs, literally, half a tonne. And best of all, you can run VMS on

Re: Date / Time

Sajid Iqbal wrote: Hello All I want to display the time elapsed between two dates - in days, hours, minutes and seconds. If I do select date1 - date2, the result is : 12.0194907 Is there a function that will turn the number of days into something more legible? Ideally i'd like to

Re: Alert log scan script

I believe that a dedicated window running tail -f 10 /alert_log_filename will keep an eye on the last 10 lines of the alert log in Unix/Linux. - jeremy donson CateredComputing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat

RE: O9i Licensing

haven't found it in the concepts manual... can't remember where it was in the 8i docs From: Orr, Steve [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: O9i Licensing Date: Tue, 10 Jul 2001 06:05:25 -0800 Thanks Rachel. Is

RE: any dangers of using UTL_SMTP

Thank you very much everybody for your expert comments. That really helped me to put my case with manager who has concerns about using UTL_SMTP with loading java in database. Thanks again Sandesh -Original Message- Sent: Friday, July 06, 2001 4:38 PM To: Multiple recipients of list

RE: db-links question

Alex, Yes, the connection remains open unless it is explicitly closed (see Note: 1034343.6). The session also takes out a lock on the local RBS (see Note:74811.1) as this could be part of a distributed transaction. If this is a long running query this can lead to abnormal growth in the RBS

Rename alert log

Can the alert log be renamed while the database is up and running? Ron -- 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-- Public

ORA:12514 Error

Hi, I had installed oracle 8.1.7 on WINNT and installed oracle client with administrator utility on win2k system. When i want to connect to this client on win2k to server on winnt. But i am getting the error ORA:12514. Can any one slove this for me. The listener.ora and tnsnames.ora files seems

Re: Alert log scan script

Try AlertView from zephyrus.com. It is a free tool for analyzing your alert logs. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 9:31 AM Last week I was bit by a corrupt block on an index. I run Analyze every week

RE: 12514 Error

Hi Definitely check whether you can ping the server from the client. If not, then it's a network config problem. After that, I once had this problem when a highly creative user (actually, our CTO) had entered a setting for Oracle Names when we were using local names only. I had to delete the

old stats and temp space

Is there any correlation between out of date analyze stats and temp space usage? i.e., could old stats cause overly large temp space usage? Steve Sapovits Global Sports Interactive Work Email: [EMAIL PROTECTED] Home Email: [EMAIL PROTECTED] Work Phone: 610-491-7087 Cell:

RE: Rename alert log

Ron: Yep. Do it every night at midnight. But...you can't just rename it! If you do a command like... mv alert_SID.log alert_SID_010710.log touch alert_SID.log ...Oracle will still append new entries to the old file, and your new alert_SID.log file will continue to have 0 bytes. What you

Re: OEM 2.2 client for Sun

i dont know the answer to that one for sure, but its available for linux(java based) so i'd think it should be available. joe [EMAIL PROTECTED] 07/10/01 09:45AM Hi gurus, We work with OEM 2.1 client on PC and Sun stations and we wish to upgrade to OEM 2.2 (we have DBAs on Sun stations).

RE: Alert log scan script

Ron, I've attached one that I also got from the list some time ago, you may need to use something like bablefish to translate the comments :) HTH Mark -Original Message- L. Sent: Tuesday, July 10, 2001 02:32 To: Multiple recipients of list ORACLE-L Last week I was bit by a corrupt

RE: Date / Time

SELECT 12.0194907 ,FLOOR((12.0194907*86400)/86400) || ':' || TO_CHAR(TO_DATE(ROUND(SUBSTR(12.0194907,INSTR(12.0194907,'.'))*86400),'s '),'HH24:MI:SS') FROM dual HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc.

Re:Client Connection-SQLNET and?/or? ODBC.

James, First off, Linux does not use DLL's, that's a MicroSlop thing. It does make use of .so files for Shared Object, which is a Unix thing. Now as to the subject of ODBC: ODBC stands for Open Data Base Connectivity which again was a MicroSlop idea that has caught one. OK, I'll give

RE: Sizing a new server

Title: RE: Sizing a new server Actually, it really depends on the industry at the moment as to whether or not money is no object. Currently money is a huge issue. The semi-conductor fabs are not doing so hot right now (at least not the memory producing ones). Fabs are all pretty much in a

RE: Client Connection-SQLNET and?/or? ODBC.

Yes you need SQLNET. odbc uses sqlnet on the client. -Original Message- Sent: Tuesday, July 10, 2001 10:15 AM To: Multiple recipients of list ORACLE-L Dear DBA Colleagues, Please pardon me if this question is a bit elementary, but this concerns applications connecting to Oracle. Most

OT : Oracle datawarehouse DBA available in Canada

Hi, Sorry for the out of topic post. I'm going back to Canada. I'll be looking for a position as an Oracle devlopment dba in the datawarehousing field for the Montreal area. I do not know if they are recruiters looking for candidates in the Montreal area but if so you can contact me at

need to recreate database

Hello, I need to recreate a database, basically make a complete copy of one of the existing databases on a new server. My networking people already copied all datafiles, control file, log files, init file, etc to the target server. They also reproduced operating system directory structure. What

RE: O9i Licensing

Yeah, I noticed that about the pricing too, for the E10k it is still 2.6 Million, same exact price as before. -Original Message- Sent: Tuesday, July 10, 2001 11:41 AM To: Multiple recipients of list ORACLE-L Both are still there, and despite the hype it actually looks like a price

RE: Client Connection-SQLNET and?/or? ODBC.

Yes, you do need to have Net8 installed in order for Cold Fusion to connect to the database through ODBC. It uses ODBC through SqlNet. First set up the Sqlnet connection to the database, then set up the ODBC connection using the service name you used for the Sqlnet connection. hth, Robin

RE: 81714 aborted upgrade and core dumps on NT

We have been running 8.1.7 for a couple weeks. The clients are 8.1.6 still [EMAIL PROTECTED] 7/10/01 11:55:59 AM Are you running the 8.1.7 sqlnet clients and odbc drivers. We did have someas yet unexplained errors connecting older versions to 8.1.7 - most notablywith large

RE: Performance/Optimization/Monitoring Tools

I would say now that CA owns ERwin it pretty much is terminal, regardless of whether or not its the last release they send out. -Original Message- Sent: Monday, July 09, 2001 9:00 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wrote: For those of you who maybe

Re: Rename alert log

depends on the version of the database you are running.. it used to be that yes, you could just rename it and Oracle would open a new one of the original name when it needed to write to it. In 8.? and above, you can no longer just rename it, Oracle now maintains an open file pointer to it,

RE: Performance/Optimization/Monitoring Tools

Other than those from the companies you have mentioned (and personally - as already mentioned - I would stay away from CA) here are a few others to bear in mind: SHAMELESS PLUG NORAD Surveillance Module - www.bradmark.com (also www.cool-tools.co.uk) (Sits in between Spotlight Foglight from

RE: Rename alert log

Yes -Original Message- Sent: Tuesday, July 10, 2001 9:57 AM To: Multiple recipients of list ORACLE-L Can the alert log be renamed while the database is up and running? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL

help how get the n top rows for any table?

Hi, gurus!!! A need know how get n top row for any table somebody can help me!! Thanks!!! @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de

Question about OFA and RAID 5

Any suggestions on the message below would be greatly appreciated. Thanks in advance. I have been appointed our new Oracle DBA and have since been taking classes and reading books. I quite enjoyed the recent thread on OFA. I seem to have a bit of a quandary, here it is. We have 68

RE: O9i Licensing

This is the list for 8i: http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server .817/a76962/ch4.htm http://technet.oracle.com/doc/oracle8i_816/server.816/a76962/ch4.htm http://technet.oracle.com/doc/server.815/a68020/ch4.htm Although they are two different URL's

OT - get together for list participants in DC area

It's possible, sure..good idea. It may just wind up being you and I Alex, in which case I can buy your beersif you don't mind the speedo. :) -Original Message- Sent: Monday, July 09, 2001 5:26 PM To: Multiple recipients of list ORACLE-L There will be MAOP DBA SIG meeting on

Re:RE: O9i Licensing

Walt, Thanks man, my 401K can use the boost!! Dick Goulet Reply Separator Author: Weaver; Walt [EMAIL PROTECTED] Date: 7/10/2001 8:02 AM Well, if you're lucky enough to use the Enterprise Edition you'll be saving money. We use the Standard

RE: Rename alert log

Yes, it can. Just rename it and there will be new one created with an old name at some point. -Original Message- Sent: Tuesday, July 10, 2001 10:57 AM To: Multiple recipients of list ORACLE-L Can the alert log be renamed while the database is up and running? Ron -- Please see the

RE: 81714 aborted upgrade and core dumps on NT

Hello, you can email me with zipped core file. 10/7/01 07:51:51, Jeffrey Beckstrom [EMAIL PROTECTED] wrote: We have been running 8.1.7 for a couple weeks. The clients are 8.1.6 still [EMAIL PROTECTED] 7/10/01 11:55:59 AM Are you running the 8.1.7 sqlnet clients and odbc

RE: Rename alert log

Yes. Rename delete trimmedetc. -Original Message- Sent: Tuesday, July 10, 2001 9:57 AM To: Multiple recipients of list ORACLE-L Can the alert log be renamed while the database is up and running? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: gzip does not want to work with files 2G

I also uses gzip 1.3 on Solaris 8 (1999-12-21 build). The one that comes with Solaris 8 was 1.2.24 or something which doesn't support file 2G. Did you get rid of the old gzip 1.2.24? Make sure it's using the new one that you installed not the old version. [EMAIL PROTECTED] 07/10/01 10:05AM

Re: Date / Time

On Tue, Jul 10, 2001 at 05:26:09AM -0800, Sajid Iqbal wrote: I want to display the time elapsed between two dates - in days, hours, minutes and seconds. If I do select date1 - date2, the result is : 12.0194907 Is there a function that will turn the number of days into something more

RE: Rename alert log

Ron: If you mean, Can the alert log be renamed for archiving purposes while the db is up? the answer is yes. Oracle will just recreate the alert log the next time it needs to write an entry to it. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio --- Original Message ---

RE: OEM 2.2 client for Sun

Look in your $ORACLE_HOME/bin directory. There should be an "oemapp" executable. The OEM console is started by: "oemapp console". hth -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 10, 2001 11:41 AMTo: Multiple recipients of list

RE: Rename alert log

In 816 on NT, you can rename it any time you want. is this changing in 817 Rachel? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, July 10, 2001 1:27 PM To: Multiple recipients of list ORACLE-L depends on the version of the database you are running..

Re: help how get the n top rows for any table?

If you're running Oracle8i, you can do this: SELECT * FROM (SELECT * FROM my_table ORDER BY col_name_1 DESC) WHERE ROWNUM 10; Use this workaround with prior releases: SELECT * FROM my_table a WHERE 10 = (SELECT COUNT(DISTINCT maxcol) FROM my_table b WHERE

Re: Date / Time

Hi The script below may help you - it will display different components in separate columns, modify it with your two dates and proper table name and remove what you don't need select sysdate, sysdate - to_date('0307200100', 'DDMMHH24MISS') diffr, trunc(sysdate -

RE: Client Connection-SQLNET and?/or? ODBC.

Hello James, Every ODBC connection I've seen or used has connected through SQL Net (i.e,., app-odbc-sqlnet-database). But ODBC isn't really my area of expertise... Jay Miller -Original Message- Sent: Tuesday, July 10, 2001 11:15 AM To: Multiple recipients of list ORACLE-L Dear DBA

RE: Date / Time

Sajid: Try this piece. I use a version of it for my uptime.sql script: TO_CHAR(TRUNC(date1 - date2)) || ' day(s), ' || TO_CHAR(TRUNC(MOD(date1 - date2 - 1, 1) * 24)) || ' hour(s), ' || TO_CHAR(TRUNC(((MOD(date1 - date2 - 1, 1) * 24) - (TRUNC(MOD(date1 - date2 - 1, 1) * 24))) * 60)) || '

RE: Rename alert log

dunno about NT, I do know that it changed on Unix.. as per a thread here in the not too distant past. I believe Anita had posted something on it.. and that it WAS a change from prior versions. I am an Oracle on NT ignoramus :) From: Mercadante, Thomas F [EMAIL PROTECTED] Reply-To: [EMAIL

RE: Rename alert log

Hmmm...in Oracle 7.3.4,, 7.3.5, 8.0.5, 8.0.6, 8.1.6, and 8.1.7 on HP/UX 10.20/11.0, a rename of the alert log causes a new one to be created with the next message. My AlertLogChecker renames the alert log if it finds an error in there. As I'm attempting to size partitions for a non-partitioned

RE: Rename alert log

I am running 8.1.7 and just last week renamed my alert.log while the database was up and everything seemed to work fine. It created a new alert log on the fly. Dave -Original Message- Sent: Tuesday, July 10, 2001 1:01 PM To: Multiple recipients of list ORACLE-L In 816 on NT, you can

No Subject

Registry, services? OH wait must be an NT thing, sorry, i was having an acid flashback that unix was going down the tubes. Sorry, joe Coed-naked Database Administration Find 'em fragmented, leave 'em coalesced. [EMAIL PROTECTED] 07/10/01 01:26PM Hello, I need to recreate a database,

Re: need to recreate database

[EMAIL PROTECTED] 07/10/01 01:26PM Hello,I need to recreate a database, basically make a complete copy of one of theexisting databases on a new server. My networking people already copied alldatafiles, control file, log files, init file, etc to the target server.They also reproduced

RE: O9i Licensing

Specifically, what Steve and I are looking for are a list of things that, in 8i, were NOT included in the Standard Edition but MIGHT be included in the Standard Edition in 9i. Bitmapped indexes, partitioning, and transportable tablespaces are a few. Oracle has done this sort of thing in the

Re: help how get the n top rows for any table?

Alexander, Tuesday, July 10, 2001, 1:45:51 PM, you wrote: AO Hi, gurus!!! AO A need know how get n top row for any table somebody can help me!! AO Thanks!!! AO @lex AO AO Lic. Alexander Ordóñez Arroyo AO Caja Costarricense del

RE: Rename alert log

Oh yea, I forgot to mention that I have Oracle running on NT. :( Dave -Original Message- Sent: Tuesday, July 10, 2001 2:06 PM To: Multiple recipients of list ORACLE-L I am running 8.1.7 and just last week renamed my alert.log while the database was up and everything seemed to work

oradim

Can anyone point to oradim utility documentation? I am having a little hard time finding it. Thank you. Lyuda Hoska -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: Rename alert log

Title: RE: Rename alert log same here. jon -Original Message- From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 3:06 PM To: Multiple recipients of list ORACLE-L Subject: RE: Rename alert log I am running 8.1.7 and just last week renamed my

RE: Rename alert log

Yup -Original Message- L. Sent: Tuesday, July 10, 2001 03:57 To: Multiple recipients of list ORACLE-L Can the alert log be renamed while the database is up and running? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL

Re: UNIX

Richard, are you asking about how to see the underlying striping/slicing? I thought only the unix/sysadmin could tell you for sure, or the person who did the original slicing. joe [EMAIL PROTECTED] 07/10/01 01:51PM Does anyone know of a command or file that would display the available

Re: OT - get together for list participants in DC area

Or the eau de fava bean... Mohan, Ross wrote: It's possible, sure..good idea. It may just wind up being you and I Alex, in which case I can buy your beersif you don't mind the speedo. :) -Original Message- Sent: Monday, July 09, 2001 5:26 PM To: Multiple recipients

Installation oracle through responsefile

Hi All I am trying to install oracle 8.16 in non-interactive mode(silent) mode. However installation does not proceed and fails I am giving following command runInstaller -silent -responsefile /oracle/response/ ee_typical.rsp However in /tmp/silentInstall.log I get following error No forced

Re: need to recreate database

Lyuda, If the database is still running on the old server, and the disk structure is the same on the new server, the easiest way is to do an export of the old database and an import with full=Y on the new server. If the database was shut down before the files were copied, this should also

RE: OT - get together for list participants in DC area

:) -Original Message- Sent: Tuesday, July 10, 2001 3:54 PM To: Multiple recipients of list ORACLE-L Or the eau de fava bean... Mohan, Ross wrote: It's possible, sure..good idea. It may just wind up being you and I Alex, in which case I can buy your beersif you don't

Re: Rename alert log

Does anyone know starting from which version you have to do the tricky thing to rename the alert.log? Or is this only apply to certain OS platforms? I am on 8.1.7 EE on Solaris8 and I can still just move the alert.log and Oracle will just recreate one when it needs to write the next message. I

  1   2   >