Orlando Andico wrote:
>
> 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)
It's been a while since I've toyed with Oracle and don't have my manuals
handy, but I think you're supposed to ALTER DATABASE foo DATAFILE
'bar.dbf' and set AUTOEXTEND OFF and possibly RESIZE. I'll ask my
brother -- he actually went to Oracle DBA training.
No, you don't want to take the tablespace (not datafile) offline. I
guess you shouldn't have set AUTOEXTEND ON when you created the
datafile, huh?
You might want to try creating another tablespace with multiple smaller
datafiles, CREATE TABLEs in that tablespace, then insert your data from
the user tables into the new tables.
Brian
_
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]
