RE: Locally Managed Tablespaces

2002-06-14 Thread Marmdba
I am using 9.0.1 - can the system tablespace be setup as lmt? Or is that new in 9.2? Michele -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--

Locally Managed Tablespaces

2002-06-13 Thread Marmdba
Hi All, I am setting up a 9i instance and am wondering if there are any tablespaces that you would not set up as locally managed. Would system and rollback tablespaces be set up as dictionary managed or locally managed? Are there any guidelines when considering lmt or dmt? Thanks, Michele A

Tru64 Unix and Oracle

2002-05-21 Thread Marmdba
Hi all, I am new to the Tru64 flavor of Unix and would like to find out if there are kernal parameters that need to be set for Oracle (similar to the shm parameters on SUN)? Also, I would like to know if there are any other differences in terms of an Oracle installation on Tru64. TIA, Miche

RE: DB Clone from RMAN backups

2002-05-20 Thread Marmdba
Thanks for the info. I have not but I will. Have you tried it? Michele -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet acces

DB Clone from RMAN backups

2002-05-20 Thread Marmdba
Hi all, I am trying to speed up refreshes of QA databases and am familiar with cloning databases using user managed backups (hot and cold). The problem is the organization I am currently with uses RMAN to manage the backups. The perform a level 0 once a month, level 1 once a week, level 2 dai