Re: Transportable tablespaces in 8i

I'm currently testing transportable tablespaces and found that you simply need to have execute access to this package :

as sys : grant execute on dbms_tts to <you>;

then reference the owner of the package, sys, or create a synonym :

execute sys.dbms_tts.transport_set_check('A_TABLESPACE', TRUE or FALSE); -- don't quote the TRUE of FALSE

On Thu, 07 Sep 2000 11:51:27 -0500, Ron Scott <rscott_at_visi.com> wrote:

>Is anybody using the transportable tablespace feature of 8i?
>
>I'm trying to check this feature out, and running into trouble.
>In fact, trying to execute DBMS_TTS.TRANSPORT_SET_CHECK, I find
>the DBMS_TTS package undefined. I can find declarations for this
>package in file dbmsplts.sql in .../rdbms/admin, but no body
>definitions.
>Where would the body of this package be defined, or how do I access this
>feature?
>
>Was this a feature that needed to be turned in in my long-forgotten
>Oracle installation procedure?
>
>Ron Scott
>rscott_at_visi.com
Received on Mon Oct 02 2000 - 12:25:45 CDT