how to change the location of database files

2 views
Skip to first unread message

hare jjj

unread,
Apr 16, 2009, 4:13:33 AM4/16/09
to oracle-...@googlegroups.com
HI All
 
While creating the database i had misplaced the datafiles in some other directory instead of /oradata/...
 
Please let me know how to move the datafiles to the required folder .
 
Regards
hare

Arju

unread,
Apr 16, 2009, 4:35:45 AM4/16/09
to oracle-...@googlegroups.com
Depends on the log mode of the database. Have a look at http://arjudba.blogspot.com/2008/04/relocate-datafiles-in-oracle-database.html
 
Mohammad Abdul Momin Arju,
Head of Database Department,
Maestro (Pvt) Ltd.
+8801710282272
http://arjudba.blogspot.com



From: hare jjj <hare...@gmail.com>
To: oracle-...@googlegroups.com
Sent: Thursday, 16 April, 2009 14:13:33
Subject: how to change the location of database files
Reply all
Reply to author
Forward
0 new messages