Tkprof/explain plan errors

I am trying to do some performance tuning on a user’s query by using tkprof. After running tkprof on the trace file (which was generated after using alter sessions set sql_trace true), I look at the results and they say error connecting to database using: / ORA-01017: invalid username/password

Create Table performance problem

Does CREATE TABLE AS SELECT . still use indexes or are the indexes disregarded if the select is issued in combination with a create table? Oracle 8.0.5, optimizer is CHOOSE. We are having a performance problem when trying to use create table as select. - Sent using MailStart.c

Nologging

I know it is possible when creating a table to specify no logging so that it doesn't generate redo logs. Is it possible, AFTER the table has already been created, to change it to nologging? Also this is a dev database that we don't care about doing any type of recovery and just want to do some

8.0.5 to 8i upgrade

We want to do an 8.0.5 to 8i upgrade (HPUX). There are six databases on the system where the upgrade is required. How long does the upgrade typically take? What kind of downtime should be expected? Are there any major "gotchas" of doing the 8.0.5 to 8i upgrade? - Sent using MailStart.com