Author Archive for WebGuru

Is the Read-Only attribute on OS Oracle data file a bug for Oracle 10g?

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

How to create email distribute list: import contacts into Outlook contacts easily

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.

  1. Open the .csv file with Microsoft Excel or another program to prepare the data for export.

  2. The open file should be similar to the image shown below.
  3. 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.

  4. The Excel file should look like the image shown below.

  5. Save the Excel spreadsheet as a ” Comma Separated Value ” file with a .csv extension on to your Desktop.
  6. 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

How to watch Beijing Olympics Games live overseas online

Beijing2008Since 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

How to display 0 in conditional [group by] report in Count() SQL Query

sql-injection-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

How to organize the large email boxes in Microsoft Outlook

Outlook_2003 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

How to home network with your Cable and DSL broadband services

Comcast I tried to write up a 3-step How-Tos for getting VOIP through broadband 3 years ago, but never got a chance to finish them. Today, one of my friends asked my help on setting up his home networking over Comcast cable broadband. Then I decided to use some time now to point out one or two important things in the should-be-published-early first step - "how to set up a home network over your broadband without paying extra to your provider".

Usually the broadband providers only provide one computer network service with the regular price and will charge extra for residences to get more than one computers online. But if you already have purchased a router, you should be fine to get the home networking by your own. Just remember some extra steps you need to pay attentions to.

Continue reading ‘How to home network with your Cable and DSL broadband services’

Related posts

How easily to create a required validator requiredfieldvalidator for CheckBox control in asp.net 2.0

Challenge:

Asp.NET I tried to add a CheckBox control to the registration page in my newly implemented open source YetAnotherForum asp.net application. And this CheckBox is for Terms and Conditions agreement, so it needs to be checked before the users submit registration form. It looked like the easy way was to use a RequiredFieldValidator to validate the CheckBox control. But unfortunately this RequiredFieldValidator validation Web control does not work with the CheckBox (or CheckBoxList) Web controls. After I set its ControlToValidate property to the ID of the CheckBox, the page threw an HttpException, saying:

"Control ‘controlID’ referenced by the ControlToValidate property of ‘validationControlID’ cannot be validated." 

Ok, I can perform the validation check in the postback code or replace the RequiredFieldValidator with CustomValidator control. But this is for a constantly updated open source application, I did not want to change too much source code in case I will get overwritten in the next release. So, I need a quick and dirty way to do this.

Continue reading ‘How easily to create a required validator requiredfieldvalidator for CheckBox control in asp.net 2.0′

Related posts

Will Cuil kill Google?

cuil Yesterday (7/28/2008) all media were talking about a new launched search engine called CUIL (pronounce cool). Does it really become a threat to Google or other search engine? I say no, at least now. The conclusion was based on my own tests and comparisons. What is Cuil anyway? Cuil was founded by a former Google employee named Anna Patterson along a few other former Google engineers. Instead searching keywords in web pages like Google is doing, Cuil is trying to analyze the contents of all web pages and give the search results. The following is what it says about itself.

About Cuil

Cuil (pronounced COOL) is a search engine that combines the largest Web index with content-based relevance methods, organized results, and complete user privacy. The company’s next generation approach to search is the result of proprietary breakthroughs in search architecture and ranking algorithms. Cuil’s employees have extensive experience in search, having worked at Google, IBM, eBay, AltaVista, Stanford University, the Internet Archive and other technology companies and research centers. Cuil is located in Menlo Park, California and has received series A funding from Tugboat Ventures and Greylock Partners, and series B funding from Madrone Capital Partners. Cuil derives its name from an old Irish word for knowledge, reflecting the background of co-founder and CEO, Tom Costello, who hails from Drogheda, Ireland. For more information, please visit www.cuil.com.

Continue reading ‘Will Cuil kill Google?’

Related posts

How to remote connect to Microsoft SQL Server Express 2005

Challenge: By default, the SQL Server Express 2005 was not installed for remote access. Which means networking protocols are disabled by default in SQL Server Express. Thus, if you simply installed Express and chose all the defaults like I did, SQL Server Express will only be able to have connections originating on the local machine where SQL Server is installed.

That is why I got the following error message when I tried to connect to one SQL Server Express instance installed on another server from my desktop’s SQL Server Management Studio Express.

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

And this is the screen shot I have.

sql_remote_error

Continue reading ‘How to remote connect to Microsoft SQL Server Express 2005′

Related posts

Fix a bug in YetAnotherForum version 1.9.1.8

YetAnotherForumAs my previous post said, I installed Yet Another Forum v1.9.1.8 on my server, then I created a board/forum. In my first and only one forum, I turned on the moderate mode which means that any post topic will not show till the forum administrator approves.

Then I went ahead to create the first new topic, and later on a few replied have been posted. Everything was fine but a few days ago the front page could not be seen. I tried a couple of times, only saw the error messages (There has been a serious error loading the forum. No futher information is available…) as the following screen shot. And funny thing was I still could access to other web pages include the administrative portion.

Error Message

Continue reading ‘Fix a bug in YetAnotherForum version 1.9.1.8′

Related posts

Have I been hacked or something else…

1and1_cclogo Since this late noon, all of my domains on the Microsoft Windows Hosting server at 1and1.com could not be accessed. I called the tech support and was told all A records of my domain names have been pointed to an external IP address (82.165.204.153). Even I swore to the tech support that I did not make any changes on my DNS setup, but she insisted that only the owner of my account (of course, me) can do such changes. And I asked whether they could do some investigations to see who and when made such changes from logs, but I could not get any satisfied answer from her. Anyhow, the important part at this moment was to get all my domains back. So I had to manually change all A records back to my hosting server’s IP addresses. I was glad I only host less than 20 domains on this Microsoft platform, image I would have to change my Unix hosting domains (Shhhhh).

Continue reading ‘Have I been hacked or something else…’

Related posts

IT guy knows the difference between American woman and Indian woman

Please click the +Audio MP3 button below to start.

I could not help but laughing when I heard it first on the wenxuecity.com web. Seriously, if you are younger than 18 years old, please do not listen especially the end of the conversation.

Download Audio American Women and Indian Women
(click Audio MP3 above to play this humor audio now)

Indian Woman
v.s.
American Women

Disclaimer: Again, this is only an interesting audio clip I got from the Internet, which I believe was recorded from a radio show. All characters mentioned in this audio clips were not verified by me or anyone on this blog yet. So please do not reflect to your personal life and do not take it up to the whole India national level. Just enjoy and have a laugh. Just is it!

Related posts

Street View, a cool feature from Google Maps

Google MapsHave you recently used Google Maps? Maybe you already noticed its new feature from the maps, yes, it is called Street View. What can it do? well, when you browser the maps (of course, on the website of http://maps.google.com) and click the Street View button on the map. You will see a little man icon on the map, and some street view photos will appear when you drag “you” (the little man) on some blue line highlighted roads. These photos just like what you can see when you walk or drive on the road of the Google maps.

Continue reading ‘Street View, a cool feature from Google Maps’

Related posts

Yahoo Opens Search Technology To Third-Party Search Engines

By Scott Morrison
Of DOW JONES NEWSWIRES

SAN FRANCISCO -(Dow Jones)- Yahoo Inc. (YHOO) is hoping to boost revenue and steal market share from rival Google Inc. (GOOG) with a new plan that opens its search technology to third-party developers who want to build their own search engines.

The initiative lets partners tap into Yahoo’s back-end search technology - the algorithms and infrastructure that power its search engine - as a Web service, but allows them to control the presentation and ranking of the search results. Those partners, in return, would be required to run Yahoo search ads on their pages, with the two sides sharing revenue.

The Sunnyvale, Calif., company announced the program, dubbed Build Your Own Search Service, or BOSS, early Thursday.

Continue reading ‘Yahoo Opens Search Technology To Third-Party Search Engines’

Related posts