iPod Classic Adventures

Tuesday, October 15, 2013

Every couple of months, my daughter comes home with some new challenge for me to resolve with her iPod Classic.  I thought resetting the iPod would solve just about anything she could possibly do to inhibit the normal function of the device.  That is until she decided to set a passcode and promptly forgot what she set it to.  I quickly discovered there is no relying on the old “Reset” method.

Fortunately, a quick search of “ipod classic forgot passcode” on Google yields a YouTube video to solve the problem. The instructions are simple to follow and gave me a little insight on how Apple went about locking the device.

This post is a little out of the norm from my prior postings, but  I am sure I will reference this again in due time.  I am thankful for Google, YouTube, and the person responsible for posting “Unlocking Ipod Classic (Without Having to Restore To Factory Settings)”.


Oracle10g Privileges to Create Materialized Views

Thursday, June 26, 2008

In a previous post, I mentioned the privileges required to create materialized views in Oracle8i and Oracle9i Standard Edition. In Oracle10g, the requirement appears to be much more simplified.

Just needed to grant the CREATE MATERIALIZED VIEW system privilege.

MIKE@statest> select * from user_sys_privs;


USERNAME      PRIVILEGE                         ADM

MIKE CREATE MATERIALIZED VIEW NO

Roles granted are listed below for completeness of the topic.

MIKE@statest> select * from user_role_privs;


USERNAME       GRANTED_ROLE             ADM DEF OS_

MIKE CONNECT NO YES NO MIKE RESOURCE NO YES NO

We are running Oracle10g Release 2 Standard Edition in which QUERY REWRITE is not an enabled feature. Describing what I mean, I create a test table below upon which the materialized view will be based.

MIKE@statest> create table t1 as select owner,object_name,object_type from all_objects;

Table created.

MIKE@statest> select count(*) from t1;

COUNT(*)
———-
4196

Again when I attempt to create the materialized view with the “enable query rewrite” clause, I encounter the “feature not enabled” error.

MIKE@statest> create materialized view mv_test
2 refresh complete on commit
3 enable query rewrite
4 as
5 select object_type, count(*)
6 from t1
7 group by object_type;

from t1
*
ERROR at line 6:
ORA-00439: feature not enabled: Materialized view rewrite

I remove the “enable query rewrite” clause and the materialized view is created successfully.

MIKE@statest> create materialized view mv_test
2 refresh complete on commit
3 as
4 select object_type, count(*)
5 from t1
6 group by object_type;

Materialized view created.

References
Oracle Database 10g Product Family

Additional information on materialized views from Oracle8i to Oracle11g can be found on this post.


Java Version

Wednesday, March 7, 2007

Being a DBA who supports Java Developers, I try understand a little about Java.  When recently trying to determine what version of Java was installed on a server, I found Java Tester while searching with Google.

Navigating to the Java Version link, I was able to find my answer.  There is other good basic Java information found on the web site.

In addition there is the Oracle Java Technology Reference or OTN’s Java Programing Center.

Update 24-Dec-2011

Answer to finding JDK location on Windows or Unix at Stackoverflow.

Also for finding the Java version, you can also run the command below:

C:\> java -version
java version "1.6.0_29"
Java(TM) SE Runtime Environment (build 1.6.0_29-b11)
Java HotSpot(TM) Client VM (build 20.4-b02, mixed mode, sharing)