How to Check/Change Current XDB Tablespace

Use the getxdb_tablespace procedure to check what is the current tablespace being used by the XDB database.

dbms_xdb_tablespace.sql

conn sys@ora11g as sysdba

Connected to:

Oracle 11g Enterprise Edition Release 11.2.0.1.0 – Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining,

Oracle Database Vault and Real Application Testing options


-- Get current XDB tablespace
declare
      v_xdbtbs varchar2(30);
begin
   select dbms_xdb.getxdb_tablespace 
     into v_xdbtbs 
     from dual;
   dbms_output.put_line(a => 'Actual XDB tablespace is:'||v_xdbtbs);
end;
 /

--Create another tablespace
create tablespace tbs_xdb_new datafile size 200M;

--Change XDB tablespace using movexdb_tablespace procedure as follows:
begin
   dbms_xdb.movexdb_tablespace(new_tablespace => 'tbs_xdb_new');
end;
/

--Check new tablespace again with this simple query
select
dbms_xdb.getxdb_tablespace
from
dual;

Leave a Reply

Your email address will not be published. Required fields are marked *