I had to enter 'sys as sysdba' at username prompt and then regular password
at the password prompt (AIX 4.3.3 w/ 8.1.6.0). Tried 'sys' for username and
'as dba' for password but it did not work, got ORA -1017..
- Kirti
> -----Original Message-----
> From: Rachel Carmichael [SMTP:carmichr_at_hotmail.com]
> Sent: Saturday, May 27, 2000 11:14 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: transportable tablespaces
>
> yeah, finally... it grew out of the tablespace point in time recovery...
>
> Marlene Theriault did a paper on transportable tablespaces for IOUG-a. She
>
> found something about having to do the export as SYS???
>
> actually, she did the export and import without giving a username. when
> prompted she entered "sys" when prompted for password she entered "as
> sysdba" and it worked
>
> (no quote marks)
>
>
> Rachel
>
>
> >From: "Joseph S. Testa" <teci_at_oracle-dba.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: transportable tablespaces
> >Date: Sat, 27 May 2000 10:13:58 -0800
> >
> >
> >Well i finally got a chance to play with it.
> >
> >pretty cool stuff.
> >
> >on my desktop(rh 6.0, oracle 8.1.5.0.1), took a 600M tablespace(ok
> >technically a datafile), put it in read only mode, took export of
> >metadata, copied to my laptop(same os and oracle version)(via the home
> >100mbs lan, whic still took ~30 mins), and ran the imp of the metadata,
> >and poof it was there.
> >
> >I must admit, thats one of the best things oracle has done in recent
> >time(and alter table drop column).
> >
> >joe
> >--
> >Joe Testa http://www.oracle-dba.com
> >Oracle 8i documentation online http://www.oracle-dba.com/oracle-docs
> >--
> >Author: Joseph S. Testa
> > INET: teci_at_oracle-dba.com
> >
> >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, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') 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).
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
> 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, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') 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
Received on Sun May 28 2000 - 21:18:22 CDT
