DATAFILE RESIZE !!!

[SteinLaus]

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)
***********************************************

[Halo]

Yes, just resize the dbf. You need not transfer anything around.

[jgmagnus]

Well you have a couple of solutions.

The first thing I would do is eliminate any files you no longer need. Maybe achived log files are taking up a bunch of disk space? Maybe your cold & hot backups are taking up a lot of disk space. Maybe some old exports are taking up disk space?
Sometimes I will remove a tablespace, but forget to delete the old datafile until I find it months later sitting in a directory. I definately know my backups take a lot of space so I try to delete those once I know that they have gone to tape.

Have you tried defragging the current tablespace?
"alter tablespace users coalesce;"

Other Tablespaces/Datafiles are possibly taking up a lot of disc space ...

If you have already tried all of this lemme know and I'll give you more suggestions.

- Magnus

[SteinLaus]

Thanks all for reply,

but alter tablespace? ... thought that will drop the tables into a temp Dat?

Correct me if im wrong ....

Or maybe can anyone write me a step by step guide who to do that right ..

im not an oracle expert ... but an sql programmer :)

Thanks alot to all

Florian Kirchlechner

[Prof]

You can use Reorganization Wizard in Tuning Pack in Enterprise Manager 2.1

[Prof]

if version of database is Oracle8i

[SteinLaus]

I will give it a try ... and searching after that tool :)

Thanks alot so far

[yls177]

[QUOTE][i]Originally posted by jgmagnus [/i]
[B]
Sometimes I will remove a tablespace, but forget to delete the old datafile until I find it months later sitting in a directory.
- Magnus [/B][/QUOTE]


okay, when u remove ( drop ) a tablespace, doesnt the physical datafiles are dropped as well?

[jonathanisaac]

[QUOTE][i]Originally posted by yls177 [/i]
[B]okay, when u remove ( drop ) a tablespace, doesnt the physical datafiles are dropped as well? [/B][/QUOTE]

No Dear! you have to delete the physical files manually.
-Jonathan
\\|//
(o o)
^"^"^"^"^"^oOOo"^(_)^"oOOo^"^"^"^"^"^"^"^"^"^"^