0

I am trying to alter the default temporary space by executing the following commands.

exec rdsadmin.rdsadmin_util.alter_default_temp_tablespace(tablespace_name => 'temp01');
BEGIN rdsadmin.rdsadmin_util.alter_default_temp_tablespace(tablespace_name => 'temp01') END;

but getting "ORA-00900" error.

How can I get this to work?

d-_-b
  • 4,142
  • 6
  • 28
  • 43
  • Can you try with `begin end; /` block. As explained in [this](http://stackoverflow.com/questions/13722307/ora-00900-invalid-sql-statement-when-run-a-procedure-in-oracle-10g) the `exec` command is specific to `sql*plus` and may not work in online IDE. – bprasanna Apr 15 '17 at 18:37
  • I tried that, it did not work either. – d-_-b Apr 16 '17 at 09:20

0 Answers0