Published on
August 27, 2008 in
Database.
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.
Related posts
I need to post a serial how-to in Outlook for some of my clients. This one is part of “how to create email distribute list” and copy & paste from this website.
If you have e-mail addresses or other contact information in a program and want to import the data into Microsoft Outlook, follow the steps below.
Export and Convert the Data
Use the program’s export or save as feature to save the data into a “Comma Separated Value (.cvs) file to enable it to be imported to the Outlook Contact list.
-
Open the .csv file with Microsoft Excel or another program to prepare the data for export.
- The open file should be similar to the image shown below.
-
To successfully import these addresses over to Outlook proper labels must be assigned to the enteries in the Excel file. Insert a row above the current list of entries. Name the three column headings as Nick Name, Full Name and E-mail Address appropriately.
-
The Excel file should look like the image shown below.
- Save the Excel spreadsheet as a ” Comma Separated Value ” file with a .csv extension on to your Desktop.
- Click Yes if prompted to retain the format of the Excel file and then close the Excel program.
Continue reading ‘How to create email distribute list: import contacts into Outlook contacts easily’
Related posts
Since only NBC has the exclusive authorization to broadcast all Olympics 2008 games in America, and it only shows American team games at evening prime times. It is very hard to watch some interesting games at real time if they do not have American team participation and not take part in American prime time. I thought I could do it from the internet like before. But this time unfortunately the normal way of watching stream video online does not work since all official Olympics partner websites only open to China region users. That means these video sites block all overseas IP addresses from watching games live.
Continue reading ‘How to watch Beijing Olympics Games live overseas online’
Related posts
Published on
August 7, 2008 in
Database.
Challenge:
Let me assume this: we have two tables, one is Regions table with all region information (East, West, etc. ) and we have another table with Sales information. Now, we need to display a report with region information and how many sales conducted in each region with greater than $1000 value in each sale. It sounds simple at the beginning since a Count(*) with Group By can do this trick.
But what if I need to still show the region which does not have any sales greater than $1000 on the report? Using Count(*) itself in the query, the region without any sales greater than $1000 will not show in the query result, period.
Continue reading ‘How to display 0 in conditional [group by] report in Count() SQL Query’
Related posts
Last Friday, I spent half of my day on helping my friend to clean up its Outlook files. The main reason was that he kept all his emails since day one and the mail box was too huge to accept any new incoming emails (not sure the limitation on PST file from Microsoft is now still 2GB or not). I understand the importance of archiving correspondences between clients and my friend, so my strategy was to split all emails into a few PST (Personal Folders File) files which would be under the size limitation. And at the meanwhile, I set up an auto archive mechanism to move old emails to other pst file in the future automatically.
I know I was supposed to send him a detail instructions on how to do such things as my promised. But I could not get close to the computer during my busy weekend. So I am publishing all my steps here today, for him it will be a instruction via URL; and for all of you (include myself), a future reference post.
Continue reading ‘How to organize the large email boxes in Microsoft Outlook’
Related posts
Blog Comments