| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tablespace block size limit / Windows
Hi Dennis,=20
It throws a different error when you try to create a tablespace with a block size that hasn't been accounted for in the instance. Metalink blatantly says "16k is a limitation of Windows". All I can hope, hope, hope for is that eventually this will be one lever we can use to push this database off of Windows and onto Linux.
I've been able to do this on my dev environment, where I have tablespaces that are 8k and 16k. I could not create 32k+ tablespaces there, either (surprise).
Stay warm up there!!
Lisa
-----Original Message-----
From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]=20
Sent: Tuesday, February 03, 2004 2:43 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: Tablespace block size limit / Windows
Lisa
Please excuse the dumb question, but I'll ask just to be safe. Are
you
trying to create a tablespace with a block size different from your
instance's block size? Are you able to create a tablespace with any
different size? I also dimly recall something about Windows and block
size,
but since I don't use Oracle on Windows so I promptly forgot it.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com=20
-----Original Message-----
From: Koivu, Lisa [mailto:Lisa.Koivu_at_Cendant-TRG.com]
Sent: Tuesday, February 03, 2004 11:37 AM
To: oracle-l_at_freelists.org
Subject: Tablespace block size limit / Windows
Hi everyone,=3D20
Windows 2003 Server Enterprise Edition, 9204, with disks allocated from 2 Clariion SANs
Several of these disks were formatted at 32k and 64k block size. I was under the impression the limitation on tablespace block size came from the os block size. I can't create a tablespace with a block size greater than 16k, it fails. =3D20
Metalink says this is a limitation of Windows.=3D20
Anyone run into this, and if so, are there any creative ways around this limit? I can't even open a TAR. It keeps kicking me out. Googling this returns nothing useful.
Thanks
Lisa Koivu
desk: 407-248-4277
cell: 954-683-4459=3D20
"The sender believes that this E-Mail and any attachments were free of =
=3D
any virus, worm, Trojan horse, and/or malicious code when sent. This =3D
message and its attachments could have been infected during =3D
transmission. By reading the message and opening any attachments, the =
=3D
recipient accepts full responsibility for taking proactive and remedial
=3D
action about viruses and other defects. The sender's business entity is
=3D
not liable for any loss or damage arising in any way from this message =
=3D
or its attachments."
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
"The sender believes that this E-Mail and any attachments were free of = any virus, worm, Trojan horse, and/or malicious code when sent. This = message and its attachments could have been infected during = transmission. By reading the message and opening any attachments, the = recipient accepts full responsibility for taking proactive and remedial = action about viruses and other defects. The sender's business entity is = not liable for any loss or damage arising in any way from this message = or its attachments."
 |
 |