total 3598924
-rw-r----- 1 oracle dba 10486272 Apr 23 06:50 log01.dat
-rw-r----- 1 oracle dba 1049088 Apr 23 03:51 log02.dat
-rw-r----- 1 oracle dba 1049088 Apr 23 04:05 log03.dat
-rw-r----- 1 oracle dba 632832 Apr 23 11:58 ora_control1
-rw-r----- 1 oracle dba 632832 Apr 23 11:58 ora_control2
-rw-r----- 1 oracle dba 104859648 Apr 23 07:21 roll01.dat
-rw-r----- 1 oracle dba 41945088 Apr 23 07:14 sys01.dat
-rw-r----- 1 oracle dba 10487808 Apr 23 04:06 temp01.dat
-rw-r----- 1 oracle dba 2189139968 Apr 23 07:06 user01.dat
-rw-r----- 1 oracle dba 1380921344 Apr 23 06:50 user02.dat
I got an error (below):
SQL> SQL> 2 3 create table radacct_200103 as select * from radacct where
accttimestamp
*
ERROR at line 1:
ORA-01237: cannot extend datafile 4
ORA-01110: data file 4: '/export/oracle/user01.dat'
ORA-19505: failed to identify file "/export/oracle/user01.dat"
ORA-27037: unable to obtain file status
Linux Error: 75: Value too large for defined data type
Additional information: 3
Obviously Oracle is hitting the 2GB filesize limit. But I still have
another data file (user02.dat). So how do I tell oracle not to use
user01.dat anymore? I can hardly bring user01.dat offline (the data on it
will be inaccessible)
--
Orlando Andico <[EMAIL PROTECTED]>
Mosaic Communications, Inc.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GE d(-) s: a-25 C++++ UBLSI++++$ P+++ L+++>++++ E- W++ N(+)
o K? w O-- M- !V PS(++) PE- Y PGP-- t(+)@ 5(+) X++@ R(+) tv@
b++ DI++ G e++@ h--(*) r% y+
------END GEEK CODE BLOCK------
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
