Results 1 to 5 of 5

Thread: moving datafile

  1. #1
    Join Date
    Jun 2010
    Posts
    81

    Unanswered: moving datafile

    Hello,

    I have a disk above threshold (85%) and I need to clear some space. The only things residing
    on this disk are tablespace datafiles. I wonder is it possible move the files from here to a disk
    with adequate space and do I need to modify/alter the path of the tablspaces involved.

    If any one has the steps involved could you please publish or provide a link for me to perform this task.

    Many thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2010
    Posts
    81

    No need to be so rude Anacedent

    Anacedent,

    Maybe you are well versed in Oracle Admin, but you are very off putting with your comments.
    Sometimes you can google something and it is still not clear as when someone explains it in laymans terms.
    I do not see what buzz you recieve from trying to be-little people in this condisending manner.
    Maybe just for once either do not answer the question or let someone else who can help - offer a solution.
    Give the poster the benefit of the doubt that they have researched and are still unable to come up with a
    concrete or concise answer.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Ask Tom "Moving datafile (non system)"

    Ask Tom "moving tables across tablespaces"

    moving datafile is an Operating System dependent operation & you decided we did not need to know your OS. Why not?

    Why should I write here what has been written many times in many places?
    If you can not read & understand there, why should you do better here?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    newdbaxchange, if there's a part of the procedure that's not clear to you then by all means ask for help in explaining it better. But don't expect people to guess what you don't understand.

    If any one has the steps involved could you please publish or provide a link for me to perform this task
    You asked for a link, you were given one.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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