Search results for query: *

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.

if my export file exp from NLS_LANG=AMERICAN_AMERICA.ZHS16GBK, then I need to import this file (only have this dmp files, cannot export again) into a DB charactorset=ZHS16CGB231280 under environment NLS_LANG=NLS_LANG=AMERICAN_AMERICA.ZHS16CGB231280. How can I import it....

Do anyone have try and solution??? 1) Mac Oracle client 2.3.2.0.3 2) Connect to Win2000 Oracle 8.1.7.0.0 EE Database server 3) DB charactorset = ZHS16GBK 4) Both Mac and server environment had set to AMERICAN_AMERICA.ZHS16GBK 5) Mac had connection error: ORA-03106 :Fatal: two-task...

If I need to use MTS for Oracle817, seem I need to do the following, pls comment and correct me. 1) add the following parameter into initSID.ora INSTACNE_NAME=db_instance_name SERVICE_NAMES=db_service_name ...

Do any document to explain the report.txt (in detail) which generate by ultbstat.sql and utlestat.sql? Which Oracle pref and tunning tools is the best and recommand for the DBA?

what install option you select when you install O816 client? DBA? Application user? developer? seem ODBC is not include in the default option, and you should install the custom option.