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 Chriss Miller 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: *

  • Users: Palmero
  • Order by date
  1. Palmero

    CHARACTER SET

    Hi Mufasa, DATABASE CREATED! Let me know you what happens after. SVRMGR> connect / as sysdba ConnectÚ SVRMGR> startup nomount pfile=C:\Oracle\admin\COGNOS\pfile\cognos.ora Instance ORACLE dÚmarrÚe Zone globale systÞme (SGA) totale de 73701404 octets Fixed Size...
  2. Palmero

    CHARACTER SET

    ...for many # parameters. For example, if you choose to use private rollback segments, # these must be specified in different files, but since all gc_* # parameters must be the same on all instances, they should be in one file. # # INSTRUCTIONS: Edit this file and the other INIT files it calls...
  3. Palmero

    CHARACTER SET

    Hi Mufasa, YOU'RE RIGHT ! SVRMGR> connect / as sysdba ConnectÚ SVRMGR> But I have another problem : SVRMGR> startup nomount pfile=C:\Oracle\admin\COGNOS\pfile\cognos.ora ORA-24323: valeur interdite ORA-12571: TNS : échec à l'écriture du paquet When I performed the "oradim -new -sid...
  4. Palmero

    CHARACTER SET

    C:\>set ORACLE_HOME=c:\oracle\ora81 C:\>set ORACLE_SID=COGNOS Another test : C:\>svrmgrl Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 2000, Oracle Corporation. Tous droits rÚservÚs. Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option...
  5. Palmero

    CHARACTER SET

    Hi Mufasa, My ORACLE_HOME is defined in the Windows Registry HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE (Oracle_home=c:\oracle\ora81). My ORACLE_SID is defined in the Windows Registry HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 for my first database (Oracle_sid=MYBASE) which works. The Oradim I performed...
  6. Palmero

    CHARACTER SET

    Hi Mufasa, I am performing your solution, but I have problems to connect / as sysdba. What could be the issue according to you. The "OracleOraHome81TNSListener" is started. Thanks very much for your help. SVRMGR> connect / as sysdba ORA-12560: TNS : erreur d'adaptateur de protocole...
  7. Palmero

    CHARACTER SET

    ...with this character set (see below) : SQL> ALTER DATABASE CHARACTER SET UTF8; ALTER DATABASE CHARACTER SET UTF8 * ERREUR à la ligne 1 : ORA-12712: le nouveau jeu de caractères doit être un surensemble de l'ancien In the same laptop, how can I do to create a...
  8. Palmero

    Auditing Visualizations

    Hi all, I need to audit servers and users activity with Impromptu Web Reports, PowerPlay and Visualizer. I have found the solution for Impromptu Web Reports and PowerPlay. I need to know if it is possible to have in a log file following information : - the report name - the username who...
  9. Palmero

    Read Statistics

    Hi all, When analyzing statistics for an Oracle 8i request, what is the significance of following parameters : - physical reads - block get - consistent gets - blocks changes - consistent changes - buffers get in trace optimisations How are the following parameters used : - block buffers =...
  10. Palmero

    More ROLLBACKs than COMMITs

    Hi all, Is it normal to have more Rollbacks than commits in an Oracle 8.1.7 production database? Thanks for your feed-back. Palmero.
  11. Palmero

    CITRIX on Windows NT 4 patch 6

    Hi all, In a Citrix environment, I have problems of processes remaining in the server even client users are disconnected. The following programs are INACTIVE in the server and anyone is connected : - CTMAPP32.EXE - CFSAPP32.EXE - INTREX32.EXE - SLAPP32.EXE Do you know if these programs are let...
  12. Palmero

    Subqueries in Sybase

    Hi all, The following SQL syntax does work on Oracle, but not on Sybase. Do you have a workaround without using a temporary table? Thanks in advance for your help. SELECT T1.code,T2.label FROM (SELECT ......) T1, (SELECT ......) T2 WHERE T1.code=T2.code; Palmero.
  13. Palmero

    Hi all, The following SQL syntax

    Hi all, The following SQL syntax does work on Oracle, but not on Sybase. Do you have a workaround without using a temporary table? Thanks in advance for your help. SELECT T1.code,T2.label FROM (SELECT ......) T1, (SELECT ......) T2 WHERE T1.code=T2.code; Palmero.
  14. Palmero

    Personal Oracle 8i and Oracle Client NET8 on the same PC

    Hi all, I want to install on my PC a Personal Oracle 8i and an Oracle Client NET8. How can I proceed to install the 2 versions on my machine? Thanks in advance for your answer. Palmero.
  15. Palmero

    READ LINE FAILS WITH UTL FILE

    Hi all, I am populating an Oracle V7.3.4 table from a flat file using the following procedure : create or replace procedure Charge_produit is -- declaration of variables BEGIN WHILE MY_GET_LINE(file_handle,ligne) LOOP BEGIN INSERT INTO TMP_PRODUIT values (...
  16. Palmero

    UTL FILE PACKAGE

    Hi all, I am loading an Oracle V7.3.4 table from a flat file using the UTL file package. This flat file is transferred from a mainframe to a Windows NT4, Pack 6 server. During the transfer, some caracters are converted. For example, the word "PRêt" becames "PR T" and in this...
  17. Palmero

    Menu Editor on Visual Basic

    Hi, I am developping an application with Visual Basic and I want to perform a menu using the menu editor. I don't have the documentation which explains the different properties of the window editor. What is the meaning of following caracteristics : - Name - Index - HelpContextID - Checked -...
  18. Palmero

    Physical copy of database from machine A to machine B

    Hi all, I have a Windows NT server with Oracle 7.3.4 installed and this oracle 7.3.4 is handling a datawarehouse. Let's name this machine server A. We have bought a new server (server B) and I want to transfer the A machine database into the B machine using a physical copy of machine A...
  19. Palmero

    How to build a menu

    Hi all, I want to develop a VB6 application and I want to know how to build a menu. Thanks in advance for your help. Palmero.
  20. Palmero

    Oracle table management : add, delete

    Hi all, I am developping with Visual Basic 6.0 attacking an Oracle 8 database. I have a table (code primary key, description). I want : - to add a given code if the code does not exist. - to delete a given code if the code exists. If you have a sample code managing the evolution of such a...

Part and Inventory Search

Back
Top