3 Replies Latest reply: Jul 17, 2014 9:08 AM by odie_63 RSS

    Is it possibe to move the XDB tablespace in XE?

    gbarbour

      Hi, I wish to move the XDB tablespace.

       

      Tried this from DOC ID 1271560.1

       

      SELECT any_path FROM resource_view;

      set serversupport on;

      begin

      xdb.dbms_xdb.movexdb_tablespace('XDB', trace=>TRUE);

      end;

      /

      I get:-

      PLS-00306: Wrong number of arguments in call to

       

      Anyone come across this?

        • 1. Re: Is it possibe to move the XDB tablespace in XE?
          clcarter

          Not seeing any mention of that trace parameter in the 11gR2 docs, perhaps try it with out that one.

           

          Or the rdbms/admin/catnoqm scrip drops XDB, and catqm creates it. For my money seems a drop/recreate might be the easier way to go. Maybe.

          • 2. Re: Is it possibe to move the XDB tablespace in XE?
            gbarbour

            Tried without the trace, no joy.

            Looks like droppping and re-creating, as you say, is the way to go here.

            The point here is the creeping fragmentation that takes place in the SYSAUX tablespace if user stuff (web pages, images etc.) are stored there, which they are  if you use it as a Gateway.  Oracle recommends SYSAUX is left alone. Hence moving XDB to it's own TABLESPACE.

             

            So my plan is :-

            export My Stuff.

            Delete DB.

            Recreate DB

            Modify (now) Vanilla DB move XDB to XDB Tablespace.

            Modify the embedded PL/SQL Gateway

            Import My Stuff back in.

            ..

            Log in and watch the screen light up!  (ever the optimist).

            I'll post here if works.

             

             


            • 3. Re: Is it possibe to move the XDB tablespace in XE?
              odie_63

              gbarbour wrote:

               

              Tried without the trace, no joy.

              What do you mean?

              Did you get another error?

               

              Indeed, there's no "trace" argument. The signature looks like this on XE :

              ---------------------------------------------

              -- PROCEDURE - movexdb_tablespace

              --     Moves xdb in the specified tablespace. The move waits for all

              --     concurrent XDB sessions to exit.

              -- PARAMETERS - name of the tablespace where xdb is to be moved.

              --

              ---------------------------------------------

              PROCEDURE movexdb_tablespace(new_tablespace IN VARCHAR2);