RE: Rollback !

And you may well use Logminer to determine what that exact point in time is (and then use tablespace point in time recovery to do the actual recovery). Bruce Reardon -Original Message- Sent: Thursday, 29 August 2002 2:52 There is a way of undoing DDL and it is described in the RMAN

Solved:strange data format error: ora-01821

DENNIS WILLIAMS, hi, I finally solved it by recreate a new database and export the old data and import it into the new database.They are on the same machine with same os and same oracle version and same configuration. I just failed to solve the question and tried create a new

Re: Notification of failed backup

Another solution I think of would be to set up a DBMS job using UTL_FILE to read (and parse) the export log file and UTL_SMTP to send alerts (or messages saying 'OK'). A bit more difficult with the hot backup, but if the procedure is able to log failure somewhere then the same principle could be

RE: ORA-3120 querying across a DB-Link from a 9i2 db to and 8.1.7

Thanks for pointing out the Note. However, Note 19796.1 isn't very helpful. It does talk of buffersize, and I have tried changing the Arraysize (but not the buffersize) in sqlplus. The note seems to indicate that the problem could be in the client application. When querying across a db-link,

Oracle Application Server

Hi friends I would like to know is there any difference between Oracle Application Server and Oracle 9i Application server.? If there is difference ,then what is the First version of Oracle 9i Application Server? The term is confusing me. Any one clarrify me please. Thanks in advance syed

AW: Slightly OT: Rounding Negative Numbers

I think it is correct to round -0.875 to 0.87, since what you do is multiply a by 100 (-87.5). If you round this, the correct value is -87. Divided by 100 = -0.87. So, Java is fine. Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto:[EMAIL

Any do's and dont's for a 9i oracle installation on RedHat Linux

I am installing RedHat Linux and oracle 9i on two RM servers. I have never run Linux before. I usually run HP L-class or Sun Sparc servers with 8/8i. I would welcome emails with tips anybody has for avoiding anything I don't know that I should be avoiding yet, if you see what I mean! OT:

Re: Slightly OT: Rounding Negative Numbers

I know the rule round up, but does up mean the highest value (-0.87) or the highest absolute magnitude (-0.88)? :) - Bill. At 09:53 28/08/2002 -0800, you wrote: I would think -0.875 would round up therefore -0.87 is my guess. Rick -- Please see the official ORACLE-L FAQ:

arg list too long in unix

Hi all, OS: SOlaris 2.8 DB: 8i In the clean up process of the following files, I am trying to list out the files that start with cz. cz-session-returnui177_11Jan02_0959AM_33509.txt cz-session-Applet178_11Jan02_0959AM_34108.txt cz-session-returnui175_11Jan02_0959AM_20504.txt

Re: Any do's and dont's for a 9i oracle installation on RedHat

in case you run into troubles with make consult the RH hompages and refer to the notes for oracle 9 RH server 2.1. These hints/tips work for the distribution of RH 7.0,7.1,7.2,7.3 as well. We have Oracle rdbms 9.2.0 Enterprise edition and OID and IAS on RH 7.2 and RH 7.3. there shouldn't be

Re: arg list too long in unix

Use the xargs command. Read about it in the man pages. Or use find, but that is more complex. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - OS: SOlaris 2.8 DB: 8i In the clean up process of the following files, I am trying to list out the files that start with cz.

Re: Any do's and dont's for a 9i oracle installation on RedHat

www.suse.com/oracle Although it's not Red Hat, they have pretty good instructions and tricks for Oracle Installation, many of which are applicable to RH as well. Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002

RE: Oracle Application Server

there was a discussion re. the OWS/OAS/OWAS/iAS versions a week or two ago on this list. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch |

RE: HIPAA compliance and Win2k

I don't know if you saw the Larry Ellison presentation to the LINUX convention... www.oracle.com, there is a link near the bottom. The beginning is funny, with the penguin being driven around in a limo and eating with executives. Larry says in passing that OTN is running on LINUX now. Regards,

RE: Schedule Statspack Report Creation

I have the collections of snapshots scheduled in DBMS_JOBS, but I was looking for a way to automate running of the reports from these snapshots. It looks as though there is no easy way to do this. Thanks for the quick responses. Erik -Original Message- Sent: Wednesday, August 28, 2002

Re: arg list too long in unix

kommareddy sreenivasa wrote: Hi all, OS: SOlaris 2.8 DB: 8i In the clean up process of the following files, I am trying to list out the files that start with cz. cz-session-returnui177_11Jan02_0959AM_33509.txt cz-session-Applet178_11Jan02_0959AM_34108.txt

Re: Oracle Application Server

Hi, IAS - Apache OAS- SpyGlass OAS and iAS are webservers. iAS is basically the same as OAS, but the major difference is the listener is an Apache, and from cartridges to modules. iAS is more or less the 'next generation' of OAS as Oracle8i was the next generation of Oracle8. Regards,

Re:RE: Re[2]: controlling CPU usage through Oracle

Dennis, You've got that right. Damned PeopleSoft! We were hoping we might be able to leverage ORM to control PeopleSorft query users. No such luck since everyone is PeopleSoft. Now on the other hand, if you've got the LUXURY of having people logged in with their own usernames you

Re: HIPAA compliance and Win2k

. Oracle9i Database R2 Developers Release on Apple's new Mac OS X version 10.2 ''Jaguar.'' is much more interesting headline for me :-) JP On Thursday 29 August 2002 14:28, you wrote: I don't know if you saw the Larry Ellison presentation to the LINUX convention...

Re: Re[2]: controlling CPU usage through Oracle

Kevin, Thanks for your input. Just to clarify; I only want to control this one database. I want to limit its resources so it does not impact the other 4 databases on the box. So, in that case would resource manager be beneficial ? Also, besides profiles, and resource manager, does anyone

Re: Any do's and dont's for a 9i oracle installation on RedHat Linux

Not on the oracle topic: RH is pretty insecure out of the box. If you don't take steps to lock it down the machine will be compromised within the hour in our experience. There are some good web pages out on the steps that need to be taken:

AW: Slightly OT: Rounding Negative Numbers

After an intense ask-your-local-mathematician-session, here you go: It depends ;) (That's typical math-guys, isn't it ?). If you define round according to the Gauss function, then it should calculate it using absolute values, that would be -0.88. On the other hand, round is usually defined to go

AW: Oracle Application Server

Hi I always thought iAS refers to a whole suite of things. The webserver (which is an Apache in iAS) is one component. But there is more to it like J2EE containers, a servlet engine, mod_perl (?), messaging and other stuff (haven't really into anything besides J2EE EJB containers, the web

working with datafile 2Gb in HadHat 7.3

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.

AW: arg list too long in unix

Hi take a look at xargs, it handles those things. regards, Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto:[EMAIL PROTECTED] visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp

RE: arg list too long in unix

how about; $ find . -name 'cz*' -print | xargs ls -lt or $ find . -name 'cz*' -print | xargs rm -Original Message- From: kommareddy sreenivasa [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 6:59 AM To: Multiple recipients of list ORACLE-L Subject: arg list too long in

Re: Any do's and dont's for a 9i oracle installation on RedHat Linux

I got 9i release 2 running successfully on a RH7.2 and 7.3 system with no install or runtime problems. I also got release 2 to run without any problems on a Mandrake 8.1 and Mandrake 8.2. No surprise since Mandrake is based on RedHat. ltiu On Thursday 29 August 2002 03:08, Docherty, Heather

Re: arg list too long in unix

I'm not sure xargs will work -- it seems to me that since xargs is typically invoked as: 'ls cz* | xargs rm', Nuno is likely to get the same arg list too long error. I think the best way to delete the files would be: 'find . -name cz\* -exec rm -f {} \;' -- Philip - Original Message -

LIST ADMIN: VIRUS Warning: Please Repsond

Hi, I recieved an email today as follows: -- 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 Diego, California-- Public Internet access / Mailing Lists

RE: arg list too long in unix

Title: RE: arg list too long in unix go into the top dir and run find . -name cz-session-* | xargs rm -f or find . -name cz-session-* -exec rm -f {} \; the first runs faster but keep in mind that in other scenarios xargs splits stdin into file names on space and newline.

RE: Maintenance of listener.log files

Thank you for the ideas on maintaining a reasonable size listener.log file. I am trying out the scripts now in development to see which one works the best for me. Bryan -Original Message- Sent: Saturday, August 24, 2002 12:03 PM To: Multiple recipients of list ORACLE-L You can do it

Re: arg list too long in unix

I cant list them using ls -ltr *session* as this string may change. I have to identify the files that srart with cz only. can somebody through somelight on this. man xargs; -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL

Re: Any do's and dont's for a 9i oracle installation on RedHat Linux

Hi Ray, I have Oracle 8.1.7 and 9.0.1 running on an Suse 7.2 box configured with ext3 file systems. Both instances are working properly and without major issues. Suse 7.2 comes along with a variety of file systems , including ReiserFS , ext3 , ext2 , Aix´s JFS and other that I can´t recall

RE: LIST ADMIN: VIRUS Warning: Please Repsond

Got trigger happy, so I'm resending. -Original Message- Sent: Thursday, August 29, 2002 10:11 AM To: DBA List (E-mail); Fat Dba (E-mail) Hi, I recieved an email today as follows: Display name of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD

Sample questions on OCP 8i new features upgrade

Greetings All, In past somebody provided me some sample questions for the OCP test on Oracle 8 to 8i Upgrade(1Z0-020). In the process of rebuilding my desktop, I have lost those. If any of you have any sample questions for this test could you please forward these to me. Or if you know any

Re: Re:RE: Re[2]: controlling CPU usage through Oracle

Dick and Dennis, The application here is the same, where all users are logged in as the same user via the application server. But in my case, I want to throttle all the users who use this id. Wouldn't ORM be beneficial in that situation ? thanks. ed Dennis, You've got

Re: LIST ADMIN: VIRUS Warning: Please Repsond

What are you trying to communicate to us. There is nothing in your mail. [EMAIL PROTECTED] wrote: Hi, I recieved an email today as follows: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services--

Re: AW: Oracle Application Server BUT how about 11i

I'm confused too. What's 11i?? Is this an SAP-like application? How does it tei to 9i DB and 9i AS? Thanks for any input. ltiu Stefan Jahnke wrote: Hi I always thought iAS refers to a whole suite of things. The webserver (which is an Apache in iAS) is one component. But there is more

ROWNUM strangeness?

I've been given a query to investigate. The performance varies extremely depending on whether the entire result set is fetched or a ROWNUM n clause is attached; that makes sense to me. What doesn't make sense is the following: if we add WHERE ROWNUM 50, the query returns 24 rows. If we add

RE: HIPAA compliance and Win2k

Speaking of bashing, you can't watch Larry's presentation without the latest version of Real Player - which is 155M!!! On our T1 that's an hour of download time... what an oinker. If it EVER finishes downloading and (miracle of miracles) the behemoth actually works when installed, I'll be amazed.

Re: LIST ADMIN: VIRUS Warning: Please Repsond

Stop using MS products if you are seriously worried about viruses. [EMAIL PROTECTED] wrote: Got trigger happy, so I'm resending. -Original Message- Sent: Thursday, August 29, 2002 10:11 AM To: DBA List (E-mail); Fat Dba (E-mail) Hi, I recieved an email today as follows:

IMPORT sloooowwww

Oracle 8.1.7 on Solaris 8 I am testing and upgrade from 7.3.4 to 8.1.7. Because the test server is solaris 8, and I can't find the patches for 7 anymore, I am trying to upgrade via an export and import. Besides, the DB is small - less than 2G. The export was done with compress=n. There are

RE: ORA-3120 querying across a DB-Link from a 9i2 db to and

Inka Bezdziecka, oops ... my previously reply wasn't complete and didn't indicate the right context. My apologies if the reply wasn't very clear. As I have logged a TAR with Oracle Support, I was waiting for a reply from Oracle. That is why I put in the line Both are Oracle products and I

Serving BLOB from the database

Hi, I'm sure there has been discussion in the past about the same, but I'm more interested in the feasibility/performance of serving images (stored as BLOB) from the database. 1. For a large multi-tier application (client, web-tier, application, database), with about 5 million records

RE: ROWNUM strangeness?

Post your query -Original Message- Sent: Thursday, August 29, 2002 9:23 PM To: Multiple recipients of list ORACLE-L I've been given a query to investigate. The performance varies extremely depending on whether the entire result set is fetched or a ROWNUM n clause is attached; that

Re: arg list too long in unix

-- Philip Douglass [EMAIL PROTECTED] I'm not sure xargs will work -- it seems to me that since xargs is typically invoked as: 'ls cz* | xargs rm', Nuno is likely to get the same arg list too long error. I think the best way to delete the files would be: 'find . -name cz\* -exec rm -f {}

RE: arg list too long in unix

-- Markham, Richard [EMAIL PROTECTED] find . -name cz-session-* | xargs rm -f This will handle files in 8K chunks; find .. -e will fork for each file. Net result is that xargs is a much better way to go. On a multi-cpu system you can also use xargs -P to run jobs in parallel (at the expense

RE: HIPAA compliance and Win2k

Speaking of bashing, you can't watch Larry's presentation without the latest version of Real Player - which is 155M!!! On our T1 that's an hour of download time... what an oinker. If it EVER finishes downloading and (miracle of miracles) the behemoth actually works when installed, I'll

ROWNUM strangeness?--SOLVED

In my haste, I hadn't noticed that, although the query did not contain an ORDER BY, it did contain SELECT DISTINCT, which causes an implicit ORDER BY. As we all know, ROWNUM is usually assigned when rows are read into the cache, before sorting; thus the order of ROWNUMs in the output is not

Re: IMPORT sloooowwww

Creating grants and synonyms on each table? Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - In looking at how long it takes, the table imports in a second or less, but it takes 3 minutes + to start the import of the next table. I'm not sure what it is doing for 3 minutes

Re: Schedule Statspack Report Creation

On Thu, Aug 29, 2002 at 04:58:22AM -0800, Erik Williams wrote: I have the collections of snapshots scheduled in DBMS_JOBS, but I was looking for a way to automate running of the reports from these snapshots. It looks as though there is no easy way to do this. spreport.sql is an interactive

Re: IMPORT sloooowwww

remove (not disable, REMOVE) constraints and drop indexes and recreate after the import. Change the buffer size on the import as well. Check to see if it is committing after every row. --- Ball, Terry [EMAIL PROTECTED] wrote: Oracle 8.1.7 on Solaris 8 I am testing and upgrade from 7.3.4

Re: ROWNUM strangeness?

Holes in your extents/segments. Normal. You get this after repeated updates/deletes/inserts. ltiu Paul Baumgartel wrote: I've been given a query to investigate. The performance varies extremely depending on whether the entire result set is fetched or a ROWNUM n clause is attached; that

RE: LIST ADMIN: VIRUS Warning: Please Repsond

Gee, that's a helpful reply! As if we have any choice! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Stop using MS products if you are seriously worried about viruses. [EMAIL

Re[2]: Re:RE: Re[2]: controlling CPU usage through Oracle

YES Reply Separator Author: Ed Lewis [EMAIL PROTECTED] Date: 8/29/2002 7:23 AM Dick and Dennis, The application here is the same, where all users are logged in as the same user via the application server. But in my case, I want to throttle

Re: working with datafile 2Gb in HadHat 7.3

What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: 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?

RE: IMPORT sloooowwww

Trace it. www.hotsos.com/dnloads/1/10046a Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Next event: Miracle

Re: LIST ADMIN: VIRUS Warning: Please Repsond

MUM, Eric is listening!!! :-)) On Thursday 29 August 2002 18:08, you wrote: Stop using MS products if you are seriously worried about viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

Re: Report coredump w/r25run -- SOLVED

The unix problem went away with no know cause. The VMS problem turned out to be one of thos absurdly simple fixes. The problem was a comment in the tnsnames.ora file that didn't have a # at the start of the line. Troubleshooting was difficult because sqlplus and the ProC applications worked

Re: Any do's and dont's for a 9i oracle installation on RedHat Linux

good, thanks for the report. I'll get there one day, since RH has been dropped on the floor, apparently. On Thu, Aug 29, 2002 at 07:23:26AM -0800, [EMAIL PROTECTED] wrote: Hi Ray, I have Oracle 8.1.7 and 9.0.1 running on an Suse 7.2 box configured with ext3 file systems. Both

RE: AW: Oracle Application Server BUT how about 11i

Oracle '11i' is E-Business Suite of Applications (yes, SAP like). It uses iAS (which is just a web server) as one of components. It requires two Oracle RDBMS technology stacks: 8.0.6 and 8.1.7 - it is very likely that for the latest release a database itself can be upgraded from 8.1.7 to 9i.

RE: IMPORT sloooowwww

I tried this at your suggestion (though it didn't look like it was analyzing as there were not status on the tables). This didn't help. I even tried turning off archiving and no joy. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent:

Re: IMPORT sloooowwww

Terry, The 3 minutes between table could be because the new database is analysing the tables you are importing. Ron ROR mª¿ªm [EMAIL PROTECTED] 08/29/02 11:23AM Oracle 8.1.7 on Solaris 8 I am testing and upgrade from 7.3.4 to 8.1.7. Because the test server is solaris 8, and I can't find

RE: IMPORT sloooowwww

How many redo log files you have and what are the sizes for these files? Chech the frequency of switch log and also check checkpoint frequency. It looks like the DB has a severe contention problem. What is the size of shared_pool and buffer_cache? Regards, Waleed -Original Message-

Re: working with datafile 2Gb in HadHat 7.3

Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've

RE: IMPORT sloooowwww

This is a good guess. -Original Message- Sent: Thursday, August 29, 2002 1:14 PM To: Multiple recipients of list ORACLE-L Terry, The 3 minutes between table could be because the new database is analysing the tables you are importing. Ron ROR mª¿ªm [EMAIL PROTECTED] 08/29/02 11:23AM

RE: Re:RE: Re[2]: controlling CPU usage through Oracle

Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle Just some thoughts. Does your OS have any domain partitioning features that you can use to create separate servers? You could carve out a portion of the CPU resources into a small domain and dedicate it to your problem child. The

RE: AW: Oracle Application Server BUT how about 11i

11i is a suite of products which include ERP and CRM products. Its called oracle applications and runs on Oracle DB version 8 or higher. Oracle 9i AS(Application Server) is a suite of products which include, Web Server, J2EE server, Forms server and lot of other things 9i DB is database server,

RE: ROWNUM strangeness?

Hi Paul, How's going? Maybe there are other criteria's that limits the result set to only return 24 rows? Richard Ji -Original Message- Sent: Thursday, August 29, 2002 11:53 AM To: Multiple recipients of list ORACLE-L I've been given a query to investigate. The performance varies

RE: Slightly OT: Rounding Negative Numbers

I have to jump in at this point since the arguments for rounding -0.875 to -0.87 just don't seem quite right (I guess I might be Gaussian about this thing). Let me use a different approach to this argument: Value Rounded -0.870 -0.87 -0.871 -0.87 -0.872 -0.87 -0.873 -0.87 -0.874 -0.87

RE: PROCESSING APPROACH - Oracle design issue on Unix

Title: RE: PROCESSING APPROACH - Oracle design issue on Unix Guys, In the past when writing ETL processes for data warehouses I did a lot with scripting on Unix and used SQL for some basic processing. I have been moving more into creating stored procedures and also separately been working

RE: HIPAA compliance and Win2k

Actually, that's what was the 155M - Oracle's version of the latest Real Player. That didn't work, nor did downloading it from the Real Player site directly. I did find out the reason - Real Player doesn't work through our (or any?) corporate proxy server for it's final part of the install

Re: AW: Oracle Application Server BUT how about 11i

Thanks. So does this mean 12i or 13i will be a combo between the Oracle DB and the Oracle E-Biz (can I hear people say integration)? If this happens then SAP is toast! ltiu Inka Bezdziecka wrote: Oracle '11i' is E-Business Suite of Applications (yes, SAP like). It uses iAS (which is just a

Re: ROWNUM strangeness?

Actually. Scratch my previous email on this matter. We have seen this problem before and I couldn't figure out how to fix it. ltiu Paul Baumgartel wrote: I've been given a query to investigate. The performance varies extremely depending on whether the entire result set is fetched or a ROWNUM

RE: IMPORT sloooowwww

and indexes, too! do the indexes, constraints, grants, etc after the table data imports! -bill -Original Message- Sent: Thursday, August 29, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Creating grants and synonyms on each table? Cheers Nuno Souto [EMAIL PROTECTED] -

RE: ROWNUM strangeness?--SOLVED

As we all know, ROWNUM is *usually* assigned when rows are read into the cache, before sorting; Always -- 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

Re: ROWNUM strangeness?

Paul Baumgartel wrote: I've been given a query to investigate. The performance varies extremely depending on whether the entire result set is fetched or a ROWNUM n clause is attached; that makes sense to me. What doesn't make sense is the following: if we add WHERE ROWNUM 50, the query

RE: LIST ADMIN: VIRUS Warning: Please Repsond

You always have a choice. Sometimes it is difficult to make the right choice. Consider a high school student who is doing poorly -- they can make the easy choice and drop out or they can make the difficult choice and work harder. In the case of M$, the easy choice is to accept whatever M$

RE: ROWNUM strangeness?

Title: RE: ROWNUM strangeness? show the full sql please, perhaps its how you are grouping your conditions Paul Baumgartel wrote: I've been given a query to investigate. The performance varies extremely depending on whether the entire result set is fetched or a ROWNUM n clause is

Oracle 9i Rel1 on SuSE 8.0 Pro

Help!!! I have load the oracle 9i Database on my Linux Server running SuSE 8.0 Pro. The installation went fine, but the database keeps getting corrupted data blocks. Does anybody know why this keeps happing. I had thing running before and then I had a disk drive crash. 30.7 gig drive).

RE: import question

Do not believe him :) -Original Message- Sent: Monday, July 29, 2002 10:38 AM To: Multiple recipients of list ORACLE-L If the Export has been taken with DIRECT = Y, meaning that the SQL Evaluation buffer has to be bypassed then Import would not generate the Redo buffer while

Hot Backup scripts UNIX

I am looking for a hot backup script that has been successfully used on UNIX(Solaris). Wouldn't mind using the Velpuri scripts, but they seem a bit complicated and we have had some issues trying to actually implement them. Would really appreciate seeing what other people are using. Also would

RE: IMPORT sloooowwww

Put the table in NOLOGGIN. -Message d'origine- De: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Date: jeudi 29 août 2002 18:58 À: Multiple recipients of list ORACLE-L Objet: Re: IMPORT sl remove (not disable, REMOVE)

RE: IMPORT sloooowwww

Here is a most excellent post from Kirti Deshpande, [EMAIL PROTECTED] earlier on some import / export principles that may help you. If you like it, pass on your thanks to him. PEACE. Mike Prepare scripts to build tables, indexes and constraints etc.. Prebuild the tables in the target database.

RE: ROWNUM strangeness?

Paul, It's because of how ROWNUM is interpreted. The first query only returned the first 50 rows it found and you got 24 that passed the rest of your criteria. The second query returned 1000 rows of which only 336 passed the rest of your criteria. Makes perfect sense to me. This is why

Re: Oracle 9i Rel1 on SuSE 8.0 Pro

My first suggestion would be to try release 2. Second suggestion is that your new hard drive is defective. ltiu Joe A Cairns wrote: Help!!! I have load the oracle 9i Database on my Linux Server running SuSE 8.0 Pro. The installation went fine, but the database keeps getting corrupted data

Identify unused indexes in 8i ?

All, Is there a way to identify unused indexes in Oracle 8i. I know that it is easy to check with 9i. I would appreciate if you could share your experience (or ideas) with me. Thanks, Bob __ Do You Yahoo!? Yahoo! Finance - Get real-time stock

ORACLE UP/DOWN scripts

Hi Does some one have DB down script on Sun solaris.I mean to say if instance down I will get page . Thx -Seema _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ:

Re: working with datafile 2Gb in HadHat 7.3

It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups

Failsafe and OEM automatic discovery

Title: Failsafe and OEM automatic discovery I am running OEM and OMS 9.0.1 on WIN2000 and am having ptoblems discovering databases on a two server Oracle Failsafe cluster. I am running Failsafe 3.3.1 on a two node cluster. Database DB1 on node 1 (cluster group GRP1) Database DB2 on node 2

Re: ROWNUM strangeness?

I believe you have ROWNUM confused with ROWID. --- ltiu [EMAIL PROTECTED] wrote: Holes in your extents/segments. Normal. You get this after repeated updates/deletes/inserts. ltiu Paul Baumgartel wrote: I've been given a query to investigate. The performance varies extremely

Re: LIST ADMIN: VIRUS Warning: Please Repsond

Linux or MacOSX are good alternatives for the end user. ltiu kkennedy wrote: You always have a choice. Sometimes it is difficult to make the right choice. Consider a high school student who is doing poorly -- they can make the easy choice and drop out or they can make the difficult choice

RE: ROWNUM strangeness?

Actually, ROWNUM has nothing to do with extents/segments/inserts/updates/deletes. It is all about access paths. The solution posted makes sense as ROWNUM can be affected by many subsequent operations. -Original Message- Sent: Thursday, August 29, 2002 11:04 AM To: Multiple recipients of

RE: AW: Oracle Application Server BUT how about 11i

It has always been. SAP is just one of ..., as is Oracle - and none will go away for the foreseen future. The common competitor is, or would like to be, Microsoft with its acquisition of Great Plains. -Original Message- Sent: Thursday, August 29, 2002 1:54 PM To: Multiple recipients

RE: ROWNUM strangeness?--SOLVED

To be exact... Rownum is sequentially assigned for each row that meets the predicate. If the row does not match the predicate condition, it is discarded and not assigned a rownum. Below is an example using our friendly EMP table. As for sorting, rownum is assigned before any sorting. However,

Re: arg list too long in unix

Quite true, but ironically enough, the xargs manpage (on my system as well as many others) only has examples using ls to feed xargs. I meant to end the exec param with \+ instead of \; which aggregates a set to operate on. I'm not clear on whether that means one giant set, or several smaller

SQL-2100 in Pro*C program

I guess this is my day to post questions to the list. Does anyone have any ideas on how to diagnose and fix SQL-2100 (aka ORA-2100)? The manual says ORA-02100 PCC: out of memory (i.e., could not allocate) Cause: SQLLIB was unable to allocate enough memory to execute the program. Action:

RE: Oracle 9i Rel1 on SuSE 8.0 Pro

As a WAG... is your blocksize compatible with the Linux filesystem?? I don't understand how the OS version has a play in Oracle giving you support. If you are paying for a legitimate license then I don't see how its and issue. Maybe you can post to the suse-oracle list

RE: PROCESSING APPROACH - Oracle design issue on Unix

Title: RE: PROCESSING APPROACH - Oracle design issue on Unix Paula, Your approach is fine. The bigger question that your organization needs to ask is - if you leave, can they support it - do they have adequate staff on hand that can maintain PL/SQL code? I agree with you that PL/SQL can

Re: ROWNUM strangeness?

I agree. I got confused and my second email to disregard my erroneous first emai on this matterl was apparently shot down by the mail filters so it never got to you guys in time. Sorry for the confision. ltiu Fink, Dan wrote: Actually, ROWNUM has nothing to do with

  1   2   >