Recent content by markco

Hi, any able to make Macintosh client 2.3.2.0.3 connect to Oracle9i? I had connect Mac client 2.3.2.0.3 to Oracle8i, but there is problem on ora9i.... I know macintosh support had been discontinuoued start from Oracle8..... Markco Wong

I have Ora817 in Sun Solaris (E450), and have a 6G tablespace and have data size ~4GB. Now it have 6 x 1024MB as whole Tablespace. What is the diff. on performance if a) a single 6GB datafile as whole Tablespace? b) 3 x 2GB datafile as whole Tablespace? Total disksize is 36GB to hold the...

If a field in a table (eg. transactionno VARCHAR2(14)) which is foreign key of several tables, let say (table1: receiptno VARCHAR2(10), table2: creditnoteno VARCHAR2(14)...), then is it influence the performance when the linkage with transactionno AND the receiptno since the structure length is...

If a field in a table (eg. transactionno VARCHAR2(14)) which is foreign key of several tables, let say (table1: receiptno VARCHAR2(10), table2: creditnoteno VARCHAR2(14)...), then is it influence the performance when the linkage with transactionno AND the receiptno since the structure length is...

Thanks for input. Of Couse, my table is not simply as this sample table. It include more than 500,000 records and have many columns, include BLOB data. The true SQL is also include some join table query, such that I need to take about 30 sec to receive first 20 rows. This SQL is good for...

If you are using Win OS, and using a Command prompt to start the sqlplus, you need to set environment parameter in the cmd prompt first. 1) set ORACLE_SID=<your SID> 2) sqlplus /nolog after go into sqlplus, 3) connect / as sysdba then you can connect the local SID. But if you connect to...

Anyone have a good method if I could like to do the following: Table: Craete table DATA (INPUTTIME DATE, ARTICLECODE VARCHAR2(10) ); All data is not sort by DATA.INPUTTIME inside table. There are total more than 50000 record, but if I could like to get the first 20 record, but require...

you should use Oracle817 export tools, connect to 9i DB and do the export. Then use 817 import tools to import into 817 DB. Markco Wong

what OS you are using? Win2000? if yes, then how do you create DB? using SQL command: create database.....? You can connect sqlplus? try this: 1) open CMD, type &quot;set ORACLE_SID=<your_SID>&quot;, then enter. 2) start sqlpus, sqlplus /nolog 3) connect / as sysdba; 4) create database...

I'm install Oracle92010 EE DB. 1) Oracle9i 92010 only allow using AL16UTF16 or UTF8 as National Character Set? While Oracle8i allow user to choose other value as National Character Set. 2) If I need to use unicode to support traditional chinese and simplified chinese, which unicode character...

If I have a SQL to retrive some data from DB and under the following condition, how can I check what should be the problem? 1) when the first time to run the SQL, it take about 30 sec to fatch all data back to the application. When the first run, the CPU loading is low but the disk IO is high...

anyone know PocketDBA? anyone know any other software function same as PocketDBA?

anyone know PocketDBA? anyone know any other software function same as PocketDBA?

How to incremental rebuild intermedia index? since Full rebuild is take too long to completed. If some new record had been insert into TABLE with column have intermedia index built on it, new record will not indexed unless rebuild the intermedia index. Oracle 8.1.7 db

hi, I could like to know if the Oracle 8.1.7 server did not install intermedia, can I create BLOB and CLOB datatype table and columns? Thanks.