CODEWITHSUNDEEP
oracle-databaseplsqloracle-sqldeveloper
einstein007
einstein007

Reputation: 61

How to modify the max size of a tablespace oracle 12c

I have a table space called ts witch has a maximum size 10go I need to add a 1go how can I proceed?

Thanks

Upvotes: 2

Views: 37950

Answers (2)

Marco Baldelli
Marco Baldelli

Reputation: 3728

Are you talking about the automatic extension of data files?

In that case the command you need will be similar to this:

alter database datafile 'filename' autoextend on next 512K maxsize 11G;

See the section Enabling and Disabling Automatic Extension for a Data File of the Oracle 12.1 Database Administrator's Guide.

Upvotes: 4

Richard Hansell
Richard Hansell

Reputation: 5403

According to the documentation:

http://docs.oracle.com/database/121/SQLRF/statements_3002.htm

I guess this only makes sense if you have autoextend enabled? If you do then you can pick out the syntax from the documentation, something like this?

ALTER TABLESPACE myTableSpace RESIZE 11G

Upvotes: -1

Related Questions