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: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
From: A. Bardeen [SMTP:[EMAIL PROTECTED]]
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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
