Sunday, May 29, 2005

Weekends is short

Really really short :'(

Saturday, May 28, 2005

BuzzCity Bogus?

Can anyone tell me is BuzzCity (http://www.buzzcity.com) a bogus website? I have no time to check on them and so I am relying on anyone who may happen to barge into my blog to help me out.

Sunday, May 22, 2005

10GB Free

Nearly forgotten about this. I sent my laptop for servicing few weeks ago. My laptop was having a mere 4KB of bad disk sector and a suspected LCD problem. Fujitsu engineers had determined that my LCD is perfectly okay. As for my harddisk, they replaced it for free with a 40GB brand new harddisk instead of getting a same size harddisk as my original one because they could not find a 30GB harddisk. My laptop is on warranty and so the replacement is free-of-charge! So happy.

Star Wars 3

Went to buy a pair of tickets for Star Wars at Orchard Cinneleisure early in the morning 10am plus. I, being a M1 user, am entitled half price for the 2nd ticket. Yeah!

Overall, the show was average only at least in my opinion.

Sunday, May 15, 2005

Friday, May 13, 2005

Friday the 13th

I don't reckon anything bad is going to happen to me.
At least it never happen on any Friday the 13th.

Thursday, May 12, 2005

Suspend Cleanup Duties

I have officially announced temporary suspension of my voluntary cleanup duties on EE. See you guys in an approximately 211 days later.

Wednesday, May 11, 2005

Laptop Sent for Servicing

Finally, my laptop is sent for servicing. Hope I can get a new LCD and a new harddisk if possible. Hehe..

Sunday, May 08, 2005

Happy Mother's Day

Happy Mother's Day to all mothers.

Zoo Trip YEAH

Went to the zoo today with Regine, her sister, and her sister's boyfriend. Weather was hot but I still find it quite fun. We took quite a lot of photos and I must admit many were quite well taken. Too bad we don't have the time to make a trip down the Children's World and have a ride on the tram.

Overall, it was truely fun.

Saturday, May 07, 2005

Friday, May 06, 2005

Thursday, May 05, 2005

Backup All Blog Post

I am too afraid of losing my blog post. I will backup all blog posts onto a database soon hopefully within this week.

Regine's Last Paper

4th May is Regine's last paper. I can see she really is very excited over it. Ya, we went for a ktv session from 2pm till 7pm that same day with Regine's JC friends at Clementi KBox. We then went to HollandV for dinner and a drink.

Tuesday, May 03, 2005

NUS Summary

I shall now summarize the 2 short years of my life in NUS.

I knew life in NUS will be of few friends from my poly friends (girls) who enrolled before me. They told me it is always difficult to make new friends especially those from JCs. Those from JCs usually have their own usually big group of buddies and when come to forming groups for projects, they are always together. So, it is good to come in with someone whom you know of especially if you are from poly. I am from poly but I am the only one enrolling in year 2003/2004. Girls enrolled 1 year before me and all guys enrolled 1 year later than me because they choose not to disrupt from NS.

Pre-NUS
I conducted a medical checkup at NUS one hot afternoon. That was the first day I set foot on NUS. As required by NUS for all poly students, I took QET (Qualified English Test). I bumped onto a primary school friend, Francis. We lost contact after PSLE even though he lived just opposite my block. Francis was from NP. The paper was tough and as expected, I failed the paper. I attended a seminar for poly students on how to choose modules. I saw Francis and made more friends all being Francis's friends. They are all from NP. From them, I heard all failed the QET except one. I think that was expected since all of us did not have exposure to English writing for at least 5 years. I had set myself Bachelor in Computing (Tech Focus). Getting a Honours degree never came to my mind because I knew there are far too many modules like Mathematics modules, Physics module, life science module, Singapore Studies module, and General Education modules that will kill poly students. Our Mathematics, Sciences and English capabilities are far behind others. Let's settle for a Merit instead of a 2nd Lower of 3rd class honour degree. 2 years and get out of it.

Orientation
I attended the NUS orientation but only turned up for 2.5 days out of the total 5 days - first day, third day and the half day on UNIX workshop. Through this orientation, I got to know friends like Regine (who became my girlfriend later), James, Peiru, etc.

Bid for Modules
Bidding for modules with virtual points? That's new. From recommendations from my poly friends (girls), I chose my modules carefully. After all, they are my seniors. I bidded for 5 modules and they are, 1) CS2104 - Programming Language Concepts, 2) CS2106 - Operating Systems, 3) CS2250 - Fundamentals of Information Systems, 4) MA1505C - Mathematics 1, and 5) GEK1505 - Living With Mathematics. I took an additional 6th module ET1000 to satisfy the English requirement.

2003/2004 Sem 1
I dropped CS2250 - Fundamentals of Information Systems because I find that module too business-like. I never like this type of module. I prefer technical stuff. This means I had only 4 modules this semester and I would need to take an additional module to make up for this. ET1000 is a module I love. Lots of interaction and chatting. Class size is small and we have discussion groups instead of lectures. Everyone know one another. From ET1000, I get to know friends like Wenkang, Rui Kai, etc. MA1505C is a module I dislike (not hate). I spent most of my time on MA1505C. Mathematics used to be my strongest module in primary and secondary school days but in NUS, I am handicapped. I was at the science library reading the Calculus RBR textbook most of my free time. From this semester, I got to know friends from other poly like Francis (NP), Ziwei (NP), Chunyin (NP), and Peiru (NYP). We worked together as project mates from this semester onwards.

2003/2004 Sem 2
I took 6 modules this time to make up the one I dropped 1 semester ago and they are 1) CS1231 - Discrete Structures, 2) CS2105 - Computer Networks 1, 3) CS3240 - Human Computer Interaction, 4) LSM1302 - Genes and Society, 5) MA1101R - Linear Algebra 1, and 6) ST1232 - Probability & Statistics. LSM1302 and MA1101R were not my cup of tea but I still have to take them. CS1231 is another Maths-like module even though it is prefixed as CS (Computer Science). CS1231 is all about proving mathematical methodologies, formulas, graph theories, and probabilities. Notice the so many non-CS modules here. I hate them! There is particular one friend whom took 2 modules with me! Regine is the one! She also took CS1231 and LSM1302. It was this semester whereby we got to know each other better. She eventually became my girlfriend.

2004/2005 Sem 1
I took 5 modules and they are 1) CS2281 - Programming in UNIX, 2) CS3235 - Introduction to Computer Security, 3) CS3266 - E-Commerce Technologies, 4) EC1301 - Principles of Economics, and 5) GEK2000 - The U.S. From Settlement to Superpower.

2004/2005 Sem 2 (Final Sem)
I took 4 modules this time and they are 1) CS2301 - Business and Technical Communication, 2) CS3214 - Information Systems Development Project, 3) FNA1002 - Financial Accounting, and 4) SSB2216 - Employee Management In Singapore. 4 modules do not imply easy semester. This is because one of them, CS3214, is a big final year project. I was grouped with Francis, Ziwei, Chunyin and Peiru.

Post-NUS
I knew I will miss NUS. I will miss everything. Life in NUS is very much different from primary, secondary and poly life. In NUS, competition is too strong and many have shown their true colours.

Some have proven to be selfish and they have the calibre of a 100% hypocrite. He can go around telling people "I did not study", "I will definitely fail", etc. but then in the end, he is always studying. I don't understand why make it so obvious that you are studying very hard, spending sleepless nights, and at the same time going around telling others his famous quotes.

There is another group of people whom I classify as free loader. These free loaders always don't like to contribute in a group project. They can sleep during group discussions, appear to be busy, appear to be indifferent, always seen to be complaining about workload, always seen to be complaining on lecturers, etc. Free loaders are very clever because they can get away with it and share equal grades for the group project. Free loaders are NOT those who have tried but are unable to make solid contribution to the project. If one has tried their best, then they are not free loaders.

Another group is the lost-credible group. He used to be the okay type but then after 1 semester, because of poor CAP score, he became very grade conscious. He can make friends who are better in programming, studies, etc. He will try to stick with these friends and then try to form project groups with them. He can agree in joining a group but then jump boat to another group with "better" project mates. This person has lost his credibility.

There is whom I label as the sigh-group. People of this group are in search for a minor degree in areas like IS, etc. However, their CAP are enough just for a pass. They may even flunk one or more modules. They will end up getting a minor degree just because they manage to pass all modules eventually no matter what grade they got. I feel universities should set a minimum CAP requirement for students who wish to obtain a minor.

There are many more cases in NUS. I believe this has to do with the intense competition faced by everyone. Everyone wants to be better than everyone but end up doing things which are unbelievable. Everything is getting ugly.

SQL Takes 26HR

Dear all,
AMAZING!!! But this is serious! Below SQL statement takes more than 26 hours (26:35:12.03 to be exact) to execute. I doubt anyone can sort it out. I ain't going to sort out myself either. It's darn long, isn't it?

SELECT     DISTINCT
CA.CODE_UC_PRESTATAIRE,
CA.CODE_CUC_PRESTATAIRE,
CA.COMPTE_ANALYTIQUE,
CA.CODE_PRESTATION,
M.NUM_ECRITURE,
M.NUM_MVT,
M.CODE_UC,
M.CODE_JOURNAL,
M.AGREGA,
M.REFERENCEE,
M.EXERCICE_COMPTABLE,
NVL(M.MONTANT_EURO,0),
TO_CHAR(E.DATE_COMPTABLE,'YYYY-MM-DD'),
M.NUM_RACINE_GENE,
M.SENS,
C.QUANTITE_MVT,
C.ELEMENT_VALORISATION,
E.MOIS_COMPTABLE,
TO_CHAR(CA.DATE_DERNIER_TRAITEMENT,'YYYY-MM-DD')
FROM     ECRITURE_C E,  /* 79900000 rows */
MOUVEMENT_C M,  /* 226081169 rows */
COMPLEMENT_MOUVEMENT_C C,  /* 189944438 rows */
TSF_CA_DEPENSES_REFACTURABLES CA, /* 52000 rows */
TSF_PRESTATION P /*12000 rows */
WHERE     E.NUM_ECRITURE          = M.NUM_ECRITURE
AND     E.CODE_UC           = M.CODE_UC
AND     E.CODE_JOURNAL          = M.CODE_JOURNAL
AND     E.AGREGA          = M.AGREGA
AND     E.REFERENCEE          = M.REFERENCEE
AND     E.EXERCICE_COMPTABLE     = M.EXERCICE_COMPTABLE
AND     M.NUM_ECRITURE          = C.NUM_ECRITURE (+)
AND     M.NUM_MVT          = C.NUM_MVT (+)
AND     M.CODE_UC          = C.CODE_UC (+)
AND     M.CODE_JOURNAL          = C.CODE_JOURNAL (+)
AND     M.AGREGA          = C.AGREGA (+)
AND     M.REFERENCEE          = C.REFERENCEE (+)
AND     M.EXERCICE_COMPTABLE     = C.EXERCICE_COMPTABLE (+)
AND     M.CODE_UC_AFF          = CA.CODE_UC_PRESTATAIRE
AND     P.CODE_UC_PRESTATAIRE     = CA.CODE_UC_PRESTATAIRE
AND     P.CODE_CUC_PRESTATAIRE     = CA.CODE_CUC_PRESTATAIRE
AND     P.CODE_PRESTATION     = CA.CODE_PRESTATION
AND     P.STATUT_PRESTATION      = 1     
AND     ((CA.CODE_CUC_PRESTATAIRE != '     ' AND
C.COMPLEMENT_UC     = CA.CODE_CUC_PRESTATAIRE) OR
(CA.CODE_CUC_PRESTATAIRE = '     ' AND 
(C.COMPLEMENT_UC = '     ' OR C.COMPLEMENT_UC is NULL)))
AND     ((CA.COMPTE_ANALYTIQUE != '            ' AND
M.COMPTE_ANA_12     = CA.COMPTE_ANALYTIQUE) OR
(CA.COMPTE_ANALYTIQUE = '            ' AND 
(M.COMPTE_ANA_12 = '            ' OR M.COMPTE_ANA_12 is NULL)))
AND     (
(E.EXERCICE_COMPTABLE          = TO_NUMBER(TO_CHAR(P.DATE_DEBUT_PRESTATION,'YYYY'))
AND E.MOIS_COMPTABLE          >= TO_NUMBER(TO_CHAR(P.DATE_DEBUT_PRESTATION,'MM'))) 
OR
(E.EXERCICE_COMPTABLE          > TO_NUMBER(TO_CHAR(P.DATE_DEBUT_PRESTATION,'YYYY')))
)
AND     E.NATURE_ECRITURE          = 'CPT'
AND     (INSTR(',879020,8790214,87971,879740,',',' || RTRIM(M.NUM_RACINE_GENE) || ',') = 0)
AND     (INSTR(',FO1,',',' || RTRIM(M.CODE_JOURNAL) || ',') = 0)
AND NOT EXISTS (SELECT      1
FROM      TSF_DEPENSES_REFACTURABLES D
WHERE     D.NUM_ECRITURE               = M.NUM_ECRITURE
AND     D.NUM_MVT               = M.NUM_MVT
AND     D.CODE_UC               = M.CODE_UC
AND     D.CODE_JOURNAL               = M.CODE_JOURNAL
AND     D.AGREGA               = M.AGREGA
AND     D.REFERENCEE               = M.REFERENCEE
AND     D.EXERCICE_COMPTABLE          = M.EXERCICE_COMPTABLE);



~~~~~~~~~~~~~~~~~~~~~~~

Explain plan :

Operation     Object Name     Rows     Bytes     Cost     Object Node     In/Out     PStart     PStop

SELECT STATEMENT Optimizer Mode=CHOOSE          1             647                                           
SORT UNIQUE          1       164       647                                           
FILTER                                                                 
FILTER                                                                 
NESTED LOOPS OUTER                                                                 
NESTED LOOPS          1       133       641                                           
NESTED LOOPS          1       104       638                                           
HASH JOIN          1       56       5                                           
TABLE ACCESS FULL     PROP_NSIC.TSF_PRESTATION     770       17 K     2                                           
TABLE ACCESS FULL     PROP_NSIC.TSF_CA_DEPENSES_REFACTURABLES     4 K     135 K     2                                           
TABLE ACCESS BY INDEX ROWID     PROP_NSIC.MOUVEMENT_C     1 K     52 K     633                                           
INDEX RANGE SCAN     PROP_NSIC.I_MVT_UCAFF_RGENE     1 K           422                                           
TABLE ACCESS BY INDEX ROWID     PROP_NSIC.ECRITURE_C     15 M     438 M     3                                           
INDEX UNIQUE SCAN     PROP_NSIC.PK_ECRITURE_C     15 M           2                                           
TABLE ACCESS BY INDEX ROWID     PROP_NSIC.COMPLEMENT_MOUVEMENT_C     187 M     5G     3                                           
INDEX UNIQUE SCAN     PROP_NSIC.PK_COMPLEMENT_MOUVEMENT_C     187 M           2                                           
INDEX UNIQUE SCAN     PROP_NSIC.PK_TSF_DEPENSES_REFACTURABLES     1       19       1                                           


~~~~~~~~~~~~~~~~~~~~~~~~~~

timing :

26:35:12.03

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

DDLS:

~~~~~~~~~~~~~~~~~~~~~~~~     
--
-- ECRITURE_C  (Table) 
--
--   Count: 79211958 rows
CREATE TABLE PROP_NSIC.ECRITURE_C ( NUM_ECRITURE NUMBER(9) NOT NULL, CODE_UC NUMBER(5) NOT NULL, CODE_JOURNAL CHAR(3) NOT NULL, AGREGA NUMBER(1) NOT NULL, REFERENCEE NUMBER(1) NOT NULL, EXERCICE_COMPTABLE NUMBER(4) NOT NULL, NUM_CP CHAR(8) NOT NULL, REF_PAIEMENT VARCHAR2(15) NULL, EXERCICE_COMPTABLE_AGR NUMBER(4) NULL, CODE_UC_AGR NUMBER(5) NULL, CODE_JOURNAL_AGR CHAR(3) NULL, AGREGA_AGR NUMBER(1) NULL, REFERENCEE_AGR NUMBER(1) NULL, NUM_ECRITURE_AGR NUMBER(9) NULL, MOIS_COMPTABLE NUMBER(2) NOT NULL, CODE_PERIODE CHAR(1) NOT NULL, DATE_ENREGISTREMENT DATE NOT NULL, DATE_EVENEMENT DATE NOT NULL, DATE_COMPTABLE DATE NULL, MOIS_REDRESSEMENT NUMBER(2) NULL, REF_EXTERNE VARCHAR2(15) NULL, IDENTIFIANT_EXTERNE CHAR(12) NULL, ZONE_TECHNIQUE VARCHAR2(30) NULL, ANNULATION_SAISIE NUMBER(1) NOT NULL, LIBELLE_ECR VARCHAR2(30) NULL, MODIFIABLE NUMBER(1) NOT NULL, DATE_DERNIERE_MAJ DATE NULL, NATURE_ECRITURE CHAR(3) NOT NULL, CODE_DEVISE CHAR(3) NOT NULL, DATE_VALEUR DATE NULL, TX_CONV_CPTE NUMBER(9,7) NULL, ID_SNCF_RFF CHAR(2) NULL ) TABLESPACE TBS_T250M_2 PCTUSED 40 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 250M NEXT 250M MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) LOGGING NOCACHE NOPARALLEL;


--
-- I_ECR_C_CODE_JOURNAL  (Index) 
--
--  Dependencies: 
--   ECRITURE_C (Table)
--
CREATE INDEX PROP_NSIC.I_ECR_C_CODE_JOURNAL ON PROP_NSIC.ECRITURE_C (CODE_JOURNAL) LOGGING TABLESPACE TBS_X250M_1 PCTFREE 0 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 250M NEXT 250M MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOPARALLEL;


--
-- I_ECRITURE_C_DATECPT  (Index) 
--
--  Dependencies: 
--   ECRITURE_C (Table)
--
CREATE INDEX PROP_NSIC.I_ECRITURE_C_DATECPT ON PROP_NSIC.ECRITURE_C (DATE_COMPTABLE) LOGGING TABLESPACE TBS_X250M_1 PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 250M NEXT 250M MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOPARALLEL;


--
-- I_ECRITURE_C_UC  (Index) 
--
--  Dependencies: 
--   ECRITURE_C (Table)
--
CREATE INDEX PROP_NSIC.I_ECRITURE_C_UC ON PROP_NSIC.ECRITURE_C (CODE_UC) LOGGING TABLESPACE TBS_X250M_3 PCTFREE 0 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 250M NEXT 250M MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOPARALLEL;


--
-- IT_2_ECRITURE_C  (Index) 
--
--  Dependencies: 
--   ECRITURE_C (Table)
--
CREATE INDEX PROP_NSIC.IT_2_ECRITURE_C ON PROP_NSIC.ECRITURE_C (NUM_ECRITURE_AGR, CODE_UC_AGR, CODE_JOURNAL_AGR, AGREGA_AGR, REFERENCEE_AGR, EXERCICE_COMPTABLE_AGR) LOGGING TABLESPACE TBS_X5M PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 400K NEXT 400K MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOPARALLEL;


--
-- IT_4_ECRITURE_C  (Index) 
--
--  Dependencies: 
--   ECRITURE_C (Table)
--
CREATE INDEX PROP_NSIC.IT_4_ECRITURE_C ON PROP_NSIC.ECRITURE_C (DATE_EVENEMENT) LOGGING TABLESPACE TBS_X250M_3 PCTFREE 0 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 250M NEXT 250M MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOPARALLEL;


--
-- IT_7_ECRITURE_C  (Index) 
--
--  Dependencies: 
--   ECRITURE_C (Table)
--
CREATE INDEX PROP_NSIC.IT_7_ECRITURE_C ON PROP_NSIC.ECRITURE_C (REF_EXTERNE) LOGGING TABLESPACE TBS_X250M_2 PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 250M NEXT 250M MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOPARALLEL;


--
-- IT_8_ECRITURE_C  (Index) 
--
--  Dependencies: 
--   ECRITURE_C (Table)
--
CREATE INDEX PROP_NSIC.IT_8_ECRITURE_C ON PROP_NSIC.ECRITURE_C (IDENTIFIANT_EXTERNE) LOGGING TABLESPACE TBS_X50M PCTFREE 0 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 50M NEXT 50M MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOPARALLEL;


--
-- IT_9_ECRITURE_C  (Index) 
--
--  Dependencies: 
--   ECRITURE_C (Table)
--
CREATE INDEX PROP_NSIC.IT_9_ECRITURE_C ON PROP_NSIC.ECRITURE_C (EXERCICE_COMPTABLE, MOIS_COMPTABLE, CODE_PERIODE, NUM_ECRITURE, CODE_UC, CODE_JOURNAL, AGREGA, REFERENCEE, NATURE_ECRITURE, ANNULATION_SAISIE) LOGGING TABLESPACE TBS_X250M_5 PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 250M NEXT 250M MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) PARALLEL ( DEGREE 4 INSTANCES 1 );


--
-- PK_ECRITURE_C  (Index) 
--
--  Dependencies: 
--   ECRITURE_C (Table)
--
CREATE UNIQUE INDEX PROP_NSIC.PK_ECRITURE_C ON PROP_NSIC.ECRITURE_C (NUM_ECRITURE, CODE_UC, CODE_JOURNAL, AGREGA, REFERENCEE, EXERCICE_COMPTABLE) LOGGING TABLESPACE TBS_X250M_5 PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 250M NEXT 250M MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOPARALLEL;


~~~~~~~~~~~~~~~~~~~~~~~
--
-- COMPLEMENT_MOUVEMENT_C  (Table) 
--
--   Count: 187722829 rows
CREATE TABLE PROP_NSIC.COMPLEMENT_MOUVEMENT_C ( NUM_ECRITURE NUMBER(9) NOT NULL, 
NUM_MVT NUMBER(4) NOT NULL, 
CODE_UC NUMBER(5) NOT NULL, 
CODE_JOURNAL CHAR(3) NOT NULL, 
AGREGA NUMBER(1) NOT NULL, 
REFERENCEE NUMBER(1) NOT NULL, 
EXERCICE_COMPTABLE NUMBER(4) NOT NULL, 
COMPLEMENT_UC CHAR(5) NULL, 
ELEMENT_VALORISATION NUMBER(10,2) NULL, 
QUANTITE_MVT NUMBER(15,2) NULL, 
INDIC_TVA CHAR(2) NULL, 
MOIS_COMPTABLE NUMBER(2) NULL ) 
TABLESPACE TBS_T250M_1 PCTUSED 40 PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE ( INITIAL 250M NEXT 892328K MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) 
LOGGING NOCACHE NOPARALLEL;


--
-- IT_1_COMPLEMENT_MOUVEMENT_C  (Index) 
--
--  Dependencies: 
--   COMPLEMENT_MOUVEMENT_C (Table)
--
CREATE INDEX PROP_NSIC.IT_1_COMPLEMENT_MOUVEMENT_C ON PROP_NSIC.COMPLEMENT_MOUVEMENT_C (COMPLEMENT_UC) LOGGING TABLESPACE TBS_X250M_1 PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 250M NEXT 250M MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOPARALLEL;

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--
-- MOUVEMENT_C  (Table) 
--
--   Count: 223721272 rows
CREATE TABLE PROP_NSIC.MOUVEMENT_C ( NUM_ECRITURE NUMBER(9) NOT NULL, NUM_MVT NUMBER(4) NOT NULL, CODE_UC NUMBER(5) NOT NULL, CODE_JOURNAL CHAR(3) NOT NULL, AGREGA NUMBER(1) NOT NULL, REFERENCEE NUMBER(1) NOT NULL, EXERCICE_COMPTABLE NUMBER(4) NOT NULL, CODE_UC_AFF NUMBER(5) NOT NULL, NUM_RACINE_GENE CHAR(8) NOT NULL, MONTANT NUMBER(15,2) NOT NULL, SENS CHAR(1) NOT NULL, COMPTE_ANA_12 CHAR(12) NULL, COMPLEMENT_COMPTE_ANA CHAR(4) NULL, NUM_RACINE_ANA CHAR(12) NOT NULL, LONGUEUR_ACTIVE NUMBER(2) NOT NULL, NUM_MVT_FONC NUMBER(4) NULL, MONTANT_DEVISE NUMBER(15,2) NULL, FILIERE_PRODUCTION CHAR(12) NULL, MONTANT_EURO NUMBER(15,2) NULL, MOIS_COMPTABLE NUMBER(2) NULL ) TABLESPACE TBS_T250M_1 PCTUSED 40 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 250M NEXT 250M MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) LOGGING NOCACHE NOPARALLEL;


--
-- I_MOUVEMENT_C_11  (Index) 
--
--  Dependencies: 
--   MOUVEMENT_C (Table)
--
CREATE INDEX PROP_NSIC.I_MOUVEMENT_C_11 ON PROP_NSIC.MOUVEMENT_C (NUM_ECRITURE, CODE_UC, CODE_JOURNAL, AGREGA, REFERENCEE, EXERCICE_COMPTABLE) LOGGING TABLESPACE TBS_X250M_1 PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 250M NEXT 250M MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) PARALLEL ( DEGREE 4 INSTANCES 1 );


--
-- I_MOUVEMENT_C_12  (Index) 
--
--  Dependencies: 
--   MOUVEMENT_C (Table)
--
CREATE INDEX PROP_NSIC.I_MOUVEMENT_C_12 ON PROP_NSIC.MOUVEMENT_C (COMPTE_ANA_12) LOGGING TABLESPACE TBS_X250M_2 PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 250M NEXT 250M MINEXTENTS 1 MAXEXTENTS 500 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOPARALLEL;


--
-- I_MOUVEMENT_C_13  (Index) 
--
--  Dependencies: 
--   MOUVEMENT_C (Table)
--
CREATE INDEX PROP_NSIC.I_MOUVEMENT_C_13 ON PROP_NSIC.MOUVEMENT_C (COMPTE_ANA_12, NUM_RACINE_GENE) LOGGING TABLESPACE TBS_X250M_2 PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 250M NEXT 250M MINEXTENTS 1 MAXEXTENTS 500 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOPARALLEL;


--
-- I_MVT_NUM_RAC_GENE  (Index) 
--
--  Dependencies: 
--   MOUVEMENT_C (Table)
--
CREATE UNIQUE INDEX PROP_NSIC.I_MVT_NUM_RAC_GENE ON PROP_NSIC.MOUVEMENT_C (NUM_RACINE_GENE, NUM_ECRITURE, CODE_UC, CODE_JOURNAL, EXERCICE_COMPTABLE, REFERENCEE, AGREGA, NUM_MVT) LOGGING TABLESPACE TBS_X250M_4 PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 250M NEXT 250M MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOPARALLEL;


--
-- I_MVT_UCAFF_RGENE  (Index) 
--
--  Dependencies: 
--   MOUVEMENT_C (Table)
--
CREATE INDEX PROP_NSIC.I_MVT_UCAFF_RGENE ON PROP_NSIC.MOUVEMENT_C (CODE_UC_AFF, NUM_RACINE_GENE) LOGGING TABLESPACE TBS_X250M_3 PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 250M NEXT 624176K MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOPARALLEL;


--
-- IT_2_MOUVEMENT_C  (Index) 
--
--  Dependencies: 
--   MOUVEMENT_C (Table)
--
CREATE INDEX PROP_NSIC.IT_2_MOUVEMENT_C ON PROP_NSIC.MOUVEMENT_C (COMPLEMENT_COMPTE_ANA) LOGGING TABLESPACE TBS_X250M_1 PCTFREE 0 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 250M NEXT 250M MINEXTENTS 1 MAXEXTENTS 100 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOPARALLEL;


--
-- PK_MOUVEMENT_C  (Index) 
--
--  Dependencies: 
--   MOUVEMENT_C (Table)
--
CREATE UNIQUE INDEX PROP_NSIC.PK_MOUVEMENT_C ON PROP_NSIC.MOUVEMENT_C (NUM_ECRITURE, CODE_UC, CODE_JOURNAL, AGREGA, REFERENCEE, EXERCICE_COMPTABLE, NUM_MVT) LOGGING TABLESPACE TBS_X250M_5 PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 250M NEXT 250M MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOPARALLEL;

NUS Summary Tomorrow

I think I will post a summary of my NUS experience here tomorrow. Do check out!

Last Meal in NUS

Tomorrow will be my last meal in NUS :'(
I will miss everything.

Sunday, May 01, 2005

Red Scarce Recap

Because of the Red scarce in US on 1st May during the Cold War period, US no longer recognizes 1st May as International Labour Day. They have moved Labour Day to 2nd week of September every year if I remember correctly.

Sometimes history can be really scary. See how the Russian have picked this day to demonstrate.

China Acquisition of IBM's Part

China's Lenovo just completed acquisition of IBM's personal computing division. This just means China global expansion is really evident. Prices of PCs will drop with their low-cost production. I better improve my Chinese.

Musical CD Turned Out Sexual

I believe this is a rare case. Having a supposedly healthy 1957 musical mixed up with a sex movie is very rare. Will you watch till the end? Perhaps the couple were too shocked to hit the stop button.
http://news.bbc.co.uk/2/hi/uk_news/england/somerset/4212207.stm

Blog Archive

Related Posts Plugin for WordPress, Blogger...