RE: Is there an Oracle 9i on 32-bit ??

Is there an Oracle 9i on 32-bit ?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: upgrade q

We're running Oracle 8.0.5 for 3 years now and want to go to Oracle9i. Should I a) upgrade OR b) exp the db and do an install of 9i then imp (this is a lenghty process) what say you? TIA. Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Leyden, Joseph

view contents of datafile

://www.orafaq.com -- Author: Leyden, Joseph 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: Working from home

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: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services--

RE: how to make a file writable by anybody?

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

RE: svrmgrl error

??? Dick Goulet Reply Separator Author: "Leyden; Joseph" <[EMAIL PROTECTED]> Date: 5/21/2001 1:56 PM Has anyone seen this error and found what the solution was? Hoping for a long sho

svrmgrl error

. 0509-192 Examine .loader section symbols with the 'dump -Tv' command. oracle@totspt: /home/oracle > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-50

table or view does not exist

Is it possible to check if a table first exist so I do not get any error messages on my installation scripts? * ERROR at line 1: ORA-00942: table or view does not exist -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED

RE: shutdown immediate

ssage- From: Leyden, Joseph [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 3:46 PM To: Multiple recipients of list ORACLE-L Subject: shutdown immediate Sometimes the instance never shuts down, BUT the database gets closed. What else could hang up SVRMGRL ? TIA -- Please s

shutdown immediate

Sometimes the instance never shuts down, BUT the database gets closed. What else could hang up SVRMGRL ? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

shutdown

If ORACLE shuts down and the instance ISN''T, using SHUTDOWN IMMEDIATE, how can I tell who is hanging up oracle? TIA Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: restrict login with known IP address

RACLE-L" <[EMAIL PROTECTED]> > In UNIX, > Knowing the IP address can I restrict any login > to the ORACLE db given this info? > > any help is appreciated ... > > Joe > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- >

restrict login with known IP address

In UNIX, Knowing the IP address can I restrict any login to the ORACLE db given this info? any help is appreciated ... Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Input truncated to 1 characters

I noticed when I install procedures, i get this message: Input truncated to 1 characters can someone help explain this to me? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

'PMON did not start after 120 seconds'

q.com -- Author: Leyden, Joseph 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

'PMON did not start after 120 seconds'

q.com -- Author: Leyden, Joseph 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

imp

I've exported the entire database and while using the interactive imp (import), would also like to get a listing. Is this possible? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services--

import/export

Should I be SYS or SYSTEM user when exporting the entire database? Help! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

number of Mb to add?

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

imp (import) problem

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

oracle 8i NT and Win98

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

write error

terminated unsuccessfully oracle@totsqt: /exp > $ df -tk Filesystem1024-blocks Used Free %Used Mounted on /dev/explv8388608 1311964 7076644 16% /exp oracle@totsqt: /exp > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET:

export/import

Can I import a database from NT which was exported from AIX RS6000 servers? Do I just move the expdat.dmp (exported output) from AIX to NT and simply use the export/import utilities? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL

RE: reset control, redo, logs etc

RACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, March 01, 2001 11:45 AM > > > > If my database was not shutdown before a cold > > backup was made, how do I bring it back up > > skipping (or resetting) ctl, headers etc. > > Is this possible? > >

reset control, redo, logs etc

If my database was not shutdown before a cold backup was made, how do I bring it back up skipping (or resetting) ctl, headers etc. Is this possible? TIA joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network