how to act in this situation?

[GladiatoR]

my database is ill-preserved one, it is now full of data and wat can i do? how can i move the contents into some other disk which is empty?

[LKBrwn_DBA]

Just follow normal procedure to move (relocate) the data files.

Any one of these:

1) Backup controlfile to trace, shutdown db, move the files, change locations in the "CREATE CONTROLFILE", starup nomount, create controlfile...

2) Alter tablespace offline, move files, alter database rename files, alter tablespace online

3) Shuutdown database, move files, add 'DB_FILE_NAME_CONVERT' to the init.ora file, ...etc...
.

[GladiatoR]

thanks a lot guru ...

[gandolf989]

I'm confused, if the database is really "ill-preserved" then how it is "full of data"???

[jhmartin]

I think he means it wasn't being managed properly.

[hrishy]

Hi

Do you use some kind of Logical volume manager ?

regards
Hrishy

[pareshjavkar]

Hi

Do you use some kind of Logical volume manager ?

regards
Hrishy

If Yes, u can resize the LVM disk online and create more space.

Paresh

[Tuma]

i would like to know what ill-preserved means...