RE: Export Problem - Urgent

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

Oracle 7.2 32 bit Oracle Ole Objects

Hi, Does anyone know how I can get a copy of 16 bit Oracle 7.2 Oracle Ole Objects to install? I know probably next to impossible to find but any help is appreciated. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL

OT: SqlSever 2000 question

in table2 for that ID in one record For ex. 1,SmithJ,TN,county1 | county2 | county3 | countyN Any ideas, Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: Script to Disable Constraint, Change Value, then Enable Const

I have had the same type of requirement and decided to use deferrable constraints. Works great! Rick -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 28, 2001 11:56 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Script to

RE: Doubts reg :Export and import

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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services

RE: Script to Disable Constraint, Change Value, then Enable Const

immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message-From: Cale, Rick T (Richard) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 28, 2001 12:29 PMTo: Multiple recipients of list ORACLE-LSubject

RE: SQL Query OutPut

(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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Command line utility to show installed Oracle software

Hi All, I have forgotten the command line utility to show installed Oracle software. Oracle 8.0.5/NT 4. Can someone tell me? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services

LMTs Uniform vs Autoallocate

-- Author: Cale, Rick T (Richard) 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: Problems with Pro*C

: 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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services

RE: Sqlimportante

(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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: import/export problem in oem

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

Where are the Import/Export utilities in 9i

never needed this before. How can I just do a simple import/export? Oracle 9i/Win 2k environment Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

IMP-00037 Character marker set unknown

-- Author: Cale, Rick T (Richard) 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

RE: inactive sessions

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

RE: what is the fastest way to update a big table with more than 50000 rows and 20 columns

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: Cale, Rick T (Richard) INET: [EMAIL

RE: what is the fastest way to update a big table with more than

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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Consistent Gets

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

RE: Oracle9i-Download

Title: Oracle9i-Download I had the same problem and gave up, submitted a tar to client relations and they sent complete 9i CD suite within a week. Rick -Original Message-From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]]Sent: Friday, October 26, 2001 7:45 AMTo:

RE: Database will not shutdown in Normal or IMMEDIATE mode

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

Write to file in XML format

Hi All, I wanting to read data from table(s) and then create an output file in XML format. I have never done it so does anyone have good examples or point me to some good resources. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard

Dropping table is not completing

Hi All, I am trying to drop a table. It is not locked and has very few records in it. I am trying to drop it but it will not. What can I check to find out why it will not drop? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET

RE: Dropping table is not completing

All, I am trying to drop a table. It is not locked and has very few records in it. I am trying to drop it but it will not. What can I check to find out why it will not drop? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET

Database will not shutdown in Normal or IMMEDIATE mode

in NORMAL or IMMEDIATE. No other users/sessions on the system. I have done this many times but not working today. I need to do this because I want to do an offline backup. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL

RE: Migration v. Upgrade

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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network

RE: Oracle - SQL Server

Title: Oracle -> SQL Server I have not used it but Oracle Transparent Gateway can query against a SQL Server database. This is a very expensive product. Rick -Original Message-From: Christopher Spence [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 02, 2001 2:41 PMTo:

RE: Repost: Nested loop in PL/SQL

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

RE: changing the internal password

. Is there any way to change it? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: partition

In 8.0.x it will NOT do the update. I think in 8i it will but not sure. Rick -Original Message-From: Maya Kenner [mailto:[EMAIL PROTECTED]]Sent: Monday, September 24, 2001 10:50 AMTo: Multiple recipients of list ORACLE-LSubject: partition Hello, I have a

RE: ORA-04031

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) 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 find the current instance name?

://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

RE: How to find the current instance name?

You can if you grant select privs. -Original Message- Sent: Thursday, September 20, 2001 8:50 AM To: Multiple recipients of list ORACLE-L i cann't access V$ views as an ordinary user, rt? -Original Message- From: Cale, Rick T (Richard) [SMTP:[EMAIL PROTECTED]] Sent

RE: inspdver... equivalent in 8i and above...

From MetaLink To explain the disappearance of the inspdver utility from theOracle8i. The inspdver utility is not supplied with Oracle8i. Previous versions of Oracle supplied the 'inspdver' utility in the$ORACLE_HOME/orainst directory.

RE: sizeiof table!!!

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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network

RE: Dump Oracle Tables To ASCII/Comma Delimited File

anybody tell me the command/tool in oracle that can dump Oracle Tables To ASCII/Comma Delimited File. Regds deepender gupta -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

What is maximum length of sql statement sent to Oracle server?

Hi All What is maximum length of sql statement sent to Oracle Server 8.0.5? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Sad News - Jets crashed into World Trade Center

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

RE: STOP THE PRESS!!

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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City

RE: STOP THE PRESS!!

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

RE: query for top customer

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

RE: PK Violation on insert

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

RE: Alter tablespace add datafile

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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Where are temp segments created?

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

RE: ms acces

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

RE: create sequence in PL/SQL anonymous block - needs to be in se

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

OT: Reverse engineer access database

://www.orafaq.com -- Author: Cale, Rick T (Richard) 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

Access to Oracle

: Cale, Rick T (Richard) 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

RE: Column Name

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

RE: Problem with DBMS_SQL

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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: 9i NT

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

RE: Export Problem

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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: 9i NT

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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network

PK/Fk question

. Every value for table2.col1 is in the table table1.col1. I want to enforce this at the database server level. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: OCP Test timeframe

://www.orafaq.com -- Author: Cale, Rick T (Richard) 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: Delete Alertlog on NT

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

RE: Spool 32 Error

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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: Two (probably simple) questions, function based index and table p

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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: Export

: Friday, August 17, 2001 7:07 AM To: Multiple recipients of list ORACLE-L Hi Can you please tell me if there is a way of exporting select rows from a given table in 8.1.6.2??? Thanks in advance Rgds Fawzia -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T

No TNSListner service after intall 8.1.7 on Win 2k

the listener. All other installs I have done on NT always created a tnslistner service. This in my first install on Win 2k. Anyone have any ideas on why service did not get created and how to correct? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T

Can a SYSTEM tablespace be locally managed.

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

What file(s) does Oracle read in deciding what has been installed.

is Oracle reading this from so I can delete this d__n file. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: No TNSListner service after intall 8.1.7 on Win 2k

%, but that doesn't work. Anyone? Again I may be pre-coffee. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Cale, Rick T (Richard) [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 12:36 PM To: Multiple

Allow only certain ports for sql*net traffic

file to handle this? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: No TNSListner service after install 8.1.7 on Win 2k

and set them for Manual startup. They add a little bit of bulk to the registry but consume no other resources. Anyone have anything else to add or correct? Cale, Rick T (Richard) To: Multiple recipients of list ORACLE-L

Size of Oracle binaries of Oracle 8i vs 8.0 on Windows

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

RE: ON UPDATE CASCADE?

I think you will have write a on update, on insert trigger to accomplish this. Rick -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Monday, August 13, 2001 11:00 AMTo: Multiple recipients of list ORACLE-LSubject: ON UPDATE CASCADE? I want

CLOBs storage vs Varchar storage

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

RE: PL/SQL length overflow prob

://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

RE: Convert LONG to VARCHAR2

Thanks for the reply but if that is all you have to offer please keep it to yourself. -Original Message- Sent: Thursday, August 02, 2001 5:14 PM To: Multiple recipients of list ORACLE-L By loosing a gig or two of information. -Original Message- From: Cale, Rick T (Richard

Convert LONG to VARCHAR2

Hi All, I know it has been discussed before but can anyone tell me how to convert a LONG datatype to VARCHAR2? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: grants to schema query

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

RE: upgrade

are invalid. I have tried to recompile them to no avail. I did the upgrade manually running the script :u0800050. Is there anything else I needed to run??? Rgds Fawzia -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat

RE: upgrade

to run??? Rgds Fawzia -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Version of personal oracle that runs on Window ME

Hi All, Does anyone know where I can get/download copy of Oracle that runs on Window ME I downloaded 8i for 98 but BSOD. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services

Rollback Segment needs recovery

because I got datafile corruption error. I am in noarchive mode. Any ideas how to proceed? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: Rollback Segment needs recovery

how to proceed? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Help

Title: Help Lots of ways CREATE TABLE ouruser AS SELECT * FROM myuser UNION ALL SELECT * FROM uruser; This will create a table ouruser with 10,000 records. Rick -Original Message-From: Deewaker G.V. [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 26, 2001 7:47 AMTo:

RE: deletion of data from a large table

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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: Sql/PLUS Question

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

Best way to upgrade database/move data

server? Essentially replicate everything from old server to new server. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: strtSID.cmd security hole??

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

RE: Input truncated

, 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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED

RE: get yesterdays date

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

RE: Locally managed tablespaces

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

RE: Java

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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services

RE: how to rename a database SID

Title: how to rename a database SID See Note Note:15390.1Subject:How to Determine and Change DB_NAME or ORACLE_SID on MetaLink Here it is below Rick Purpose This entry describes how to find and change the "db_name" for a database, or the ORACLE_SID for an instance, without recreating

RE: how to rename a database SID

(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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: transfer of large datafile Oracle7.3.4.4 databases to 8.1.7.

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

RE: Data storage for Numeric data

Hi All, If I have fields defined as NUMBER(2,0) and NUMBER(7,0) how much storage does Oracle used if fields are NULL or the fields do not use entire width. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED

Surrogate keys

Hi All, Can someone explain pros/cons to using surrogate keys(i.e.,sequences) vs non-surrogate keys? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Data storage for numeric data

Hi All, If I have fields defined as NUMBER(2,0) and NUMBER(7,0) how much storage does Oracle used if fields are NULL or the fields do not use entire width. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED

Oracle to Access indexes do not import

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

RE: adding columns to system tables

://www.orafaq.com -- Author: Cale, Rick T (Richard) 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

RE: DB Link Between Prod and Test?

(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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: Silver vs. Gold support

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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Actual size of database

Hi All, Oracle 8.0.5 NT 4 Does anyone have a script they would share that can calculate the ACTUAL size of a database(space_used) not what has been allocated? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED

Datafile needs media recovery

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

RE: Datafile needs media recovery

ine. We cannot drop the tablespace and rebuild. We could maybe export all objects in that tablespace then rebuild. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Prompt and accept a value inside a procedure

Hi All, Is there a way to prompt a user and accept input from the user inside a procedure. I cannot get the prompt/accept to work inside a procedure. It works it sql*plus. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET

RE: tnsnames problem

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

  1   2   >