Re: Transport tablespace in Oracle 8i

A copy of this was sent to John Chiu <johnymc_at_netscape.com> (if that email address didn't require changing) On Thu, 02 Sep 1999 05:46:07 -0400, you wrote:

>I try to plug in the tablespace set into the target database using
>import, then I got an error
>
>IMP-00003 Oracle error 6550 encountered
>ORA-06550 Line 1 Column 7:
>PLS-00201 identifier 'DBMS_PLUGTS.NEWTABLESPACE' must be declared.
>ORA-06550 Line 1 Column 7:
>PL/SQL: Statement ignored
>
>my import parameter file:
>
>transport_tablespace=y
>datafiles='c:\bk\users.dbf'
>tablespaces=users
>tts_owners=jb
>file=c:\bk\x.dmp
>
>Import failed and I found nowhere to define DBMS_PLUGTS.NEWTABLESPACE.
>
>Thanks for any assistance.
>
>John

the public synonym for dbms_plugts is missing. if you imp as other then sys it'll not find it.

simply log in as sys or internal and create a public synonym dbms_plugts for dbms_plugts.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Sep 02 1999 - 06:51:54 CDT