RE: date format ?

Just something to consider, if he goes ahead with this request: How would you distinguish between the 11 of February 1999 ( 1121999 ) and the 1st of December 1999 ( 1121999 )? If he is prepared to enter both digits of the month (at least) then this could result ion a non-ambigous date - my

RE: SQLLDR - whitespace (tab space) problem

Try something like the lines below, as 9 is the ASCII code for a TAB : load data infile * INTO TABLE experiment_with_tab_delimiter FIELDS TERMINATED BY X'9' (textcol1, textcol2) BEGINDATA Saj -Original Message- From:

ORA - 1008 error when trying to insert data into a table

We are having a table TestSite with the following fields. NameNull? Type - PK_SITE_ID NOT NULLNUMBER FK_CATEGORY

RE: Real-life Stand-by DB implementation stories?

I have got a question about Data Guard: Do you have to have Enterprise Edition for it to work? We did not use Managed Standby Database functionallity, because it needed Enterprise Edition licence - and it meens a huge extra cost. Docs just say 8.1.5 or higher and UNIX. I checked with

Re: Change email address

You need to UNSUB the list under your old email and SUBSCRIBE to the list under the new. The instructions for doing this are at the end of EVERY email you get from the list. [EMAIL PROTECTED] 04/29/01 11:30PM Hi list member, How do I change the email address in this list so it will send the

FILE SYSTEM BUFFER IN JFS : ON OR OFF

Hi List , I posted this on friday but didn't see it on the list so I am posting this again . I am redesigning a major system and particular attension is being given to filesystem configuration and IO . I got this from one supposedly top notch Unix performance tuning expert . I would like to know

RE: SQLLDR - whitespace (tab space) problem

Great! That works too. Now I can do it (modify the data) from either Shell script or control file. Thanks for all the input. Saj Raza [EMAIL PROTECTED] wrote: Try something like the lines below, as 9 is the ASCII code for a TAB :load datainfile *INTO TABLE experiment_with_tab_delimiterFIELDS

RE: Real-life Stand-by DB implementation stories?

i have a licensing question, say we've brought power units meaning we can support unlimited users against one solution what if any are the implications of switching to named users? === Lerone Streeter System Analyst Abbott LBG [EMAIL PROTECTED]

RE: Change email address

Then the old listing is the problem of your previous company. [EMAIL PROTECTED] 04/30/01 11:20AM what if you do not have access to your old email account anymore? -Original Message- Sent: Monday, April 30, 2001 8:00 AM To: Multiple recipients of list ORACLE-L You need to UNSUB the

RE: Could not Connect to 8.1.6

Do you have a brain? A little harsh I feel.. -Original Message- Robert Sent: Sunday, April 29, 2001 01:10 To: Multiple recipients of list ORACLE-L Do you have a brain? -Original Message- Sent: April 28, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Did you update

ORA-07445

Hello All This message is appearing in the alert log periodically.. anyone know hat it means and how I can get rid of it ORA-07445: exception encountered: core dump [kkects()+64] [SIGSEGV] [Address not mapped to object] [8] [] [] Thanks -- Sajid Iqbal Database Team Leader -- Please see

Re: FILE SYSTEM BUFFER IN JFS : ON OR OFF

If you get useful replies to this ( not like this one ) please post to the list. This looks interesting. Jared On Monday 30 April 2001 08:05, Raj Sakthi wrote: Hi List , I posted this on friday but didn't see it on the list so I am posting this again . I am redesigning a major system and

RE: OT: Reading the Oracle Tea Leaves

I liked that book, it is concise and to the point. No fluff No 800+ pages just for marketing purposes. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch

RE: Help - temp tablespace growing constantly

No but, when I turned it off it kept running out of space. -Original Message- Sent: Friday, April 27, 2001 4:33 PM To: Multiple recipients of list ORACLE-L Does the temp tablespace has it's autoextend turned off? [EMAIL PROTECTED] 04/27/01 04:55PM Under this situation try to offline

Re: Change email address

Then don't worry about it. If your old account is gone from the system, then your mail will start bouncing and ListGuru will remove your account from the list. If you're really pedantic, you can just email the old address to me, and I can remove it for you. :) Jared On Monday 30 April 2001

RE: Change email address

what if you do not have access to your old email account anymore? -Original Message- Sent: Monday, April 30, 2001 8:00 AM To: Multiple recipients of list ORACLE-L You need to UNSUB the list under your old email and SUBSCRIBE to the list under the new. The instructions for doing this

Oracle client for the desktop/Win 2000. Need help with which version.

Hi Listeners, Do you recommend the latest version of the Oracle client for the desktop? Our current standard is Oracle 8.0.5. In preparation for Windows 2000, we would like to migrate to a new version sometimes this year. Is there a version you suggest we look at? Thanks in advance, Charles

RE: OT: Reading the Oracle Tea Leaves

Oracle8 UNIX Performance Tuning by Alomari is probably the one you're talking about. -Original Message- Sent: Saturday, April 28, 2001 12:05 AM To: Multiple recipients of list ORACLE-L If you want to tune SQL, get Guy Harrisons book on tuning Oracle SQL. It is the best document

Re: FILE SYSTEM BUFFER IN JFS : ON OR OFF

What flavor of UNIX and what type of storage are you considering? Regards, David A. Barbour Raj Sakthi wrote: Hi List , I posted this on friday but didn't see it on the list so I am posting this again . I am redesigning a major system and particular attension is being given to

estimate of deleted data???

Hi Friends How can I estimate the how much data was deleted from a table correctly?? I have massive table from that application team will delete according to their invoices closing. So Is it better to take snapshot that table before and after deletion of data?? Is there any other better way to

RE: Could not Connect to 8.1.6

I would agree, little harsh. -Original Message- Sent: Monday, April 30, 2001 11:11 AM To: Multiple recipients of list ORACLE-L Do you have a brain? A little harsh I feel.. -Original Message- Robert Sent: Sunday, April 29, 2001 01:10 To: Multiple recipients of list ORACLE-L Do

Re: parallel load performance

This is great info from you as usual. I am using one controller on top of a T1 raid array. I'll recreate the tablespaces with direct IO files, and see how it goes. It's a test system, so I can do what I want with it. Thanks, Dave On Fri, Apr 27, 2001 at 08:09:22PM -0700, Jared Still wrote:

RE: ORA-07445

Title: RE: ORA-07445 likewise... just started today on one 8.1.6.2 database on Solaris 2.6 -Original Message-From: DEMANCHE Luc (Cetelem) [mailto:[EMAIL PROTECTED]]Sent: Monday, April 30, 2001 11:56 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-07445 Hi, I

ORA-07445: exception encountered: core dump [kxsdmp()+188] [SIGBU

Hi, One of our databases has just started producing the following errors over the weekend... Errors in file /Volumes/app/oracle/admin/dmps_tst/udump/dmps_tst_ora_16040.trc: ORA-07445: exception encountered: core dump [kxsdmp()+188] [SIGBUS] [Invalid address alignment] [1679844977] [] []

MySQL to Oracle conversion

Dear Listers: Does anyone know any good tools or ways to convert MySQL database to Oracle database ? TIA Kevin Tsay SiteSmith, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Tsay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

JFS Options

ORA-24347 (null column in aggregate function) - SQL*Plus 8.1.6 to

Title: ORA-24347 (null column in aggregate function) - SQL*Plus 8.1.6 to 8.0.5 database I'm a little stumped. I'm using SQL*Plus 8.1.6.0.0 client to connect to an Oracle 8.0.5 database on a Windows NT server. I want to get the count of objects for each user, with a 0 count for users without

transaction recovery error

My 8.1.7 DB on Solaris 2.7 is throwing trace files about every five minutes. The alert log entries say: SMON: Parallel transaction recovery slave got internal error Mon Apr 30 12:17:32 2001 Errors in file /oracle/admin/ipdevla/bdump/ipdevla_smon_8665.trc: ORA-00600: internal error code,

RMAN Backup Size

DBAs I have taken hot backup using RMAN. The total Size of the Database is 5200MB(By Sum(byes) in Dba_data_files). Where us the backup file size put together is 4600MB. Where am I missing the remaining 600MB? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Re: Change email address

Ugly boy? - Scott's wife's name is Mindy - Majored in education at Kansas - His first car was a 1972 Cadillac - Wears a size 19 basketball shoe - Height: 6-11 / 2,11 - Weight: 265 lbs. / 120,2 kg. http://www.nba.com/playerfile/scot_pollard/index.html?nav=page -

RE: Oracle client for the desktop/Win 2000. Need help with which

Charles, For Win2K...Oracle only supports the 8.1.6 Client or higher. We've standardized on the 8.1.6 Client for our Corporate-wide rollout of the Oracle Client utilizing Oracle Names for DB name resolution. Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Monday,

RE: MySQL to Oracle conversion

Kevin, Yes, use Oracle Migration Workbench http://technet.oracle.com/tech/migration/ Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Monday, April 30, 2001 2:15 PM To: Multiple recipients of list ORACLE-L Dear Listers: Does anyone know any good tools or ways to

RE: ORA-07445: exception encountered: core dump [kxsdmp()+188] [S

Oracle Product Document Library(C) Oracle Corporation Manual: ORACLE 8.1.5 SERVER CODES Reference: A67785-01 ORA-07445 exception encountered: core dump [string] [string] [string] [string] [string] [string] Cause: An operating system exception occurred which should result in the

Windows vs. UNIX

this is not to bring up a heated debate over the two platforms... I am making a proposal to move the current access 97 databases to an oralce platform running solaris I would like to put in the proposal a brief reason why a UNIX platform will be better than a Windows platform. the

RE: ORA-07445

Title: RE: ORA-07445 I searched my old emails. I had this error once on Oracle 7.3.4 on Solaris 2.6 or 2.7 back in January 1998. In my case, the solution had something to do with setting EPC_DISABLED=TRUE in the users and oracle's .profile, plus adding a line to the listener.ora, indicating

Re: RMAN Backup Size

Rman backs up only used blocks, so the size difference Johnson --- Raj Gopalan [EMAIL PROTECTED] wrote: DBAs I have taken hot backup using RMAN. The total Size of the Database is 5200MB(By Sum(byes) in Dba_data_files). Where us the backup file size put together is 4600MB. Where am I

RE: Pinning Packages Question

Thanks for your reply. It is a continous learning process. I am pinning objects in Oracle Financial as well as Dataware House database. For Oracle Fiancials pinned objects stays but in Dataware House because of application , objects are dropped and recreated, hence pinned objects are reloaded

Re: ORA-07445

Hi, ora-7445 error are not always OS errors. If Oracle can not catch exceptions(ORA-600), OS catch and Oracle throws ORA-7445. If possible, attach trace file. let's examine it. regards... Sajid Iqbal wrote: Hello All This message is appearing in the alert log periodically.. anyone know

Re: RMAN Backup Size

Hi, It's all O.K., blocks that never been used aren't backuped by rman. oli [EMAIL PROTECTED] wrote DBAs I have taken hot backup using RMAN. The total Size of the Database is 5200MB(By Sum(byes) in Dba_data_files). Where us the backup file size put together is 4600MB. Where am I missing

Re: Windows vs. UNIX

Hi Roy There was whitepater on this, I forgot exact name, May be other members have it!! The paper name looks like ux-vs-nt!! I read once!! From: Roy Ferguson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Windows vs. UNIX

Re: FILE SYSTEM BUFFER IN JFS : ON OR OFF

The Unix is HP-UX 11.0 64 bit Storage is XP 256 The point to note is , we are concerned about the filesystem which happens to be Veritas filesystem and the mount options available in that . --- David A. Barbour [EMAIL PROTECTED] wrote: What flavor of UNIX and what type of storage are you

RE: Help - temp tablespace growing constantly

If you have the autoextend off, you might run out of space in your temp tablespace. If you have autoextend on, your temp file will keep growing. If you have a reasonably sized tablespace, you might want to look at the queries or index creations. How big is your entire database and how large is

Re: RMAN Backup Size

I believe that RMAN only backs up blocks that have been allocated to an oracle object - index, segment, table, etc. If the block is in a datafile but not in use by an oracle object (that is, the block is free), then RMAN doesn't backup those blocks. Steve [EMAIL PROTECTED] 04/30/01 12:25PM

RE: FILE SYSTEM BUFFER IN JFS : ON OR OFF

Hi Raj, Unless your 'db_block_size' is 8192 then you should use direct I/O for all Oracle file systems regardless of usage. Also because Oracle explicitly requests synchronous I/O whenever it opens its datafiles, it is the convosync mount option that counts, rather than the mincache one. Indeed,

RE: Windows vs. UNIX

Try http://www.unix-vs-nt.org/ http://www.unix-vs-nt.org/ Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes

Re: ORA-24347 (null column in aggregate function) - SQL*Plus

Looks like you have user with no objects. Try count(*) instead of count(object_name); [EMAIL PROTECTED] 04/30/01 02:25PM I'm a little stumped. I'm using SQL*Plus 8.1.6.0.0 client to connect to an Oracle 8.0.5 database on a Windows NT server. I want to get the count of objects for each user,

Re: transaction recovery error

Not good news from my source: POSSIBLE CORRUPTION Versions: 7.3.x, 8.0.x, 8.1.x Attempting to back out an undo record and cannot find a corresponding sys.ts$ entry generating this exception. Suggestion: Attempt to rebuild the database, or restore from a valid backup and rollforward to a

Re: ORA-07445: exception encountered: core dump [kxsdmp()+188]

This sounds like a heap (memory) error. Check for system memory errors. [EMAIL PROTECTED] 04/30/01 01:40PM Hi, One of our databases has just started producing the following errors over the weekend... Errors in file /Volumes/app/oracle/admin/dmps_tst/udump/dmps_tst_ora_16040.trc:

RE: Help - temp tablespace growing constantly

Yeah If you don't have correct planning on temp segments and their growth you may be facing problems!! I have 150G size of database having 1.5G temp space. I saw may be one or two times run out of temp space. That time too just wakeup smon to clear the temp segments..problem solved. From:

RE: ORA-07445: exception encountered: core dump [kxsdmp()+188]

All, The oracle support rep came to the same conclusion. After a reboot the database came back to life without error. I guess we will have to perform some follow-up memory and hardware tests to try and find the root cause. Ken. -Original Message- Sent: Monday, April 30, 2001 4:11 PM

Re: Windows vs. UNIX

Read the Note:45967.1 in Metalink (20 DIFFERENCES BETWEEN ORACLE ON WINDOWS NT AND ORACLE ON UNIX ) Leonardo Fernández Oracle DBA Roy Ferguson [EMAIL PROTECTED]@fatcity.com on 30/04/2001 07:45:51 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple

RE: Help - temp tablespace growing constantly

The temp tablespace started at 1G and grew to 29G before croaking, we have the same software running on older oracle versions without incuring the temp creep. -Original Message- Sent: Monday, April 30, 2001 2:46 PM To: Multiple recipients of list ORACLE-L If you have the autoextend

redo size and log_checkpoint_interval

Dear DBA I have 130 gb database running on 7/24 basis. redo logfile size is 40mb and oracle create about most to 400 archivive log. that mean log switch happend at 3-4 min at peak time. As oracle suggest, it is better log switch between 30min. (Why, if so that need more recovery time?) If I

RE: Windows vs. UNIX

Thanks to those who responded so quickly. I have all the needed information to make a case... roy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Roy Ferguson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: Windows vs. UNIX

Roy, Forgive me my lack of understanding, but if you don't know why one would choose Unix over Windows, why are you proposing Unix altogether? Yosi -Original Message- From: Roy Ferguson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 2:46 PM To: Multiple recipients of list

RE: Windows vs. UNIX

this information is actually a proposal that I created for a college course I'm taking...I have a lot of experience with UNIX and very little with Windows...that's why I only needed the facts and no opinions... Roy, Forgive me my lack of understanding, but if you don't know why one would

RESOURCE role

Listers, 8.0.6 What privilege granted to the RESOURCE role allows a grantee to create a table in any tablespace? I didn't see any relevent system privilege in the view DBA_SYS_PRIVS nor in the various other view. Am I looking in the wrong place? Thanks, Mike Hand Polaroid Corp. -- Please see

Re: redo size and log_checkpoint_interval

Primary reason not to switch more often then 30 minutes to 1hour, is to reduce the checkpointing frequency. If you switch every 3 to 4 minutes, then waits for checkpoint related activity will be higher. Hence you may want to increase the log file size and also set your log_checkpoint_interval,

Re: Windows vs. UNIX

Roy, Don't make too much of that note from Metalink mentioned in another post. It's 4 years old! A lot has changed since then. This doesn't mean I've warmed up to MS, but you don't want to bring that document to a meeting. :) Here's two of my favorite reasons for using Solaris over NT: 1.

RE: ORA-24347 (null column in aggregate function) - SQL*Plus

Title: RE: ORA-24347 (null column in aggregate function) - SQL*Plus -Original Message- From: Tim Sawmiller [mailto:[EMAIL PROTECTED]] Looks like you have user with no objects. Try count(*) instead of count(object_name); I don't think so Tim. If I said count (*) my query below

NOLOGGING creates txns in redo/archive logs

I have been testing logminer and noticed that when I alter a table to NOLOGGING, txns are still recorded in the redo/archive logs. I thought NOLOGGING was NOT supposed to do this. Anyone know if this is expected behavior? At a recent 8i new features class, I explicitly asked the

RE: Windows vs. UNIX

Another reason might be that I have Oracle on a Sun Solaris server and in the last four years, the only time it has gone down is for hardware upgrades and power outages (manually after the building UPS ran down). I don't want to get in a screaming war with all the Bill Gate lovers out there,

RE: redo size and log_checkpoint_interval

Mitchell, if ur current Log_checkpoint_interval is 2097152 (20 mb) then is ur os block size = 20 mb/2097152 = 10 bytes? look like is ur want to say that Log_checkpoint_interval = 20971520 but Log_checkpoint_interval shld be set ito OS blocks. so if u want to set to 20 mb then assuming ur os

RE: RESOURCE role

Title: RE: RESOURCE role -Original Message- From: Hand, Michael T [mailto:[EMAIL PROTECTED]] Sent: lundi, 30. avril 2001 14:42 To: Multiple recipients of list ORACLE-L Subject: RESOURCE role Listers, 8.0.6 What privilege granted to the RESOURCE role allows a grantee to

Re: RESOURCE role

On Monday 30 April 2001 15:25, Jacques Kilchoer wrote: The RESOURCE role is created via $ORACLE_HOME/rdbms/admin/sql.bsq You can look at that file, or you could query DBA_ROLES DBA_ROLE_PRIVS DBA_SYS_PRIVS DBA_TAB_PRIVS DBA_COL_PRIVS Choosing a tablespace for a segment, however, is

Forms 6i - Java Bean (Org Chart)

Listers, Users are desiring an org chart representation of data. Forms 6i Web Deployed (9iAS 1.0.2, 8.1.7, HP-UX, Forms 6i Patch2). One thought is to use a Java Bean since Forms 6i supports those. I have no problem doing a google search and digging up a few Java Beans that say they will do it,

Re: RESOURCE role

Hi Unlimited tablespace privilege is granted with resource role. This privilege is granted directly to the user rather than through the resource role. Hence you won't see this in dba_sys_privs view. Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com

Fwd: Re: RESOURCE role

Resent due to mail problem: It's 'unlimited tablespace', and it's granted directly to the user account when you grant 'resource'. Whenever you grant the resource role, you should immediately revoke 'unlimited tablespace' from that user. Better yet, create a new role, and don't use

Oracle-L Email Server outage

Folks, The list was down for a few hours today due to a hardware problem upstream from fatcity.com. Seems to be fixed now. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re[2]: RESOURCE role

I don't know about the rest of you, but whenever I create a new instance one of th first things that gets done is to drop the resource role. I also get rid of Connect too. Dick Goulet -- Reply Separator -- Author: Jared Still [EMAIL PROTECTED] Date:

RE: RESOURCE role

Title: RE: RESOURCE role -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Granting RESOURCE to a user results in UNLIMITED TABLESPACE being granted directly to the user account. Jared is correct. I sent another e-mail adding that but it didn't go through (mail

RE: RESOURCE role

Granting RESOURCE will grant unlimited tablespace privilege. They will then be able to create a table in any valid tablespace. One way to see what privileges are granted by resource is to grant it, connect as the user it was just granted to and do a select * from session_privs; To find the