INFORMIX 7.3 to ORACLE 8.1.7 (New info)

Since I said I'll tell you how it went here it is. We used Oracle Migration Workbench, and it really works but...(there is always at least one but). In our case, it was amount of tables (more than 800) and data which we had to put into Oracle. Time effect was also very important. After

INFORMIX 7.3 to ORACLE 8.1.7

Thanks to all who helped. I'll inform you how it works, maybe someone will need it too. Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

INFORMIX 7.3 to ORACLE 8.1.7

Hi! We inherited one Informix database, which we must put into our production Oracle database (new schema). Both databases are on AIX UNIX machines. We can do this by writing a scripts, but I'm wondering does any of you have some experiance in this, and could you suggest me some other (simpler)

Reporting database with Time Finder

Hi! Oracle 8.1.7 on AIX, on EMC discs boxes which are synchronized with SRDF. At the target site, we have BCV volumes. We want to open reporting database on a daily basis. Now we can open target database with the same AIX volume group as the primary database. My question is do you have

Oracle on AIX performance issue

Oracle 8.1.7 on AIX. Our database is rapidly expanding. Now it's approximately 80GB and for few months it's going to be at least double of that size. We are planning some reorganizations, so I'm wondering could you give me some advice. Is it better to have several big file systems or lot

Oracle8i on WinNT - renaming disc drives

List hi! Oracle 8.1.7 on WinNT. Our Windows guys want to rename disc drives for some administration reasons. I'm really in UNIX so I'm wondering could you give me some advices on this matter. As far as I know, I have to recreate control files, with new drives. Is there anything else I should do?

encryption of password (how to do it)?

Hi! Oracle 8.1.7 on AIX and Panther 'Application Server' on another AIX server (2 tier architecture). When starting application, first user connects to UNIX server with private login name. After that he is connected to 'Application Server' which connects to the database. For starting 'Application

Pl/SQL question

List hi! Oracle 8.1.7 EE on AIX. One of our developers wrote a procedure. Inside that procedure he wants to know instance and schema, while executing that procedure. Do you have any suggestions? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Problem with RMAN

List hi! Oracle 8.1.7 EE on WinNT. During instalation of database, package DBMS_RCVCAT was not installed but I have packages DBMS_RCVMAN, DBMS_BACKUP_RESTORE. What should I do? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Strange report from 'vmstat'

Hi all! Oracle 8.1.7 on AIX (8GB RAM (+ swap space 9GB)). It concerns AIX memory 'problem'. When I issue vmstat command, we got following result: /u01/app/oracle/product/8.1.7.vmstat 2 4 kthr memory page faultscpu - ---

MTS

Hi all! Oracle 8.1.7 EE on AIX. We have several hundred user which connect to the database in OLTP mode. I'm wondering is it good idea to configure MTS in such conditions? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

RE: how to install Oracle Developer2000 on Windows98 ?

Well, I remember that I had such installation problems. To begin with, you must have CD for Win98 . It really annoyed me when I realized that you can't install Developer from CD for Win95/NT. HTH, Sonja -Original Message- Sent: Saturday, April 21, 2001 11:16 AM To: Multiple

ORA-01458

Hi all! Oracle 8.1.7 on WinNT. When I try to copy one table from one schema to another I get this error message. ORA-01458: invalid length inside variable character string Description is "very informative" 01458, 0, "invalid length inside variable character string" //

authentication externally on WinNT

It's working now! Thanks to all that helped. In addition, I discovered that you must put one parameter in sqlnet.ora file: SQLNET.AUTENTICATION_SERVICES=(NTS) Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= INET:

RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby

List hi! I have a "few" questions on thet subject: What we need: Primary site - 24x7 OLTP database access Backup site - a. Failover site b. Disaster Recovery site c. Reporting database - In case of loosing

RE: Locking

Try with this query: select xidusn, object_id, session_id, locked_mode from v$locked_object; If developer created table with bitmap index it can be reason for locking (we had such problem). HTH, Sonja -Original Message- Sent: Tuesday, March 20, 2001 11:27 PM To:

BUG in installing Designer6 Repository on 8.1.7 database

List hi! Here is description of the Bug we found. It is quite unpleasent. For a while everything looks just nice, then installation freeze. There are no errors of any kind; system just hangs (and it can lasts for hours)! It cost me 3 hours, before I realized something is very wrong (you think

problem with UTL_FILE.FILE OPEN

List hi! Oracle817 on AIX. (64 bit) We have defined in initora file UTL_FILE_DIR=* When we start function UTL_FILE.FOPEN it raises exception INVALID_PATH. Everything is set and available (permissions are 777). Do you have any idea what's wrong? TIA, Sonja -- Please see the official

Inteligent Agent on Oracle817 for OS/390 OSDI

List hi! My colleuge have problem with this configuration Does anyone have a cook book for configuring this product? If anyone have it, would you be so kind to send it directly to: [EMAIL PROTECTED] TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

OEM - Tunning Pack, Diagnostic Pack....

List Hi! Oracle gave as these tolls on evaluation and testing and IT managerment wants our opinion. As you know, these products are licenced acording to the number of users (which we have several hundreds). Since we didn' have enough time to test this properly, I was wondering can you give me

Script for INDEX creation

List hi! From one schema in production database I want to create same indexes on the other (same schema on different instance). I know that I can do it with imp in indexfile, but it is not good enough. Does anyone have script with which I could dinamicaly create indexes on all tables within