Re: My tablespace does not have datafiles

On 12 Apr, 11:57, "Bohne" <simje..._at_aol.com> wrote:
> Using Oracle 10.1.0.4.0 on HP-UX
>
> It's been donkey's years since I have been working with oracle, so
> maybe I am just overlooking something...
> Either way, I have the following problem:
>
> I get an error ' unable to extend temp segment by 128 in tablespace
> TEMP '
> I thought EASY, just enlarge the datafile, BUT...
>
> select a.name tbs,substr(b.NAME,1,50) datafile,b.BYTES/1024/1024 as mb
> from V$datafile b,V$tablespace a where a.ts#=b.ts# and a.name='TEMP'
>
> no rows selected
>
> No Typo, if I look at all the TBS:
>
> select a.name tbs,substr(b.NAME,1,50) datafile,b.BYTES/1024/1024 as mb
> from V$datafile b,V$tablespace a where a.ts#=b.ts#
>
> TBS
> DATAFILE MB
> ------------------------------
> -------------------------------------------------- ----------
> SYSTEM /oracle/xxx/data1/
> dbs1.dbf 300
> UNDO01 /oracle/xxx/data1/
> undo1.dbf 300
> SYSAUX /oracle/xxx/data1/
> sysaux01.dbf 400
> USERS /oracle/xxx/data1/
> usr1.dbf 10
> TOOLS /oracle/xxx/data1/
> tool1.dbf 50
> USER1 /oracle/xxx/data2/
> U0011.dbf 100
> INDEX1 /oracle/xxx/data2/
> I0011.dbf 100
>
> 7 rows selected.
>
> Now I am lost, please help!

"My tablespace does not have datafiles"

How does it smell? ;-)

select * from dba_temp_files

HTH -g Received on Thu Apr 12 2007 - 06:12:00 CDT