RE: RMAN resync of catalog to controlfile

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.net -- Author: Clinton Naude INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Basic RMAN question

-- Author: Clinton Naude INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

Checking when a table was last updated.

Hi. What sytax can I used to see when a table or object was last updated/modified? Thanks Clint Confidentiality Warning===The contents of this message and any attachments are intended solely for the addressee's use and may be legally privileged and/or confidential.

[no subject]

What is the syntax to delete multiple objects, or more specifically multiple tables from a user in 1 go. I need to delete 50+ tables/objects without deleting them 1 by 1. Thanks Clint

Upgrade to 8.1.7.4?

://www.orafaq.com -- Author: Clinton Naude 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

patch url needed please.

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Clinton Naude INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Textfile into oracle

Title: RE: Textfile into oracle Yes, use Sqlloader... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: Textfile into oracle Hallo, I have this excelfile. Is it possible

RE: Archive log full

Title: RE: Archive log full Do a backup that includes deleteing the archive logs. -Original Message- From: sam d [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 2:23 PM To: Multiple recipients of list ORACLE-L Subject: Archive log full Hi List, I am new to oracle, Archive

Staffware on Oracle - deletes are hanging...

Hi all. Anyone that is running Staffware out there on Oracle 8.1.7 - please help me out here. This is urgent. We are trying to delete 70 000 rows from a table - via Staffware, so that we can do a restore - via Staffware. This seems to take over 10 hours, and still does not seem to

Memory?

Hi all. Does anyone have any idea how to calculate the amount of memory each user uses during a session? This needs to be done to calculate the amount of memory Lawson will use during production. Any help given will be appreciated. Thanks Clint Confidentiality

[no subject]

How much memory is allocated to each login to Oracle? Is it not 20-30mb? I have heard people mention of 300mb? Surely this would bring most servers down if it was true. Clint Currency.gif Description: GIF image

RE:

that its table use...300mb on unix machines is not a big deal... Clinton Naude [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/23/02 04:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL

RE: client-side memory requirements

:[EMAIL PROTECTED]]Sent: 23 April 2002 12:59To: Multiple recipients of list ORACLE-LSubject: Re: Depends on the size of table space that its table use...300mb on unix machines is not a big deal... Clinton Naude [EMAIL PROTECTED] Sent

RE: JDBC errors?

Title: JDBC errors? Sorry, the errormessage is the following: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)

RE: svrmgrl

Title: RE: svrmgrl svrmgrl no longer exists on 9i. You must use sqlplus. Clint -Original Message- From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 10:33 PM To: Multiple recipients of list ORACLE-L Subject: RE: svrmgrl Didn't Oracle get rid of

JDBC errors?

Title: JDBC errors? Hi all. I am getting weird results while trying to connect via jdbc to an Oracle 817 db on Windows 2000. I can connect via ODBC, but not JDBC, any ideas? Thanks Clint Confidentiality Warning === The contents of this message and any

RE: Enterprisemanager?

Title: RE: Enterprisemanager? Yip, spot on here. You can do exports etc to move the data if you want via the gui. Clint -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 1:35 PM To: Multiple recipients of list ORACLE-L Subject: RE:

RE: Import MS SQL Server 2000 DB into Oracle EE 8.1.7

Can't do the data, but the design yes. Oracle provides a tools called Oracle Migration qworkbench that works pretty well. Make sure that you change the table owner names etc to the correct owner. Good luck. Clint -Original Message-From: S.Jyotinarayan [mailto:[EMAIL

RE: Oracle 9i and OEM

Title: RE: Oracle 9i and OEM Check to see if the intelligent agent is running for that machine/instance. If not start it and then remove the node from OEM and do a rediscovery for that machine. That should work. Thanks Clint * Clinton S. Naude * Head DBA Services * Tel: 011 685 4304

Oracle for Solaris (on Intel)

Hi all. I sent out a mail recently about Oracle for Solaris on Intel, but never saw any replies. Has anyone got any facts/info on this. What are the pro's and cons? Thanks. Clint

Lawson and Staffware running on Oracle?

Hi all. Does anyone out there know of any issues running on Oracle 8.1.7, which in turn runs on a Unix box (Solaris version 8)? The box will probably be a 3800 or a 4800 (still to be purchased) Info on issues such as sizing, security, tuning etc would be of great help or even any known

RE: Unable to open the database,Urgent!!!

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Clinton Naude INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: OEM Repos install error.

ude 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: Clinton Naude INET: [EMAIL PROTECTED] Fat City Networ

Problems on Sun E450 server.

ORACLE-L FAQ: http://www.orafaq.com -- Author: Clinton Naude INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Errors in Oracle

://www.orafaq.com -- Author: Clinton Naude 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

RE: Dropping datafiles

lease see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Clinton Naude INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: Dropping datafiles

(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Clinton Naude INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: How to backup entire db?

). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Clinton Naude INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public