Empowering Your Business with Advanced ICT Solutions
Call Us : +64 274797626

Simple DBA blog

Oracle 12c with another great feature, moving datafile / tempfile.

Unfortunately TEMPFILES can’t be moved, but can be dropped and recreated OR recreated (with another file name) and dropped.

WHILE THE DB is ON-LINE,

1) alter database move datafile <source destination – full path within single quotes> to <target destination – full path within single quotes> ;

IT does everything on the fly, great feature and handy for all DBA’s.

for more info http://docs.oracle.com/database/121/ADMIN/dfiles.htm#ADMIN13837

Leave a Reply

Latest Posts

Reach Us

42 Melksham Dr
Churton Park, Wellington 6037
New Zealand
Phone: (64) 4 472 0664
Mobile: (64) 27 4 SYSMAN

Find Us