Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Location
    Universe.MilkyWay.SolarSystem.Earth.NorthAmerica.Canada.Quebec.Chicoutimi;
    Posts
    9

    Question Unanswered: how to move oradata

    Hi fellows,

    I need to know if there is a way to move (not copy, move) the oradata folder (containing tablespaces and data) and make Oracle know where it is situated.

    I am using Oracle 9.2 on a too small disk and when i try to import a massive amount of data, it fills entirely the disk and end on an error : disk full.

    Thanks for help,

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    This statement:
    alter database backup controlfile to trace

    Then shutdown the database.
    Move your files.
    Edit the generated trace file in your udump directory, and change the paths/filenames you just moved.

    Execute only the first statement of the trace file (create controlfile).
    This will re-create your controlfile with the correct filenames of your datafiles.
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

  3. #3
    Join Date
    May 2003
    Location
    Universe.MilkyWay.SolarSystem.Earth.NorthAmerica.Canada.Quebec.Chicoutimi;
    Posts
    9

    Cool

    Originally posted by Ruudboy
    This statement:
    alter database backup controlfile to trace

    Then shutdown the database.
    Move your files.
    Edit the generated trace file in your udump directory, and change the paths/filenames you just moved.

    Execute only the first statement of the trace file (create controlfile).
    This will re-create your controlfile with the correct filenames of your datafiles.
    Excellent ! It works fine thank you very much.

  4. #4
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Thumbs up

    If you hjave another disk, then you can move tablespace by tablespace:

    1. ALTER TABLESPACE tblspc_name OFFLINE;

    2. Move the files for this tablespace with move/copy.

    3. ALTER DATABASE RENAME FILE 'old_location/file.dbf' TO 'new_location/file.dbf' for every datafile.

    4. ALTER TABLESPACE tblspc_name ONLINE;



    Hope that helps,

    clio_usa - OCP - DBA

    dbaclick.com

Posting Permissions

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