OK guys and girls and dbas and whatever outside in the real life exitst :)

My Prolem:

I have a .dbf file calles users.dbf ...
the size of the file is about 4.5GB. Now we have
created a whole new Database on that machine ...
now the old file still got schemas which i need to transfer
to the new database. BUT ... theres no more disk space left ...

Now i need to know: Can i either resize the .dbf without altering the table or moving the whole DB to another ServerSystem ..(for example an NT Oracle Server) and then move it back to the Solaris System

Thanks alot

Florian Kirchlechner

***********************************************
OK YOU GOT A JOB AS WEB PROGRAMMER..................
OK HERES THE ORACLE ... HAVE FUN WITH IT .............
Florian Kirchlechner (DBA... but not as wished)
***********************************************