+1 401 783 6172 (International callers)
gary@skillbuilders.com
Request Info
Register Login

Login/Register to Access all of Skillbuilders' Content

Connect with:

Login with Facebook Login with Google Login with LinkedIn

Login with your site account

Connect with:

Login with Facebook Login with Google Login with LinkedIn


Lost your password?

Not a member yet? Register now

SkillBuildersSkillBuilders
  • Services
    • Oracle APEX Hosting on AWS
    • Oracle Database Admin/Remote DBA
    • Oracle APEX App Development
    • APEX Administration
  • Products
    • Oracle Database Manager (free)
    • Deprecated APEX Plugins
  • Training
    • Course Calendar
    • Oracle DBA
    • Oracle Developer
    • Oracle APEX
    • Web Development
    • Free Webinars
    • Mentoring
    • Free Oracle Database Tutorials
      • Free Oracle Database Administration Tutorials
      • Free Oracle Developer Tutorials
      • Free Oracle APEX Tutorials
      • Free Solaris 11, Oracle VM and ZFS Tutorials
      • Free Oracle Database Retired Tutorials
      • Free Groovy and Grails Tutorials
  • Blog
  • About
    • About Us
    • Our Team
    • Events
    • Case Studies
      • Oracle Database Administration
      • Oracle APEX Development
      • Oracle APEX Administration
      • Oracle and AWS Cloud
    • Client Testimonials
    • Contact
    • Services
      • Oracle APEX Hosting on AWS
      • Oracle Database Admin/Remote DBA
      • Oracle APEX App Development
      • APEX Administration
    • Products
      • Oracle Database Manager (free)
      • Deprecated APEX Plugins
    • Training
      • Course Calendar
      • Oracle DBA
      • Oracle Developer
      • Oracle APEX
      • Web Development
      • Free Webinars
      • Mentoring
      • Free Oracle Database Tutorials
        • Free Oracle Database Administration Tutorials
        • Free Oracle Developer Tutorials
        • Free Oracle APEX Tutorials
        • Free Solaris 11, Oracle VM and ZFS Tutorials
        • Free Oracle Database Retired Tutorials
        • Free Groovy and Grails Tutorials
    • Blog
    • About
      • About Us
      • Our Team
      • Events
      • Case Studies
        • Oracle Database Administration
        • Oracle APEX Development
        • Oracle APEX Administration
        • Oracle and AWS Cloud
      • Client Testimonials
      • Contact

    Free Oracle DBA Tutorials

    • Home
    • All courses
    • Free Oracle DBA Tutorials
    • How to Move Datafiles in Oracle Database 12c

    How to Move Datafiles in Oracle Database 12c
    Duration: 50 hours

    John Watson
    Free Oracle DBA Tutorials

    No reviews yet.
    Free
    • Description
    • Lessons
    • Topic Summary
    • Instructors
    • Reviews

    How do you move a datafile in an Oracle Database? Well, it just got a lot easier in 12c! Watch this free video tutorial where OCM John Watson of SkillBuilders will demonstrate both techniques, 11g and 12c.

    There are many reasons to move a datafile in an Oracle database. Here are just a few:

    • Renaming datafiles to a standard
    • Moving from one file system to another
    • Converting from file system storage to ASM
    • Changing from SAN to NFS storage

    In 11g, we need to take the tablespace offline, meaning downtime. Argh!

    In 12c, all that is required is ALTER DATABASE MOVE DATAFILE; this is an online operation with zero downtime (in 11g we use ALTER DATABASE RENAME DATAFILE). Even “critical” files such as the files associated with the SYSTEM tablespace can be moved online. Consider the ease of moving to ASM this provides!

    This also functions in an Active Data Guard standby environment. And, there are syntax options that allow you to keep or delete the original file. Very cool stuff.

  • Call 1-401-783-6172 for Group or Alumni Discounts.
    If you are a student of an accredited academic institution call us for a 25% discount.

  • No Events Scheduled at this time. Call +1-401-783-6172 or email us to schedule this class.
    • Share:
    • Tutorial Lessons 0/3

      • Lecture1.1
        Agenda
        0m
      • Lecture1.2
        Introduction and Demonstration of 11g Tech
        Preview
        2m
      • Lecture1.3
        Demonstration of 12c Technique
        1m
    John Watson
    https://skillbuilders.com/our_team/john-watson/

    Please take this tutorial in order to review.

    No reviews yet.

    • Description
    • Curriculum
    • Topic Summary
    • Instructors
    • Reviews
    Free

    Featured Courses

    Backup and Recovery with Oracle RMAN

    January 25, 2021
    $2,700.00

    Oracle PL/SQL Programming Workshop

    January 25, 2021
    $2,700.00

    Intermediate Oracle Application Express (APEX) Training

    January 25, 2021
    $2,700.00

    Oracle Database: Managing Multitenant Architecture

    February 1, 2021
    $2,100.00

    Copyright © Skillbuilders.com

    Interested in joining our team?

    View details
    Managed APEX Hosting on AWS

    Sorry. This form is no longer accepting new submissions.

    Register for this Class
    • Please enter a number from 2 to 5000.