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;