Looking Advice for the not so young, about db structure spre

Posted by OctavioOlguin on 28-Feb-2020 18:55

Greetings...

By unfortunate lack of attention, when a db exhausted original volumes, I created an ADD.st file so to extend capacity on db.

but I ended with this structure:

d "tap":7,64;8 /home/DB/dwh_7.d1 f 1250048
d "tap":7,64;8 /home/DB/dwh_7.d2 f 1250048
d "tap":7,64;8 /home/DB/dwh_7.d3 f 2096960
d "tap":7,64;8 /home/dwh_7.d4 f 1888896
d "tap":7,64;8 /home/dwh_7.d5 f 1888896
d "tap":7,64;8 /home/dwh_7.d6

I missed the DB part on the path...

What are my options to move back those extents into the DB directory, where rest of database resides?

TIA

Jorge

All Replies

Posted by Libor Laubacher on 28-Feb-2020 18:58

Stop the database, move the extents, amend the .st file, run prostrct repair

This thread is closed