INFORMIX 7.3 to ORACLE 8.1.7 (New info)

2002-02-14 Thread Sonja ehovi

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 extensive
testing, we discovered that our scripts are the fastest way.

HTH,
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) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



INFORMIX 7.3 to ORACLE 8.1.7

2002-01-30 Thread Sonja ehovi

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) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



INFORMIX 7.3 to ORACLE 8.1.7

2002-01-29 Thread Sonja ehovi

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) way?
Perhaps some Conversion tools?

TIA,
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) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Reporting database with Time Finder

2002-01-16 Thread Sonja ehovi

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 experience in renaming AIX volume group, so we
can have two databases on the same machine (SRDF target and BCV)?
We have some experience in doing that manually, but we're interested in
having some scripts.
Please help.

TIA,
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) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Oracle on AIX performance issue

2001-12-21 Thread Sonja ehovi

 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 of smaller?
 
 TIA,
   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) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Oracle8i on WinNT - renaming disc drives

2001-11-28 Thread Sonja ehovi

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? Some Windows stuff?

TIA,
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) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



encryption of password (how to do it)?

2001-06-28 Thread Sonja ehovi

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 Server' user has
database connect string and password (plain text) in .profile (as env
variables).
Do you have suggestions (experience) how to make a secure connection?

TIA,
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) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Pl/SQL question

2001-06-25 Thread Sonja ehovi

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: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Problem with RMAN

2001-06-06 Thread Sonja ehovi

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: =?windows-1250?Q?Sonja_=8Aehovi=E6?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Strange report from 'vmstat'

2001-05-02 Thread Sonja ehovi

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
- ---   ---
 r  b   avm   fre  re  pi  po  fr   sr  cy  in   sy  cs us sy id wa
 0  0 580556   554   0   0   0  14   34   0 126  137  63 11  5 82  1
 0  2 580556   549   0   0   0   00   0 708  527 206  0  0 99  0
 0  2 580557   548   0   0   0   00   0 829 99854 421  2 10 88  0
 0  2 580557   548   0   0   0   00   0 637  111  35  0  0 99  0
 
Analysing this output, it seams that we have cca 2GB RAM (example: (580557 +
548)* 4096 = 2,2 GB), while we expected min 8GB.
This gap between 8GB and output from vmstat report, increases in time. 
The question is if our calculation was right, is this the right way to
analyse this at all?
Maybe it is important to say, that our Oracle is installed on OFA using data
files, max size 2GB, in same volume group(not on raw devices).
Do you know of any AIX memory problems which can manifests as mentioned
above?

TIA,
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) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



MTS

2001-04-25 Thread Sonja ehovi

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: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: how to install Oracle Developer2000 on Windows98 ?

2001-04-24 Thread Sonja ehovi

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 recipients of list ORACLE-L


dear listers,

any body knows how to install Oracle Developer2000 on Windows98 ?

I installed it on my machine but I can't even connect to my database 

thanks in advance ,


regards,

bambang


 Bambang Setiawan 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bambang Setiawan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?windows-1250?Q?Sonja_=8Aehovi=E6?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



ORA-01458

2001-04-24 Thread Sonja ehovi

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"
// *Cause:
// *Action:

This is what I did:
copy from [EMAIL PROTECTED]
to [EMAIL PROTECTED]
create abc using select * from abc;

Do you have any suggestions?
TIA,
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) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



authentication externally on WinNT

2001-04-19 Thread Sonja ehovi

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: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby

2001-03-22 Thread Sonja ehovi

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 funcionality one of the site takes the
production on itself 
- The Hardware and Software at the Bakup site should be used for
production
a. Aplication servers on all sites work in load balancing (end users should
not be aware that they are working at the other site).
b. Database server on backup site should be used  for reporting
- REPORTS are created through our applications (possibilly writing records
in some temporary tables)
- Stopping of production because of  all types of changes (upgrade of RDBMS,
changes in structure of the tables, ...) must be minimal, preferable none!


Idea:
Through the combination of Symmetrix EMC2 disks, SRDF (Symmetrix
Remote Data Facilities)
and Time Finder (EMC2 software) make up-to-date reporting Oracle
instance on target
(backup) site.


What do we want to know?

1. Are we on the write way, (do you have any other idea)?
2. Does that concept have some misses?
3. What is your opinion and experience on that subject?
4. What is your experience with implementing and administering of such
configuration?
5. Could you explain us basic concept of starting up of target database
through SRDF and 
   Time Finder. Sales people from EMC2 told us that some APIs are used for
this purpose.
   Do we have to customize it, or write some programs or scripts?
6. Do you use some special monitoring tools?
7. Could you describe us your step-by-step scenario for starting up target
system in case of primary sitefailure, and specially if your target
site at the time of the failure is open for reporting.
8. What if:
- primary site server fails (loosig data in cache)?
- EMC storrage system fails ?
- Network fails?
- Corrupted blocks (Oracle side)?
9. Have you ever experienced failure and downtime?
10. After all, do you recommend us such configuration?

TIA,
Sonja

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?windows-1250?Q?Sonja_=8Aehovi=E6?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Locking

2001-03-21 Thread Sonja ehovi

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: Multiple recipients of list ORACLE-L


Recently, one of my users nor I could update a table.  As I dug around, I 
couldn't find any of the 'lock' tables such as dba_locks.  Eventually, I 
managed to start data gatherer and get OEM's lock manager to kill the hung 
session.  What do you guys do to find and terminate this deadlock or hung 
sessions?  Are the 'lock' system tables built with specific options during 
db build?

TIA.  ...R
[EMAIL PROTECTED]

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Richard Lau
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?windows-1250?Q?Sonja_=8Aehovi=E6?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



BUG in installing Designer6 Repository on 8.1.7 database

2001-03-20 Thread Sonja ehovi

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 it's almost done)!

Just to let you know.

Sonja 



Title:  ALERT: Some Repository versions will not install on
Oracle
8.1.7.0.0

ALERT: Some Repository versions will not install on Oracle 8.1.7.0.0


Versions Affected
~
Oracle Designer/Repository 6i Release 1 and all Oracle Designer 6.0 versions
prior to Designer 6.0.3.11 (patchset 7)

Platforms Affected
~~
ALL

Description
~~~
During the installation phase of Designer Repository when the script
CIUEET.OPB is fired the 8.1.7.0.0 database server will show 100% CPU
usage and hang indefinitely. The script CIUEET.OPB installs the
component that is responsible for managing UE elements Type Extensions
to the repository. This problem can also occur if you attempt a full
repository import.

Note: This is an Oracle 8.1.7 PLSQL Server bug and not a Designer bug.
  See Oracle 8.1.7 Server PLSQL bug Bug:1396675.

Likelihood of Occurrence

HIGH: This problem will occur everytime you attempt to install  or
import(full repository) a Designer Repository against 8.1.7.0.0 of the
Oracle Server.  The exception to this is Designer 6i release 2 which has
a workaround to the bug applied to its code.  This workaround will be
introduced to a future Designer 6.0 patchset.

Possible Symptoms
~
When the script CIUEET.OPB is fired by the Repository Adminstration Utility
(RAU), the database server will show 100% CPU usage and the database will
hang indefinitely. The database will also hang if a full repository
import is attempted, as the package cioue_element_type(orginal created by
the CIUUET.OPB script) will be executed.


Workaround
~~
Use 8.1.6 of the Oracle Server.

Patches
~~~
However, a workaround has been introduced in the Designer 6i Release 2 code
to
get past the plsql problem.  This release has been certified.  For Designer
6.0

the code change has been introduced in Designer 6.0.3.11.0 (patchset 7).

References
~~
Bug:1396675
Bug:1528667

-- 
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) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



problem with UTL_FILE.FILE OPEN

2001-03-14 Thread Sonja ehovi

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 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) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Inteligent Agent on Oracle817 for OS/390 OSDI

2001-03-14 Thread Sonja ehovi

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
-- 
Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



OEM - Tunning Pack, Diagnostic Pack....

2001-03-12 Thread Sonja ehovi

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 some info on this? Is this really worth the cost?

TIA,
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) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Script for INDEX creation

2001-03-07 Thread Sonja ehovi

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 schema? 
Something like this:
select ('drop index'||' '||index_name||';' )
from user_indexes
 
TIA,
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) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).