Title: RE: Purging Managed Standby Database Archive Logs
Hello Steve
If you are on 9.2 you can use utl_file.fremove directly
from the sql.
Yechiel AdarMehish
- Original Message -
From:
Orr, Steve
To: Multiple recipients of list ORACLE-L
Sent: Thursday, December 12,
If you use tools from Borland like Delphi, C++ Builder or Kylix
http://delphi.about.com/library/weekly/aa112902a.htm
JP
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jan Pruner
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Quick question, has anyone managed to sucessfully install 8.1.7 on Windows XP
Home Edition. I have read on metalink that this is not officially supported by
Oracle, but wanted to know if anyone has managed to install it for test
purposes on their home/work PC's
tia
Zabair
--
Please see the
The article below has produced more feedback
than any of the others I have written, so I thought
I'd share it with Oracle-L
http://www.jlcomp.demon.co.uk/tar.html
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost Based Optimisation
(see
Disclaimer: I'm a messaging security guy. What I don't know about Oracle
would fill an entire row of bookshelves.
Nonetheless, I¹m trying to install OCS 9.0.2.0 on Red Hat Advanced Server
2.1. When I install the OCS infrastructure components, the install completes
normally, then OUI fires off a
I had to download and install the following packages to get the installer
running.
compat_glibc-6.2-2.1.3.2.i386.rpm
compat_libs-6.2
compat_egcs-6.2
to get the installer running.
Thanks
Sumathy
-Original Message-
Sent: Thursday, December 12, 2002 8:59 AM
To: Multiple recipients of
Title: RE: OT - change in Oracle's marketing strategy
ROTFL ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod
I remember in OS/2 magazine years ago, they were talking about the uneasy
relationship between Borland and Microsoft.
Philippe Kahn and Bill Gates were not chummy, to say the least.
I haven't worked with Delphi, but Turbo Pascal for Windows seemed incredible
to me, they had an object-oriented
LOL!!!
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 16, 2002 7:23 AM
The article below has produced more feedback
than any of the others I have written, so I thought
I'd share it
Is it possible to Create a Locally partitioned Index in a Tablespace Different from
the Base Table Tablespace ?
Base Table being RANGE Partitioned
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network Services--
More info needed.
But see if you can ping the mail server.
Make sure you are actually using the mail server you think you are and not
solaris's sendmail.
Try putting MS exchange host and IP in /etc/hosts
On Sun, 15 Dec 2002, Don wrote:
we are stumped.
We have installed OEM 9.2, the console,
Title: RE: Locally Partitioned Index
Like this?
CREATE INDEX vegas_mart_date_of_sale_idx
ON vegas_mart (date_of_sale, julian_run_date)
local
tablespace lrg_index_a
/
base table partitions reside in 3 different tablespaces.
Lisa Koivu
Oracle Databonehead Administrator
Fairfield
Vivek - I don't think that should be a problem. Just specify the desired
tablespace in your CREATE INDEX statement. Here is a good article on
creating partitioned indexes.
http://www.oracle-base.com/Articles/8i/PartitionedTablesAndIndexes.asp
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL
Specify the TABLESPACE clause for the index globally (i.e.
outside all partition clauses) or individually for each
partition. This can be done for all partitioning methods
(i.e. RANGE, HASH, or LIST) and composites (i.e. RANGE-HASH
and RANGE-LIST)...
Is it possible to Create a Locally
Yes. Check the complete syntax options for CREATE INDEX command.
- Kirti
-Original Message-
Sent: Monday, December 16, 2002 7:59 AM
To: Multiple recipients of list ORACLE-L
Is it possible to Create a Locally partitioned Index in a Tablespace Different from
the Base Table Tablespace
Thanks for the where clause and to all who respond,
I'll check into fine grained access control
(dbms_rls).
--- Khedr, Waleed [EMAIL PROTECTED] a écrit :
Add this to where clause:
group decode(user,'typical',380,-100)
Instead of -100 use any number not used by the
groups.
Also read
The following was an actual bug in Oracle's bug database;
doesn't seem searchable anymore and has likely been archived
recently, for some reason.
Please note that the bug has been open for over 8 years and
that all lines preceded with @ are intended to be censored
for viewing by Oracle
List,
Is there a 'magic' number for num_rows that you use in order to set the parallel
degree on tables and/or indexes?
We were told to use parallel degree of 4 for tables having more than 100,000 rows.
Some of the on-line queries are running in parallel mode thus making batch jobs to go
Title: RE: New course for 9i - Dumps/Crashes from Oracle University
What
is the world coming to?
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Friday, December 13, 2002
5:44 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: New course for
Title: alert log suppression
Is it possible to suppress successful DDL within the alter log?
For example, I have a cron job that coalesces 300+ tablespaces
which creates a couple line entry for each. I would like to
get feedback only if the DDL has actually failed.
TIA
Vivek,
Yes.
There is no restriction whatsoever in the tablespace where an index or its
partitions can be created and there is no relationship to the tablespace of
the base table. Just as you could create an index in a tablespace different
from that of the table, you could create any index
List,
Does anybody know a Sun Solaris e-mail list/forum that's useful like this
one is for Oracle?
thanks,
David Ehresmann
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ehresmann, David
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Title: RE: DUAL
Careful. We are listening.
;-)
(that woulda messed me up for a while)
-Original Message-
From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 12:04 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DUAL
Thanks
Title: RE: Sun Solaris
sunhelp.org for general.
sunmanagers.org for critical. requires summary post and is more restrictive.
-Original Message-
From: Ehresmann, David [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 10:59 AM
To: Multiple recipients of list ORACLE-L
Title: RE: New course for 9i - Dumps/Crashes from Oracle University
Nowhere in particular ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that
Go to this page and join the SOLARIS-L list.
http://www.openitx.com/nav/t.asp?t=507p=607h1=507h2=571h3=607
This page has a bunch of other OS lists as well.
-Original Message-
Sent: Monday, December 16, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L
List,
Does anybody know a
Try this:
http://unix.ittoolbox.com/
Gillian
"Ehresmann, David" [EMAIL PROTECTED] wrote:
List,Does anybody know a Sun Solaris e-mail list/forum that's useful like thisone is for Oracle?thanks, David Ehresmann-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ehresmann,
Title: RE: Oracle 8i (8.1.7) for Windows XP Home Edition
Didn't try 8.1.7, but 9i went in just fine.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 3:54 AM
To: Multiple recipients of list ORACLE-L
Subject: Oracle 8i (8.1.7)
List,
Does anybody know a Sun Solaris e-mail list/forum that's
useful like this
one is for Oracle?
Try
http://www.sunhelp.org/mailman/listinfo/sunhelp
Eddie Watkins
The Moray Council
email: [EMAIL PROTECTED]
tel: 01343 563247
The Moray Council: Internet E-mail Notice
The obvious question being why you are coalescing
tablespaces
--- Markham, Richard [EMAIL PROTECTED]
wrote: Is it possible to suppress successful DDL
within the
alter log?
For example, I have a cron job that coalesces 300+
tablespaces
which creates a couple line entry for each. I would
Title: RE: New course for 9i - Dumps/Crashes from Oracle University
There
will probably be others in the series... Looks like one of the 8i
Internals seminars has made it to 9i!
Patrice Boivin Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et
Exploit. des
Title: RE: Parallel degree on tables and indexes
Govind,
a statement like 'use parallel = 4 for tables over 100,000 rows' is like saying drive to Iowa, go that way.
The parallel degree should at least take into account the resources on your box. It can be larger than the number of CPU's
SunHelp. Oddly enough, when I asked _them_ for a list just like theirs, but
for Oracle, they directed me to Oracle-L..
http://www.sunhelp.org/lists.php
Also useful for the knowledge of all things geeky are Recsue and Geeks, same
page.
~brian
-Original Message-
Sent: Monday,
David,
http://www.sunmanagers.org/
HTH
Barry
-Original Message-
Sent: 16 December 2002 15:59
To: Multiple recipients of list ORACLE-L
List,
Does anybody know a Sun Solaris e-mail list/forum that's useful like this
one is for Oracle?
thanks,
David Ehresmann
--
Please see the
This one is good: http://www.sunmanagers.org/mailman/listinfo/sunmanagers.
-bill
At 07:58 AM 12/16/2002 -0800, you wrote:
List,
Does anybody know a Sun Solaris e-mail list/forum that's useful like this
one is for Oracle?
thanks,
David Ehresmann
--
Please see the official
Ah, yes...the magic number. For all questions requiring a magic number, that
number is 42. ;)
-Original Message-
Sent: Monday, December 16, 2002 8:39 AM
To: Multiple recipients of list ORACLE-L
List,
Is there a 'magic' number for num_rows that you use in order to set the
parallel
Title: RE: alert log suppression
ok. They are LMT's with PCTINCREASE 0. I'm running 8.1.7.4 and
I believe that SMON requires PCTINCREASE 0 to do routine
coalescing.perhaps you have further to add to your post.
-Original Message-
From: Connor McDonald [mailto:[EMAIL
Title: RE: alert log suppression
Richard,
If you are using UNIFORM extents (which is usually the best
option),you don't need to do any coalescing on LMTs.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Markham, Richard
To: Multiple recipients of list
Title: RE: alert log suppression
Coalescing LMTs is unnecessary !
-
Kirti
-Original Message-From: Markham, Richard
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002
12:00 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: alert log suppression
ok. They are LMT's with
Title: Message
Thanks
for the info Igor. In addition to thisI am curious of how to
determine that a given TS's extents are UNIFORM. dba_tablespaces shows
allocation_type of user for a known UNIFORM TS. TIA
-Original Message-From: Igor Neyman
[mailto:[EMAIL PROTECTED]] Sent:
Title: RE: alert log suppression
If it
is LMT, coalescing is ignored.
-Original Message-From: Deshpande, Kirti
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002
10:34 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: alert log suppression
Coalescing LMTs is
Title: RE: Oracle 8i (8.1.7) for Windows XP Home Edition
i was able to install 8.1.5
sometime back.. but it made my xp terribly slow.. some jdk issues, i
guess..
babu
- Original Message -
From:
Jeremy Pulcifer
To: Multiple recipients of list ORACLE-L
Sent: Monday,
Title: Message
Richard,
I have here versions 8.1.5 and 9.2.
Both show allocation type "UNIFORM" for LMTs with uniform
extent size (exceptLM SYSTEM and UNDO tablespaces in 9.2 , for which
"SYSTEM" allocation type is shown), and allocation type "USER" for dictionary
managed tablespaces.
Igor
Bad form to follow up to my own post, but so what.
It turns out that this particular problem was caused by (get ready) not
having an /etc/hosts entry for localhost. Once I fixed that, I was able to
rerun ssoca and the other config assistants that failed, and I now (appear
to) have a functional
Title: RE: New course for 9i - Dumps/Crashes from Oracle University
Oracle Corporation is conducting these 3
highly technical
seminars. Each one of them is a full
day class at a cost of $500 per class.
http://education.oracle.com/web_prod-plq-dad/plsql/show_desc.redirect?dc=D12856GC10
My condolences on 8.0.5, you should patch to 8.0.5.1 for better a much
better rman.
I think that every channel is used for each datafile. When one datafile has
been completely backed up the channels are used for the next. This is
empiracal thought, what I have observed. I have 2 channels
Our current master is 8.1.6.3 as is our Snapshot database. However, at
some time in the future our master database will be upgraded to 8.1.7.4.
Our options are to stay with 8.1.6.3, upgrade to 8.1.7.4, or upgrade to
9.1.2. We can do this either before or after the master's upgrade.
So our
Good afternoon,
Some time ago there was a response to the
question of how to get leading spaces to display
when using dbms_output.put_line.
I have tried -
dbms_output.put_line(' '||tabrec.table_name);
but do not get the leading spaces.
When someone mentioned how to do this I said of
course
Title: Message
Rich,
You just gave the answer yourself, allocation_type
in dba_tablespaces should show UNIFORM for uniform extent allocation. For
non-uniform allocation, it will show SYSTEM in that field. If you want to know
what is the size of the uniform extent, look for INITIAL_EXTENT
Add them together! Or are we so in need of a technical solution that we
forget the pencil and paper?
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 11, 2002 2:30 PM
Yes. The completion_time is available for the backup
Title: Message
ok
good thats what I had expected, I found that the particular TS was created
differently in another instance. Thanks for your time.
-Original Message-From: Igor Neyman
[mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002
2:39 PMTo: Multiple recipients
Title: RE: New course for 9i - Dumps/Crashes from Oracle University
I took this seminar set last year for Oracle 8i.
It's really very good, but only a little was able to really soak
in. I'm trying to convince manglement to let us go
again.
I had a professor in college who's first lesson was
Keith - We were using 2 channels writing to disk and RMAN was putting almost
an equal amount of data to each channel. For space purposes we needed to put
more data to one disk. The only way I found to do this was to create 2
channels to the disk I needed to write the most data. That works fine,
Steve,
Have a look at Metalink Doc ID: Note:108091.1
For those without Metalink access this suggests:
1) Use format wrapped at the end of your Set Serveroutput command.
This works with SQL Plus version 3.3 or above.
This will keep leading spaces and double spacing
2) If you're on an older
Title: RE: warehouse builder's dependance on oem job system.
Chris,
if its
a plsql job then tcl wrapper script in oem would be same. but your runtime
parameters could be diff. As others have mentioned, u could just run
package.main, just verify that the package has been configured with the
Yes, but what was the question?
Fink, Dan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/16/2002 10:00 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Parallel degree on tables and indexes
Happy Holidays Everyone!
I have been hacking around the MetalLink site looking for how to
move from using a TNSNAMES.ORA file to Active Directory. We use a
mixed environment of HP-UX, Solaris, and Windows, with versions
of Oracle from 7.3.4 (really!) to 9iR2.
All the notes and docs I can find
Hi there!
Wondering if it is worth becoming Oracle Certified
Master, considering the investment for Oracle University courses and Fee for the
Practicum. I estimate 2*$1500 for courses and $2000 for practicum totaling to
$5000. Any opinions?
Also, I have two questions:
(1) There are
Title: Blank
Hello
All,
I am
currently working on capacity planning of the database , expecting the database
size based on the business object ,sales ( Historical data). I am not sure about
the approach I am following . I believe there might be some better approach
followed in some shop to
guys,
i am exporting a DB of size 10G.
it totally has 33 tables.
everything completes succesfully and even the log file
says EXPORT COMPLETED SUCCESSFULLY WITHOUT ANY WARNING.
But while importing it,only 17 tables are imported.
after that the cursor stands still and the import does
not process
Title: Blank
so how r u gonna do it?
1 business object = n number of rows in m
different tables + indexes
if regular day then x number of
business objects are created
if holiday then y number of business objects
are created
and are u going to considering the
historical growth ofdatabase
Title: RE: Purging Managed Standby Database Archive Logs
For pre 9i release2 there is following Note on
metalink
Doc
ID:
Note:190311.1
Subject:
** How to delete an Operating System file from
PL/SQL
This uses a java stored
Vergara, Michael (TEM),
I think what you need is the names server, though it is seldom used .
Regards
zhu chao
[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(Chinese Oracle User Group)
=== 2002-12-16 16:08:00 ,you wrote£º===
Happy Holidays Everyone!
I have been
Are you importing indexes?
How many indexes there are on table #17?
Is the DB in archive log mode?
Is the archiver getting stuck?
- Kirti
-Original Message-
Sent: Monday, December 16, 2002 8:29 PM
To: Multiple recipients of list ORACLE-L
guys,
i am exporting a DB of size 10G.
it
Title: Blank
Craig Shallahamer has a good training class
on this topic : http://www.orapub.com/cgi/genesis.cgi?p1=subp2=cp_course
- Kirti
-Original Message-From: Reddy, Madhusudana
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002
8:19 PMTo: Multiple recipients of list
Is it possible to Create a Locally partitioned Index in a Tablespace Different from
the Base Table Tablespace ?
Base Table being RANGE Partitioned
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network Services
how can a dba see the password of a user.The new MSN 8: smart spam protection and 2 months FREE*
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: faisal ahmad
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego,
Hi all,
I have the following query which is running slow and doing
full table scan on DIENSTLEISTUNGSOBJEKT and FZGBRIEF tables. I have
created all the neccessary indexes on these two tables apart from other
tables. In this regard I request you to help me in tuning the
Title: Blank
Load 5-10% of the stuff and see how much
it takes .
From this you can calculate.
No formula will give you accurate results, mainly because
actual field length vary so much that approximation is useless.
(based on a lot of years checking this)
Yechiel AdarMehish
-
Hi Vivek,
Yes, one can specify the breakout of the index partitions and define
the location for storing them. Here is an example:
CREATE INDEX pt_projects on projects(month_num)
LOCAL(
PARTITION imonth1 TABLESPACE idx1,
PARTITION imonth1 TABLESPACE idx1,
PARTITION
Title: RE: DUAL
So listen up: For better April 1'st - add another
record to dual. That is known to cause a deteriorating effect on
developers.
:-)
Yechiel AdarMehish
- Original Message -
From:
Jeremy Pulcifer
To: Multiple recipients of list ORACLE-L
Sent: Monday,
Walk over to their desk and look for post-it notes attached to the monitor.
Failing that you probably have to ask them.
As I understand it, you cannot reverse-engineer a password from within
Oracle. The common workaround scripts available store the encrypted
password in a temporary table, change
Hello
After building a table the import builds constraint and indexes.
If you got a big table that can take awhile.
Check with task/performance monitor if the instance is idle or working.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
In the explain plan's first line
SELECT STATEMENT Hint=HINT: RULE
But i don't see any rule hint in the SQL statement you have sent.
Analyze the tables/indexes, use a choose hint and run the SQL plan again.
What version you are on? what is the value of optimizer_mode, optimizer_goal
Regards
I am currently busy with the same project. Junk tnsnames.ora for OID.
I installed OID 9.2.0.1.
I then converted the tnsnames.ora to OID entries with no problems.
I then tried to access the OID from 8.1.6 client and got zilch, nada,
gurnisht etc. .
After Deborah from Oracle Israel came in she told
75 matches
Mail list logo