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
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:
We are having a table TestSite with the following fields.
NameNull? Type
-
PK_SITE_ID NOT NULLNUMBER
FK_CATEGORY
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
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
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
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
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]
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
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
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
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
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
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
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
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
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
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
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
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
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
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:
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
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] [] []
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
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
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,
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
--
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
-
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,
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
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
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
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
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
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
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
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
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
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
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
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
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,
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
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,
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
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:
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:
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
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
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
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
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,
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
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
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
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,
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.
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
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
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,
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
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
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
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,
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
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
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
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:
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
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
72 matches
Mail list logo