SQL> select * from temp order by cate,type;

CATE       TYPE
---------- ----------
CATEGORY   SEWER
CATEGORY   WATERPE
CATEGORY   WATERPVC
DIVISION   BELOWGR
DIVISION   BUILDING
DIVISION   LITRTURE
DIVISION   UTILITY
DIVISION   UTILITY

8 rows selected.

SQL> alter table temp add (id number);

Table altered.
SQL> ed
Wrote file afiedt.buf

  1  create table new_temp
  2  as
  3  select rownum id ,cate,type from
  4* (select cate,type from  temp order by cate,type)
SQL> /

Table created.

SQL> select * from new_temp;

        ID CATE       TYPE
---------- ---------- ----------
         1 CATEGORY   SEWER
         2 CATEGORY   WATERPE
         3 CATEGORY   WATERPVC
         4 DIVISION   BELOWGR
         5 DIVISION   BUILDING
         6 DIVISION   LITRTURE
         7 DIVISION   UTILITY
         8 DIVISION   UTILITY

8 rows selected.
----------------------------------------
check the data. 
Now you can drop the old temp table and rename new_temp to temp