Guys,
I would to generate Create Table .. script
for a schema WITHOUT storage parameters.
Can someone share a script for the same ?!
ENV is 8.1.6/Win2K.
TIA.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City
Thanx Ganesh.
triedEXP/IMP/Databee.
thought of avoiding file copy -- which consumes more time.
.a script would be more handy , isn't it ?!
Regards,
Jp.
20-06-2003 15:09:33, [EMAIL PROTECTED] wrote:
Oracle is ready to share it with u ;)
Use
Dear Friends,
Any idea where latest Oracle white papers in PDF files will be available ?
example Export/ Import Faq.
Only notes are displayed in metalink.
Your responce is appreciated.
Thanks
Rajuveera
**
This email
Thanx a lot Sanjiv Ganesh.
Got the script from Mudhalvan.
Regards,
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California--
After Migrating a production Database from 8.1.7.4 to 9.2.0.3.0 (64 Bit) on Solaris 8
following NON-Documented parameters were set by Oracle Corp
_shared_pool_reserved_min_alloc=16384
This was done to take care of the ORA-4031 errors. This caused shared pool erros to
STOP Occuring
though at
Jp,
I'll jump in here..
You say you tried the DataBee DBATool? Or did you? It's available here if
not:
http://www.cool-tools.co.uk/Products/dbatool.html
To use DBATool, you need to take a full export from the database, with the
"rows=n" option set - just grab all
Hi Arup,
Remote OS authentication whether with OPS$ or not is still a risk. You
are intimating that SYSTEM is the only risky account involved here. What
if any of the newly created OPS$ accounts have useful privileges. I have
seen a similar application to the one described recently. There were
Try to oracle gateway product
http://www.oracle.com/gateways/gateway_bundles/index.html?faq.html
-Original Message-
Sent: Thursday, June 19, 2003 10:27 PM
To: Multiple recipients of list ORACLE-L
I need to be able to read SQL Server tables from an Oracle procedure.
Can anyone point
Looks like a whole set of bugs we haven't come across YET
-Original Message-
Sent: 20 June 2003 10:14
To: Multiple recipients of list ORACLE-L
After Migrating a production Database from 8.1.7.4 to 9.2.0.3.0 (64 Bit) on Solaris 8
following NON-Documented parameters were set by Oracle
Thanks a lot Mark.
Jp.
20-06-2003 18:54:18, "Mark Leith" [EMAIL PROTECTED] wrote:
Jp,
I'll jump in here..
You say you tried the DataBee DBATool? Or did you? It's available here if
not:
--
Please see the official ORACLE-L FAQ:
Does anyone has script which can check grant
privilege on a table and generate output for future
usage?
Thanks.
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Hi,
For multiple projects we are planning to have a centralized server(as opposed
to multiple servers, to improve managability) which all the development teams
will use for their backend work.
Now there are 2 ways in which to provide them access.
1. Have only 1 database for each version of
Title: OT: SQL Server Q?
Hi All
I'm mainly into Oracle but in a SQLserver database we encountered this error
maximum number of DBPROCESSes already exist
In oracle I would look at the processes parameter but what would I be looking at in SQL server???
TIA
Jacob A. van Zanen
Stephen Lee scribbled on the wall in glitter crayon:
No No. THOSE guys did replication. Then the worst of the bunch
worked in conjunction with the authors of graduate Math texts to come
up with Advanced Queuing.
somehow this makes me glad i work for cheap places that don't use any of
if you create separete databases , you can monitor statistics of each of them
indivudually. Otherwiese database statistics will be affected from multiple projects .
-Original Message-
Sent: Friday, June 20, 2003 2:19 PM
To: Multiple recipients of list ORACLE-L
Hi,
For multiple
Ron Rogers scribbled on the wall in glitter crayon:
Drums along the mohawk.
sorry dude, no Apaches in that one. just 5 nations.;-)
--
Bill Shrek ThaterOracle DBA BAARF Party member #25
[EMAIL PROTECTED]
Of course, there is always dbms_metadata, so that you don't have
to use any utilities.
On 2003.06.20 08:11, Prem Khanna J wrote:
Thanks a lot Mark.
Jp.
20-06-2003 18:54:18, Mark Leith [EMAIL PROTECTED] wrote:
Jp,
I'll jump in here..
You say you tried the DataBee DBATool? Or did you? It's
This is an interesting one. I am currently going through (tortured) another
system audit. One of the many questions the auditors (I am being attacked
from all sides) had about the Oracle configuration was Can remote
authenticated network users connect to the database?.
If auditors know this is
Title: OT: SQL Server Q?
sp configure 'user
connections'
This
is an advanced option (believe it or not), so you may have to do
"sp configure 'show
advanced options', 1" before you do "sp configure 'user connections'".
Alternatively you can just run SELECT
@@MAX CONNECTIONS
Returns
Hi Listers,
I've just finished a sizing exercise for a Production OLTP. At the one-year mark, it should
be approximately 4.5 Terabytes in size. Yikes !! I have a RAID5 array that I'll be using for
all of the data files (except the typical System, Rbs, etc which are going to be on RAID 0+1).
I
Title: RE: Development projects: Multiple databases v/s multiple schemas
if your schema will be cross-referencing, I vote for ONE db with multiple schema. This way, any changes in one schema immediately affect others and can be controlled. If you _know_ (guaranteed by management) that the
I disagree. Remote OS authentication is not inherently insecure in
Windows like it is in Unix. If you prefix the account names with the
domain name, a user would not only have to spoof the username, he would
have to spoof the domain name too. At that point, you probably have
bigger problems
Hi Mike,
I've spoken about DBATool to one person on the list today already, so
another won't hurt too much I hope ;)
DBATool will do what you want. It will even let you create a nice HTML set
of documentation (you say future reference), the pages will show you the
DDL of that table, and all it's
*** Comments by BECKER, BILL Fri Jun 20, 2003 -- 08:09:59 AM
We upgraded to 64-bit 9.2.0.3.0 on Solaris 9 a few weeks ago,
and are currently experiencing ORA-01733 virtual column not allowed
here errors - bug 2884797. This is a star transformation bug,
and you are likely to hit it if you
/[EMAIL PROTECTED]:\scripts\createinsert.sql
drop user SOMEONE;
create user SOMEONE identified by lgt5666
default tablespace tables
temporary tablespace temp;
grant connect to SOMEONE;
*/
spool D:\scripts\insertperm.sql
select 'GRANT INSERT ON SCHEMA.'||'' || table_name ||' TO SOMEONE'
||';'
I don't think the cursor sharing will help. We've been going 'round and
'round with the shared pool fragmentation problem and the 4031 errors.
Flushing the shared pool might or might not work; sometimes it cleans things
up; sometimes it doesn't do anything (as far as I can tell). About all you
Look into DBMS_METADATA examples in the oracle 9.2 technical documentation.
That is precisely the example they gave.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 20, 2003 8:45 AM
To: Multiple recipients of list ORACLE-L
Hi,
We end up doing it both ways at the same time. We have multiple
development instances and multiple schemas in each instance. We do this
because we are running a large ERP system and each test instance has
specific testing requirements so we end up replicating multiple instances
on the same
O'Reilly is good. Also, get yourself comanche (http://www.comanche.org). That is a gooey
tool
for setting up Apache.
Mladen Gogala Oracle DBA Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-From: Sam Bootsma
[mailto:[EMAIL PROTECTED]Sent: Thursday, June 19,
The old simple snapshot replication is OK. It's just that some of this
later stuff makes you think they rounded up all the guys who have tape on
their glasses and wear suspenders with their pants that are too short, gave
them a drug to put them in an *extra* geeky mood, gave them unlimited
Hi all,
Has anyone done the upgrade from 8.1.7 32 bit to 9.2.0.3 64 bit? I'm trying
to determine whether it's necessary to perform any other steps than the
regular upgrade process.
Note 62290.1 seems to imply that no other steps are required, but this is
contradicted elsewhere and it's proving
Title: RE: Development projects: Multiple databases v/s multiple schemas
Thanx
Raj and Bahar,
Raj I
think you misunderstood my question. Or I might be misunderstanding a part of
your reply :-)
I'll
try to makemyquestionclearer
All
the developers of a project work on the same
Stephen Lee scribbled on the wall in glitter crayon:
The old simple snapshot replication is OK. It's just that some of
this later stuff makes you think they rounded up all the guys who
have tape on their glasses and wear suspenders with their pants that
are too short, gave them a drug to put
Sorry, should have mentioned that I'm on Solaris 2.8.
Thanks,
Jay
-Original Message-
Sent: Friday, June 20, 2003 10:19 AM
To: '[EMAIL PROTECTED]'
Cc: Miller, Jay
Jay,
Just make sure that ur OS is 64-bit as well and go ahead as per the
documentation. If ur OS is HP-UX,
do not forget to
Jay,
Just make sure that ur OS is 64-bit as well and go ahead as per the
documentation. If ur OS is HP-UX,
do not forget to set ur SHLIB_PATH and CLASSPATH as well.
Cheers
Samir
Samir Sarkar
Oracle DBA
SchlumbergerSema
Email : [EMAIL PROTECTED]
Phone : +44 (0) 115 - 957 6028
EPABX : +44
Greetings,
When I export schema containing some tables, I got EXP-00091 warnings. The log
is saying:
..
JServer Release 9.2.0.1.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
. exporting
select 'grant '||privilege||' to '|| grantee ||' on '||table_name||';' from
dba_tab_privs where owner = 'BUBBA';
Note that this will get everything owned by BUBBA: tables, procedures,
packages, views, sequences.
-Original Message-
Does anyone has script which can check grant
Naveen,
It depends on the deployment method to be used. In general I try to limit the
number of instances. Sure not having each project in it's own instance diminishes
some of the capabilities that you have to monitor how they perform, but all of those
instances are competing on the
AK,
The issue is not creating an id called OPS$ SYSTEM
on XP, but on the database. Say, you created a user called OPS$SYSTEM
as
create user ops$system identified
externally;
The XP user should be SYSTEM, not OPS$SYSTEM, to
log on to this account.
Now suppose, your os_authent_prefix is
Since I really don't have any performance issues [2 Nodes, 2CPUs each
@1GHz, 2GB, ES45 Tru64Cluster],
I haven't been runnning StatsPack.
However I just ran two snapshots and didn't see such a wait event.
I'm sure that other people have also implemented mcpd=0 successfuly
[my 9iRAC is an
I have not done this yet, but I did look into it.
There is one thread in the Metalink forum that I printed the number is 337111.99
(I am not sure if that is the whole number or not, it looks cutoff on the
printout). It also references doc 169426.1, which has some good info in it.
The basic idea
I might have gotten something bass-ackwards here. Please correct as needed.
Testing?! We don't need no stinkin' testing.
-Original Message-
select 'grant '||privilege||' to '|| grantee ||' on
'||table_name||';' from
dba_tab_privs where owner = 'BUBBA';
--
Please see the
Title: RE: Development projects: Multiple databases v/s multiple schemas
Hi Rajendra
...
For
Example ,
There is one instance and two project on this
instance.
ProjectA and ProjectB.
beetween 10:00 am and 11:30 am ,ProjectA realized via
numerious sessions
30 timeswait for
event of
We have users who need to install the oracle 9i client on their PCs but
who aren't administrators on their machines. How do people handle this
situation?
Thanks.
Joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Armstrong-Champ
INET: [EMAIL PROTECTED]
Fat City
I just read a .pdf by a couple of people at oracle called Stop Fragmenting and start
living where it says not worry about the number of extents in a tablespace. However in
the administrators doc it says the following:
Estimate Table Size and Set Storage Parameters
Estimating the sizes of tables
Title: RE: Development projects: Multiple databases v/s multiple schemas
I understand now, but in development?? I have 13 schema that form an
application, the development is an exact replica of production RAC instance and
no one in Devl complains (well most of the times).
Raj
I know we had to run utlirp.sql when moving from 32 to 64. Not sure if this
is covered by running catproc as part of the migration.
-Original Message-
Sent: 20 June 2003 15:50
To: Multiple recipients of list ORACLE-L
Hi all,
Has anyone done the upgrade from 8.1.7 32 bit to 9.2.0.3 64
Got it . Thanks Arup .
-ak
- Original Message -
From:
Arup Nanda
To: Multiple recipients of list ORACLE-L
Sent: Friday, June 20, 2003 8:54 AM
Subject: Re: oracle authentication from
windows
AK,
The issue is not creating an id called OPS$
SYSTEM on
It is the old argument that was made to justify one or only a few
extents. Empirically the idea does not hold up. This idea is now
classified as a myth but the Oracle docs have not caught up yet.
Allan
-Original Message-
Sent: Friday, June 20, 2003 11:20 AM
To: Multiple recipients of
Hey,
Can anyone say if there is a way to breakup an existing partition into
subpartitons. The partition contains data.
Thx
Ishwar.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ishwar Tewari
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
What was this 5am job? It wasn't an analyze was it?
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/20/2003 11:29 AM
Hey all,
I'm testing out the max I/O thruput of an IBM FastT900 using a dual
2.4GHz
w/1GB RAM on Win2K server (not my choice but it's just for
Okay,
I figured the time had come to stop speculating about MySQL's licensing
policy and get the answer straight from the horse's mouth, as it were.
So I contacted MySQL and posed a couple of scenarios to them. Here's my
questions and their responses (my stuff is the quoted part):
in all of
Two reasons:
a) if you go into extent map blocks then you will
suffer an overhead of at least 1 billionth of a
percent :-)
b) more seriously, its generally easier to pick up a
rogue table if its run into thousands of extents and
you had not intended it to. Its not a performance
problem per se,
My favorite part is
and all of the table's data will be stored in a relatively contiguous
section of disk space.
Is this even reasonable to believe, especially with any kind of
striping implemented?
[EMAIL PROTECTED] 06/20/03 12:00PM
Two reasons:
a) if you go into extent map blocks then you
Title: Message
SET ORACLE-L
NOMAIL
Rafiq that is a good point , but I have set
my control_file_record_keep_time=7 (which is also the default , I
think )
and recovery window is 4 days
Anything else to check ?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Mladen , I do not get a problem if I use :
configure retention policy to redundancy n ;
(n= integer)
However I am having my controlfile backup reported as obsolete when :
configure retention policy to recovery window of n days ;
(n=integer , I use 4) and my control_file_record_keep_time=7
Please
Thanks for the clearing that up. Did you happen to get a qoute as well? :)
Just curious, does MySQL also uses CPU based and named users license?
or it is just per server?
-Original Message-
Sent: Friday, June 20, 2003 1:12 PM
To: Multiple recipients of list ORACLE-L
Okay,
I figured
Even without stripping you can't gaurantee it will be a contiguous
section of disk space. The file could be scattered across
the file system.
Richard Ji
-Original Message-
Sent: Friday, June 20, 2003 1:12 PM
To: Multiple recipients of list ORACLE-L
My favorite part is
and all of the
Oracle Makes Bid to Buy State of Delaware
Software giant willing to assume state's $225 million deficit in exchange
for
legislative control, naming rights
Wilmington, DE - Oracle CEO Larry Ellison today announced his intention to
purchase the state of Delaware for $300 million in cash and
Title: RE: Development projects: Multiple databases v/s multiple schemas
That's why my question ... do schema cross-reference ...?
If you have schema that don't need to talk to each other, one DB is still
good. If you have enough resources, then give every team on db. But that is
costly in
Does this mean that if I dd the file onto a raw partition, it will be
scattered around the raw partition? Even though the dd-ing process is
unaware of the characteristics of the raw partition?
-Original Message-
Even without stripping you can't gaurantee it will be a contiguous
Only in part. It's an hourly complete rebuild of a mini-warehouse table
(don't ask -- not my idea). It does do a few index creates and accompanying
analyzes of those indexes and their table at the end of the procedure. I
think this accounts for the very high PIO spikes at the end of every
Hi All,
I need some help in setting up ORACLE JMS to post and read messages from
queue.I am a newbie in this and I ave gone through
the Oracle application developers guide for Advanced queuing document but it
is too exhaustive.
Does anyone have any examples,web links to get started with Oracle
or reasonable to WANT? if I'm running a data warehouse, maybe. If an
OLTP system, orders and customers etc then I'm not likely to WANT the
next block of data on disk for my transaction
--- Darrell Landrum [EMAIL PROTECTED] wrote:
My favorite part is
and all of the table's data will be stored
[deft backpedaling]
OK, now I think it IS the SAN. The S/A handling the SAN is helping us with
our backup scenario so he's reorganizing some drives on the SAN. At about
the same time he started the reorg (highly drive-intensive), my aggregate
PIO rate dropped from almost 10K/s to less than
Cool. State of Connecticut also has a budget crisis..
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 20, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L
Oracle Makes Bid to Buy State of Delaware
Software giant
makes sence to me... I've seen an analyze, if it takes a long time to run,
cause odd things to happen to SQL that starts running in the middle of the
analyze process.
The SAN rebuild certainly sounds like a likley suspect.
RF
-Original Message-
To: Jesse, Rich; Freeman Robert - IL;
i understand, but alot of people have posted here that its ok to have smaller extents
anyway.
who is correct? or am i missing something?
From: Richard Ji [EMAIL PROTECTED]
Date: 2003/06/20 Fri PM 02:00:11 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: oracle
Naveen
Advantages of single instance
- Easier to administer. I have multiple test instances and often have to
go around getting permission to bounce instances to re-jigger the memory
when one project needs more memory for some test.
- Easier to share data among projects.
Advantages of
Ishwar - What Oracle version. Just off the top of my head, I think that 8i
only allows the subpartition to be hashed. What is your goal?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 20, 2003 12:00 PM
To: Multiple
Jin
I cured this one with STATISTICS=NONE. Inelegant, but effective
nonetheless.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 20, 2003 10:21 AM
To: Multiple recipients of list ORACLE-L
Greetings,
When I export
Title: RE: Look's like Larry's at it again...
Yeah ... but they have money to sue everyone in sight.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
ok, so should the number of extents in a table be considered in table design? there
are alot of .pdfs and people on this listserv that say it is irrelevant?
From: Rachel Carmichael [EMAIL PROTECTED]
Date: 2003/06/20 Fri PM 02:44:52 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
Joe
If your administration group controls the machines to this extent, I
would hand the administrators a CD with Oracle client on it and say go for
it, your baby now.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 20,
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, June 20, 2003 9:44 AM
This is an interesting one. I am currently going through (tortured)
another
system audit. One of the many questions the auditors (I am being attacked
from all sides)
Pete,
Apprciate your comments. You are right in stating that if the OPS$ accounts
have special privs they might be abused. But how it is any different than
any other user id with special privileges whose password is not guarded
well? The security hole does not come from the fact that
Excellent, but I really thought he meant to call it Larry Land! :)
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not. It's much harder than that!
Bruce Pihlamae, long term Oracle DBA.
-Original Message-
Jesse, Rich
Sent: Friday, June
I just got a call from the S/A that the copy completed. After looking back
at Spotlight I asked At 1:00, right?. Sure enough. So at least that
part's solved. As to why/how it started the same time as the DBMS_JOB? I'm
willing to let that be a mystery pondered on over beers for years and
Any plans for the crisis countries Larry :)
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, June 20, 2003 12:00 PM
Cool. State of Connecticut also has a budget crisis..
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
that's how we do it here. there is a Lan Administration group responsible
for installing software on all PC's.
thank goodness they stay out of the DBA area. we do our own installs.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, June 20, 2003 3:16 PM
I hate to be a spoilsport, but some people unfamiliar with the USA might be taking
this seriously. This is, of course, a humorous piece, in the same vein as the joke
about Microsoft purchasing the Catholic Church
http://www.spunk.org/library/humour/sp001526.html
-Original Message-
David,
I do feel your pain. Sometimes the auditors just go overboard looking over
some set checklist and some items in their checklist just plain contradict
each other. Take example I just went through recently.
I am making the databases of a few healthcare companies HIPAA compliant. A
recent
Bummer! I've already started to hope that I'll
soon be living in Connecticut ver 10i. Even Red Sox
defeats would hurt less in the Oracleland.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 20, 2003 3:30 PM
To: Multiple
Jacques,
Well I like both of them. Nothing like a good chuckle to brighten up a day.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, June 20, 2003 3:30 PM
To: Multiple recipients of list ORACLE-L
I hate to be a spoilsport, but some
I think with LMT's now, it is irrelevant. I still think you need to know
approx. how big the table is going to be, and place it in the correct LMT.
By this I mean that you may have different LMT's with different uniform
extent sizes. A very large table should be placed in the largest LMT
I heard that Gates has a deal in the works with McDonalds to sell MS
products there. He will rename his product suite to McWindows in honor of
the agreement.
Also heard that McWindows would now come with a free hard drive called the
McDrive with two all silicone disk platters, special fire wire
(my question follows)
-Original Message-
From: Seefelt, Beth [mailto:[EMAIL PROTECTED]
I disagree. Remote OS authentication is not inherently insecure in
Windows like it is in Unix. If you prefix the account names with the
domain name, a user would not only have to spoof the
Beth,
You are right in stating that OPS$ accounts are not inherently insecure.
How is teh inclusion of domain name any more secure than using OPS$?
Granted, the hacker has to guess the domain name in addition to user name,
but so is using any other prefix other than OPS$.
Besides if the users
Nah. LarryWorld.. Will charge you to enter and exit the state. Will
over count residents to get better tax subsidies and will never discount
products to government agencies. Oh yes. Everyone must own an Armani Suit.
Thank You
Stephen P. Karniotis
Strategic Alliance Manager
Compuware
Hello list
I was having problems with my controlfile backups being reported as
obsolete ;
I have narrowed down the problem to the number of days specified in
the recovery window .
1. My control_file_record_keep_time=7
2. Suppose I start rman and there are no backups yet. (This is
confirmed by
No, I was talking about on file system only.
-Original Message-
Sent: Friday, June 20, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L
Does this mean that if I dd the file onto a raw partition, it will be
scattered around the raw partition? Even though the dd-ing process is
Hey Dennis:
I created a range partition table with the last high_value being maxvalue.
The partition key is partner_id (an incremental sequence).
Now pmax (the last partition) has become very big and gives snapshot too
old.. while exporting.
Ultimate Plan
=
I realize that the
Carol,
We use a 7.1 Terabytes (double Yikes!) database -
Sun 15K server, Hitachi Storage Array, RAID-5 (all except redo logs which are
RADI 0+1), 8.1.74. Some of thetables are more than 100 GB in size. However, the
datafiles are smaller, just 4 GB each. This is done to facilitate the
-Original Message-
From: Goulet, Dick [mailto:[EMAIL PROTECTED]
Well I like both of them. Nothing like a good chuckle
to brighten up a day.
Yes, I thought it was funny, but especially with these official sounding articles
you never know if it will end up being spread over
The version is 9i.
-Original Message-
DENNIS WILLIAMS
Sent: Friday, June 20, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L
Ishwar - What Oracle version. Just off the top of my head, I think that 8i
only allows the subpartition to be hashed. What is your goal?
Dennis Williams
When you say 9i, do you mean 9.0.1 or 9.2.0? In 9.2.0 You can have list subpartitions.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_73a.htm#2153058
-Original Message-
From: Ishwar Tewari [mailto:[EMAIL PROTECTED]
I created a range partition table
Thank you for the research.
When they say Distribution for MySQL would mean more than one copy installed in a
production environment, by production environment, they must mean a business.
For example I can use MySQL on my home computer to keep track of my record collection,
and I can also
Ishwar
I am fairly new to partitions myself and must relearn the commands each
time I need to work with the partitions. So I will speak more to the
philosophy of a DBA that doesn't like to end up in a jam.
I get a bad feeling about hashing to get around an immediate problem. I
also question
I figured he try for something closer to home...say Oragon?
Then Bill would want to buy Mississippi (postal abreviation MS for our non-us listers).
Jesse, Rich wrote:
Oracle Makes Bid to Buy State of Delaware
Software giant willing to assume state's $225 million deficit in exchange
for
1 - 100 of 126 matches
Mail list logo
