RE: limit user CPU usage

2002-01-15 Thread Carle, William T (Bill), ALINF
Hi,       You can set up a profile to set resource limits and have the user use that profile. This is explained in the Oracle Administrator’s Guide.   Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED]   -Original Message- From: kevin wang [mailto:[EM

Undo Tablespace in 9i

2002-01-18 Thread Carle, William T (Bill), ALINF
tablespace, but that is only one test. Any thoughts? Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALINF INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Need idea to strip tabs (chr(9) hex 9) and carriage return (chr(1

2002-01-18 Thread Carle, William T (Bill), ALINF
Title: Need idea to strip tabs (chr(9) hex 9) and carriage return (chr(13) hex 0D) from fields Linda,       I just did something like this yesterday. You will need to use the TRANSLATE function. So you can use an SQL statement like:   update set fld1 = translate(fld1,chr(09),’-‘);

RE: Ftp command

2002-01-21 Thread Carle, William T (Bill), ALINF
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: Carle, William T (Bill), ALINF INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5

RE: ORA-27072/HP-UX file too large

2002-04-04 Thread Carle, William T (Bill), ALINF
ttp://www.orafaq.com -- Author: Carle, William T (Bill), ALINF INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To R

RE: svrmgrl

2002-02-06 Thread Carle, William T (Bill), ALINF
f 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: Carle, William T (Bill), ALINF INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5

RE: Oracle Transparent Gateway

2002-02-06 Thread Carle, William T (Bill), ALINF
stGuru') 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: Carle

Importing 8.1.6 into 8.0.6

2002-03-01 Thread Carle, William T (Bill), ALINF
FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALINF INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Importing 8.1.6 into 8.0.6

2002-03-01 Thread Carle, William T (Bill), ALINF
export from an 8.1.6 database and import it into an 8.0.6 database. Does anyone know how to get around this and get the data moved? Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, Willi

Do you use RMAN?

2002-03-06 Thread Carle, William T (Bill), ALINF
amp;T Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALINF INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public I