Unable to extend temp segment by 1024 in tablespace abc?

Oracle tried to allocate some space in the mentioned tablespace but could not find space there.

Easiest way to solve the problem is to add another datafile.

ALTER TABLESPACE yourtablespace ADD DATAFILE ‘/data/file/path/file.dbf’ size 500M autoextend on;

Or you can resize an existing datafile if you have space.

For adding a new datafile in the ASM location:

ALTER TABLESPACE yourtablespace ADD DATAFILE ‘+DISK_GROUP_NAME’ size 500M autoextend on;

That solved my problem!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s