How to move oracle 10g database to other location/partiton in in windows 2003 server?

How to move oracle 10g database to other location/partiton in in windows 2003 server?

we have dbf file in d: partition that has no enough space, is there any way to relocate this dbf file to other partiton?

Please advise.

Thanks,
joehuangAsked:
Who is Participating?
 
dbmullenConnect With a Mentor Commented:
0
 
DavidSenior Oracle Database AdministratorCommented:
Sure.  Bring the db down cleanly; copy the dbf's to your new target; mount the instance; alter the database by moving the datafiles to their new location; bounce the database.  Do you need specifics or do you have access to the syntax?
 
0
 
joehuangAuthor Commented:
I am preety new to oracl; can you provide me the procedure?

Thanks,
0
All Courses

From novice to tech pro — start learning today.