moving ts
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: moving ts

  1. #1
    Join Date
    Aug 2001
    Posts
    184

    how do i move data files for a ts to another directory? my task is to move XXX_DATA ts to E: drive. os is win2k, oracle is 8.1.7.
    OCP DBA 8i
    ocpwannabe@yahoo.com
    -----------------------------
    When in doubt, pick 'C'.

  2. #2
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Move the datafile and recreate the controlfile.

    Tablespace cannot be moved but the datafile.
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  3. #3
    Join Date
    Jul 2000
    Posts
    521
    Take the TS offline.
    Move the datafiles to other location.
    Use the RENAME DATAFILE part of ALTER TABLESPACE command.
    svk

  4. #4
    Join Date
    Mar 2001
    Posts
    635
    Hi

    This link should help you.Try to make a search on this forum you will find tons of info by just searching

    http://dbasupport.com/forums/showthr...threadid=17111

    Regards
    Santosh

  5. #5
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684

    Thumbs up

    Hi.

    CONNECT sys/password AS SYSDBA
    SHUTDOWN IMMEDIATE

    -- Move the file to the new location using Windows Explorer

    STARTUP MOUNT PFILE=ORACLE_BASE/admin/SID/pfile/init.ora
    SELECT name FROM v$datafile;
    ALTER DATABASE RENAME FILE 'E:\ORADATA\SID\file.dbf' TO 'F:\ORADATA\SID\file.dbf';
    ALTER DATABASE OPEN;

    The rename won't work if you put in incorrect stuff so don't worry.

    Obviously, substitue you path details. The select is just to remind you.

    Sometimes NT/2000 gets a bit funny about moving files unless the service is switched off. If explorer won't let you move the file switch the service off using the services dialog:

    Start->Programs->Administrative Tools->Services (2000)
    Start->Settings->Control Panel->Services (NT 4.0)

    or use:

    C:> NET STOP OracleServiceSID

    You might want to do a backup before you start. You should definitely backup the controlfile once you've finished.

    Have a good one.
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  6. #6
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Wow! In the time it took me to type the answer 3 people had already got in. I need typing lessons
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width