Brian Baquiran wrote:
>
> 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
> >
Oh yeah, you might also try to ALTER TABLE baz ALLOCATE EXTENT (DATAFILE
'bar2.dbf') or something like that, specifying the new datafile. It has
to be from the same tablespace baz is in.
Postgres of course splits datafiles at 1GB.
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]
