Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. markco

    Macintosh client 2.3.2.0.3 connect to Oracle9i

    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
  2. markco

    What is the diff. on performance if using large vs small datafile

    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...
  3. markco

    different width of foregin key will affect the performance???

    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...
  4. markco

    different width of foregin key will affect the performance???

    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...
  5. markco

    Sub-query, select frist, sorted 20 records from 5000 records.

    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...
  6. markco

    Insufficient privileges

    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...
  7. markco

    Sub-query, select frist, sorted 20 records from 5000 records.

    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...
  8. markco

    import from 9.2 to 8.1.7

    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
  9. markco

    Create Database Errors

    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...
  10. markco

    Oracle 9i 92010 National Character set: AL16UTF16

    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...
  11. markco

    1st execute SQL take much longer than 2nd execute

    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...
  12. markco

    anyone know any other software function same as PocketDBA?

    anyone know PocketDBA? anyone know any other software function same as PocketDBA?
  13. markco

    Software function same as PocketDBA from www.xb.com

    anyone know PocketDBA? anyone know any other software function same as PocketDBA?
  14. markco

    How to incremental rebuild intermedia index

    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
  15. markco

    cannnot create datatype BLOB and CLOB if not install intermedia

    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.
  16. markco

    import a ZHS16GBK dmp into ZHS16CGB231280 DB

    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....
  17. markco

    Mac client 23203 connect Ora817 (ZHS16GBK)

    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...
  18. markco

    using MTS in Oracle 817

    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 ...
  19. markco

    doc for explain the report.txt from utlbstat.sql and utlestat.sql

    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?
  20. markco

    Oracle 8.1.6 Installation Problems

    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.

Part and Inventory Search

Back
Top