WebGuru’s Blog about Digital Life

In today’s Oracle 10g training, we were asked to do a exercise on tablespace. I needed to make a tablespace Read Only and Read Write. The syntax was simple, just “ALTER TABLESPACE tbs READ ONLY (READ WRITE”. But while I was playing around, I thought what would happen on the data file after I turned on the Read Only with the tablespace. So I checked the data file (like c:\oracle\oradata\something.dbf) and found out it did not have Read-only attribute even after I altered the tablespace as Read Only. Interesting, it seems the Oracle did not look up the OS level when it deals with the tablespace read-only attributes.

To make things more interesting, I turned on the Read-Only attribute for this tablespace’s data file (Right Click, and check the Read-Only in the proprieties window). Then I went ahead to make more alterations on the tablespace, like increasing the extents size etc. The funny thing was I could see these system changes in Oracle through some dba_ views, but actually they did not take effective. Since I could not insert any new record to a full tablespace even I “successfully” increase the size in Oracle.

Not sure Oracle already aware this situation or not.

Ok, finished the installation of Oracle 9i on the new machine. It is time for me to move all existing data from my old machine to this new server. I do not want to create all stuffs from the scratch, and do not want to use exp/imp utility either. I thought there should be a easy way to do so. Since I am a web designer, I will give such question to the DBA in my team.

It turns out there is an easy way, yeah!

Here are some steps I did to move all data from the old machine to new machine with the help of my DBA co-worker. Continue reading ‘How easily to move Oracle data from one machine to another’