| 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: File size problem.
With large files in Oracle 7.3.4., beware of the RESIZE clause on oversized files because it may create havoc on your database.
See technical notes
112011.1 - resize or autoextend can "over-size" datafiles and corrupt the
data dictionary
1012442.6 - ora-2237 during import on "create tablespace..."
I went through Hell in August of last year because of these two bugs, full import tried to create datafiles 18446744071570456576 bytes in size, even though the tablespaces already existed.
I never managed to get Oracle support to tell me what the threshold was between a large file and an "oversized" file, they didn't seem to know or feel it was relevant. I was curious because some huge tablespaces were fine, while others were not.
Beware of the OEM Storage Manager as well against Oracle 7.3.4. oversized files, the Storage Manager of course issues SQL when you extend datafiles... it also uses RESIZE.
There may be other technical notes on this topic, the bug must have impacted a number of things - e.g. what if I had been using sqlloader instead of import? Don't know, never asked.
I believe they fixed this in newer versions.
Regards,
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 Region, DFO | Région des Maritimes, MPO
E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>
-----Original Message-----
From: A. Bardeen [SMTP:abardeen1_at_yahoo.com]
Sent: Friday, May 18, 2001 11:06 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: File size problem.
Jothish,
7.3.4 on Solaris doesn't support file sizes larger
than 2GB except on raw partitions.
I find the following note invaluable for file size
issues. It also contains links to port-specific notes
as well.
Note: 62427.1 "2Gb or Not 2Gb - File limits in Oracle"
HTH,
-- Anita
--- "Manivannan.M" <manivannan.m_at_tatainfotech.com>
wrote:
> Hi DBAs,
> We are creating a oracle 7.3.4 database on a sun
> machine with solaris 8
> installed on it.The problem is that when we try to
> create a file thru the
> oracle then it does not allow us to crewate files
> bigger than 2000M
> size.whereas when we do it thru the OS it does
> create bigfiles
>
> created file thru the OS:
> -------------------------
> Now when we do a mkfile -v 3000M testfile it does
> create a big file of
> the required size.But then when i try to create a
> datafile thru oracle
> then it gives an error:
>
>
> creating file thru the oracle:
> ------------------------------
> SVRMGR> create tablespace testb datafile
> '/db1/dbf/test01.dbf' size 3000M;
> create tablespace testb datafile
> '/db1/dbf/test01.dbf' size 3000M
> *
> ORA-01119: error in creating database file
> '/db1/dbf/test01.dbf'
> ORA-07358: sfccf: write error, unable to write to
> file.
> SVR4 Error: 2: No such file or directory
>
>
> what cud be the reason behind this...
> are there any OS specific parameters that need to be
> modified or could
> there be some problem with the installation???
>
> please reply ASAP
>
> thanks in advance,
> Jothish
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Manivannan.M
> INET: manivannan.m_at_tatainfotech.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
--------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing
Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: BoivinP_at_mar.dfo-mpo.gc.ca Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue May 22 2001 - 09:16:01 CDT
 |
 |