Reinvent Yourself

We grow up every minute, every dat, every year. We learn new things, repeat some things, get more wiser.  Everyone loves to look ahead and move forward. It is also vital to take lessons from our life and reinvent yourself. New goals, resolutions can be made any minute any second. You don't have to wait for the new season, your birthday, new year to do that. There are lot of ways to get motivated and inspired. The basics are the same across. Dedication, Determination brings Motivation. You drive your life. You always have a choice.

To an employee, Do want you love. To be more specific love your work and not your company. This is what gets you motivated to strive the failures. For those aspiring to be a CEO or be a top surgeon have small dreams that a person who is jobless and believes he can change the world. A service that pushes to a better life is always remembered than a person who holds a big office.

Example: Steve Jobs was kicked out of Apple by the new CEO. Since he loved what he did that he started up NEXT and Pixar. The list includes Michael Jordan, The Beatles, Albert Eistein, Jerry Seinfeld, J K Rowling.
 

I begin here with a short note, new thoughts to follow.

Renaming hybridtheorem to zealtheory

I have been thinking about a change for a while. Here I start with the name. I have renamed my blog from hybridtheorem.blogspot.com to zealtheory.blogspot.com.

Oracle 11g: Re-organizing Partitioned and Subpartitioned tables using MOVE command

Recently, I happen to delete 20% of 50 million rows from a table. The queries were performing bad. As you guessed it is the because of the fragmentation. We can re-org the table in different ways in Oracle. Here I describe about how to reorg using the simple ALTER TABLE ... MOVE command.

1) In the case of non-partitioned whole table:

Alter table VAICHE.FULL_TABL move;

2) When the table is partitioned table:

Alter table VAICHE.PART_TABL move partition ;

You can get partition name from all_tab_partitions.

3) When the table is sub partitioned:

Alter table VAICHE.SUBPART_TBL move subpartition ;

You can get names of subpartition from all_tab_subpartitions.

When a table is subpartitioned, you cannot do (1) and (2). You will get error like the below:

alter table VAICHE.PART_TABL move partition xyz;;
ERROR at line 1:
ORA-14257: cannot move partition other than a Range, List, System, or Hash
partition

For a subpartition table reorg, you have to move only the subpartitions. Other steps that need to be performed with reorg are
1) Rebuild Indexes
2) Gather Statistics.

R12: Concurrent Program Error shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory

We faced an issue recently when we migrated our HP superdome to a new one. The concurrent program error out with the following:

shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Error occurred during initialization of VM
java.lang.Error: Properties init: Could not determine current working directory.

Solution: I didn't get a lot of hits on this error with respect to Oracle E-Business Suite. Once forum mentioned of running autoconfig. The root cause was unknown.

I stopped the concurrent managers and ran autoconfig on the concurrent manager server node. (It is always good to run autoconfig on a web tier after executing on concurrent manager). After starting the managers, the program was executed and it completed successfully.

Recent Quotes..

“Only a mediocre person is always at his best. ”— Somerset Maugham

"I will always choose a lazy person to do a difficult job.. Because, he will find an easy way to do it." - Bill Gates

"A person who never made a mistake never tried anything new" -Albert Einstein

"Give me six hours to chop down a tree and I will spend the first four sharpening the axe." - Abraham Lincoln