ngeTrend s!te BLOG - It’s In English

I was trying install Oracle 8i onto my computer under Windows OS, but it was strange. After “setup” file is clicked, busy icon is appear but nothing happened then.

I tried to install on notebook, everything was ok. The installation was run properly.

Got confused, I asked google for this problem, and here is the answer:

———–
If you are using P4…Its a known bug…Here is a easiest workaround assuming your processor is a Pentium 4 …

1. Create a temporary directory on your server.
2. Copy the contents of the Oracle RDBMS CD to the temporary directory created in step 1.

3. Search the directory structure created in step 1 for the existence of the filename symcjit.dll….mostly you will find 2 files

4. Rename each copy of the symcjit.dll to symcjit.old.

5. Run the setup.exe from the installwin32 directory and install Oracle 8.1.x.

———–

thats it

Popularity: 77% [?]

Whatever the reason is, but sometimes we decided to change column type of table. It’s quite easy to implement the patch it MySQL, but not in PostgreSQL (I’m currently using pgsql 8.14).

There are two ways (I just know those two) to solve that problem:

1st solution:BEGIN;ALTER TABLE table_name ADD COLUMN new_col new_data_type;

UPDATE table_name SET new_col = CAST(old_col AS new_data_type);

ALTER TABLE table_name DROP COLUMN old_col;

COMMIT;

However, It is used when we want to change type of the latest column (its position in the table), except we can determine to add column in the certain position.

Since it cannot be used in all situations, I have found another way to solve that problem:

2nd solution:1) Copy old table to temporary tableCREATE TABLE temp AS SELECT * FROM old_table;2) Drop old table

DROP TABLE old_table;

3) Create new table (as required structure)

CREATE TABLE new_table ( col1 type(xx), col2 type(xx) );

4) insert data dari table temporary ke table baru

INSERT INTO new_table SELECT * FROM temp ;

Yeah.. that’s it! I think it will be useful.

Popularity: 100% [?]

When installing source package in Linux, have you seen this error message?

mysql.o(.text+0x1bda): In function `com_source(String*, char*)':
: undefined reference to `errno'
collect2: ld returned 1 exit status
make[2]: *** [mysql] Error 1
make[2]: Leaving directory `/opt/mysql-3.23.49/client'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/opt/mysql-3.23.49'
make: *** [all-recursive-am] Error 2

I got this when installing mysql-3-23.49. At first, I just think that it’s because the MySQL version is not relevant anymore.

In fact the error is appear because the compiler does not include the header file ‘error.h’ when compiling the source package.

So, the soulusion is to find out files which needs error.h, it’s contain line:

extern int errno;

By using ‘grep’ or ‘mc’ or other script (I prefer mc, because it’s easier), then just include error.h header file to those files by add this line:

#include error.h 

Popularity: 35% [?]