All entries for Friday 31 March 2006

March 31, 2006

java.sql.Date and java.sql.TimeStamp

I forget the followings:

java.sql.Date only display the date info, the time part is rounded to 00:00:00. If you want to display time , using TimeStamp.


Upgrade database servers

Experience of Upgrading Server:

  • I tried different methods to upgrade: dbua in GUI mode and slient mode. Either works fine. GUI mode discloses more information about which component to upgrade. This can help you to drop unused componnent before upgrading, for instance, JServer take a great time to upgrading. It is wonderful to drop it.

  • The following paragrah is rather confusing.
The SYSAUX tablespace must be created after the new Oracle Database 10g release is started and BEFORE the upgrade scripts are invoked.

Search this blog

Search Warwick Blogs

 

Tags

Most recent comments

  • Oracle 11g is the clear leader in this area. Oracle has invested heavily into self–tuning capabiliti… by shaane on this entry
  • All the features are very nice.I like Repair Advisors the most.Oracle 10G introduced some of the dat… by lucy on this entry
  • "logical standby failed to re–start, I am also getting the same error. I have search on internet and… by anemia on this entry
  • Thanks for the nice information because from last three days i am stuck on this problem…. by robot vacuum on this entry
  • So what happen City speed dating when you tried this coding once in your PC.. Please tell me so i am… by John Bergeron on this entry
Not signed in
Sign in

Powered by BlogBuilder
© MMXXII