Home » RDBMS Server » Server Administration » Bigger than 1 GB datafile under Linux 7.3
Bigger than 1 GB datafile under Linux 7.3 [message #54028] Thu, 24 October 2002 09:25 Go to next message
nagesh d babu
Messages: 7
Registered: October 2001
Junior Member
Hi to Oracle world,

I am using Oracle 8.1.7 under RedHat Linux7.3 and the filesystem is ext3. while creating datafiles, Oracle doesn't allow me to more than 1 gb of datafile. What should i do to create > 1 gb datafile. Ofcourse we have an alternative to create more datafiles of 1 gb size under a tablespace. Have the below details:

SQL> create tablespace test datafile '/u3/oracle/oradata/iz191/test01.dbf'
2 size 2048 m
3 default storage(initial 200 m next 200 m minextents 2 maxextents 50);
create tablespace test datafile '/u3/oracle/oradata/iz191/test01.dbf'
*
ERROR at line 1:
ORA-01119: error in creating database file '/u3/oracle/oradata/iz191/test01.dbf'
ORA-27044: unable to write the header block of file
Linux Error: 22: Invalid argument
Additional information: 2

Help would be appreciable. Thanks in advance.
Chinnu.
Re: Bigger than 1 GB datafile under Linux 7.3 [message #54056 is a reply to message #54028] Sat, 26 October 2002 04:17 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Hi , U can set this by Configuring the Kernel parameters...Please check the O/S related documentation..

sai
Previous Topic: error of creating a database!!!!
Next Topic: Same database - multiple schema
Goto Forum:
  


Current Time: Thu Sep 19 20:18:32 CDT 2024