Oracle on Sun StorEdge T3 Disk Array

2002-02-28 Thread Kevin Bass
Title: max open cursors exceeded We have just gotten in a Sun StorEdge T3 Disk Array for the database and future data warehouse. This T3 disk array has 18 hard drives with 36 gigs of space each. Has anyone had any experiences, problems or comments while setting up or using it.   Kevin Bass

RE: Create Database ... really dumb question

2002-02-14 Thread Kevin Bass
I would think that the database name of testccl would need to be in double quotes. Kevin Bass Senior Manager, I.D.E. Americal Corporation Phone: (252) 762-2144 E-mail: [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 14, 2002 8:23 AM To: Multiple recipients of list ORACLE

Cannot bring tablespace online

2001-12-13 Thread Kevin Bass
alter database datafile '/u02/oradata/MPDB/tie02.dbf' OFFLINE DROP; shutdown normal startup open; The tablespace still cannot come back on-line. Am I missing a step? Kevin B. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Bass INET: [EMAIL PROTECTED] F

RE: Why is this code not working?

2001-12-11 Thread Kevin Bass
t 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: Kevin Bass INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: Corrupted data blocks in tablespace SYSTEM

2001-12-03 Thread Kevin Bass
r 03, 2001 2:21 PM To: Multiple recipients of list ORACLE-L > Kevin Bass wrote: > > I have just started a project and have encountered a database problem. > The previous DBA did not create any backup scripts or backup and > recovery plans. Is there a way to get around this problem

Corrupted data blocks in tablespace SYSTEM

2001-12-03 Thread Kevin Bass
I have just started a project and have encountered a database problem. The previous DBA did not create any backup scripts or backup and recovery plans. Is there a way to get around this problem without re-creating the database?     When executing my script to get corrupted data block inform

Re: EXPORT problem

2001-11-16 Thread Kevin Bass
gain .. > > Deepak > > PS: picked up off of ML > > --- Kevin Bass <[EMAIL PROTECTED]> wrote: > > UNIX help needed for sed multi-line pattern spaceI > > have just started working at a company and the > > database has never been backed up since it was &g

EXPORT problem

2001-11-15 Thread Kevin Bass
Title: UNIX help needed for sed multi-line pattern space I have just started working at a company and the database has never been backed up since it was created.  I am now performing an EXPORT of the database and I am experiencing an EXPORT problem that I have never encountered.  Has anyone

SQL Navigator Question

2001-11-15 Thread Kevin Bass
one encountered this problem before? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Bass INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet ac

Database Structure

2001-11-04 Thread Kevin Bass
I cannot determine the size of the hard drives. How many hard drives should I use for Oracle and what should be the recommended size requirements for each hard drive? Thanks, Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Bass INET: [EMAIL PROTECTED