Seeking Oracle out of the matrix

Google
 
Web aboutoracle.blogspot.com
Oracle New Articles
Oracle Critical Patches
Oracle jDeveloper News
Oracle Blogs of interest


This blog records my personal experience.
Latest news from the front
               

Thoughts about oracle Author's note : Thank you all for your supporting letters. You have been a motivation to this web spot's posting. I wish you all the very best for you and your families for the new year.
Interested to know about a next post? You can suscribe to my RSS feed
HOW TO:

TIP: How to move a datafile from one hard disk to another (quick way)
Saturday, February 24, 2007
If you want a newer, fresher and quicker method to move a datafile from one disk to another here is the way to do it : Make sure the tablespaces are read-only and then


  1. alter tablespace users offline;

  2. copy c:\mydb\users01.dbf e:\mydb\users01.dbf

  3. alter database rename file 'c:\mydb\users01.dbf' to 'e:\mydb\users01.dbf';

  4. alter tablespace users online;



then make your tablespaces read write again,
and you're done :-)

More information : Note:115424.1 on Metalink

Labels: , , ,


posted by Admin @ 9:32 AM  
add to del.icio.us Digg it! Furl this! add to reddit! add to dzone!
34 Comments:
  • At 3:26 PM, Blogger R2K said…

    : )

     
  • At 10:15 PM, Blogger cy21 said…

    Hi there,
    I love your blog! I also have a Script Blog. PRogramming for the web. Are you interested in link exchange?
    my blog is:
    http://wd-scripts.blogspot.com/

     
  • At 2:05 AM, Blogger cy21 said…

    thank you for linking....I have added both of your blogs to my list....thank you very much :)

     
  • At 5:35 AM, Blogger askme said…

    love the blog! loyal reader! please help me get my blog started! much appreciated! http://askme-askme.blogspot.com/

     
  • At 7:16 PM, Blogger Pablo Ignacio Cerda Rastello said…

    "Tachando el calendario"

     
  • At 1:21 AM, Blogger Malcolm said…

    neat

     
  • At 1:50 AM, Blogger Casey said…

    Great Blog , I'm added this to my links...

     
  • At 1:58 PM, Blogger BLOG DE MARIO LUIZ DE MELLO said…

    Hi:

    Your blog is amazing. It´s talk about some goods IT issues.

    Thanks

    Mario
    Brazil
    http://blogdomariomello.blogspot.com

     
  • At 9:52 AM, Blogger Shahana said…

    wow, nice simple way :)

     
  • At 4:27 PM, Blogger Weight Master said…

    Thanks for visiting my blog. Great info. You're linked to weight-master.blogspot.com

     
  • At 7:53 AM, Blogger Speedcat Hollydale said…

    I tried to have windows translate this page to English, and it did not work. I am flabbergasted!

    Anyhooo......I think you are a "Geeeenious"

    Speedcat Hollydale (famous poet)

     
  • At 12:50 PM, Blogger RUCHIBHATT said…

    Hi! Friend!.it was really tedious to locate you..but anything for u..5 stars..added you as friend! Visit me at ruchibhatt.blogspot.com and leave your comments! I wud love to hear frm u. nice writup keep blooging..maintain faith..one day u will b a top bloggie dear..just write according to the current pulse and add videos, pictures to make it attractive and phir MAIN HUN NA!

     
  • At 3:45 PM, Blogger yashuwa said…

    Hello,
    yashuwa.blogspot.com

     
  • At 10:30 AM, Blogger michael said…

    Nice to meet u!
    Welcome to my blogger which it's in
    Chinese.
    link:http://500518.blogspot.com/

     
  • At 10:51 AM, Blogger ChrisWoznitza said…

    Hi ich bin Chriswab aus Bottrop. Viele Grüsse !!

     
  • At 4:45 AM, Blogger jwanmavideos said…

    coooooooollll!!!

     
  • At 11:08 AM, Blogger New Updates said…

    thanks for the tip. it worked. Good luck with your blog from our new service adblogz.blogspot.com. It's the top place for advertisers to reach blogworld and for bloggers to save real money when you're blog shopping. Try it today and see for yourself.

     
  • At 5:06 AM, Blogger Jason said…

    OK, please let the next post be "How to move a datafile from one hard disk to another(dangerous way)"

     
  • At 12:44 PM, Blogger Pushpendra said…

    AWESOME BLOG, CAN YOU TELL HOW CAN I ADD THIS BLOG IN MY LIST?

    GREAT JOB MATE!!

     
  • At 8:22 AM, Blogger david santos said…

    Thanks for you work and have a good week.

     
  • At 9:00 AM, Blogger syabie said…

    thanks for the tips. It's helped in my work.

     
  • At 8:39 PM, Blogger Kasal RP said…

    How can I change my template???
    I have tryed several times but every time an error message appears...

    Please help me, I need to put a three columns template on my blog...

    Visit Us: www.kasalrp.com

    Kisses and thankssssss
    KasalRP

     
  • At 2:44 AM, Blogger Jason said…

    Hey thanks! You saved me sooooooo much time.

     
  • At 4:49 AM, Blogger Chris said…

    Thank you for the help.

     
  • At 1:16 PM, Blogger Finazio said…

    congratulations for your blog!

     
  • At 9:11 PM, Blogger trackrunner4life said…

    nice blog =)

     
  • At 9:27 AM, Blogger indianshawls said…

    nice blog

     
  • At 1:22 PM, Blogger All Blog Spots said…

    nice blog

     
  • At 4:47 AM, Blogger onlin4u said…

    I love your blog-Have a great day

     
  • At 1:04 PM, Blogger Business Credit Card Site said…

    hey thanks! I'll take note of this. BTW, I like your blog.

     
  • At 6:53 AM, Blogger Able Answer said…

    http://usedcarsecrets.blogspot.com thanks you for you advice, It is true that the room for error has all but disappeared. We must help each other more. Good Luck. -Able

     
  • At 5:03 PM, Blogger bhushan said…

    hi we followed the steps mentioned by you for moving the data file. After that we are trying from whole day but datafile is always in offline mode . we are getting following error .

    place tablespace USERS online failed with the following error: ORA-01113: file 4 needs media recovery ORA-01110: data file 4: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF' .

    If you have any idea about this error please let me know at bhushan.tomar@gmail.com

     
  • At 5:32 PM, Blogger Admin said…

    Maybe
    Note 115424.1 HOW TO RENAME OR MOVE DATAFILES AND LOGFILES
    Note 10662.1 RENAMING DATABASE FILES
    Note 9560.1 ALTER TABLESPACE/DATABASE TO RENAME FILES

    will help you

     
  • At 4:04 AM, Blogger 文章 said…

Post a Comment
<< Home

About Me

Name: John Galanopoulos
Home: The NeverLands
About Me: A source code wonderer since the early 80s with my first ZX81 by Sinclair, home computer.
See my complete profile
Previous Post
Archives
Links
ΣΚΛΗΡΥΝΣΗ ΚΑΤΑ ΠΛΑΚΑΣ - ΕΓΚΕΦΑΛΟΣ - ΕΓΚΕΦΑΛΟΓΡΑΦΗΜΑ - ΑΝΟΙΑ - ΝΕΥΡΟΛΟΓΟΣ - ΨΥΧΙΑΤΡΟΣ - ΛΟΙΜΩΔΗΣ ΜΟΝΟΠΥΡΗΝΩΣΗ - ΠΑΡΚΙΝΣΟΝ - ΑΓΧΟΣ - ΚΑΤΑΘΛΙΨΗ - ALZHEIMER - EPSTEIN BARR Eurolife
Email notification

Enter your email address and get notified whenever there is a new post:

Delivered by FeedBurner

This website abides by a strict policy : no spam, just posts; and that's a promise.

Powered by

Free Blogger Templates

BLOGGER


Register for a skinnyscore at www.blogskinny.com and increase traffic
Software Blogs -  Blog Catalog Blog Directory

© 2005 Seeking Oracle out of the matrix Template by Isnaini Dot Com