Skip to content
Advertisements

ora-25153 temporary tablespace empty

When i going to start the export of a one user, it shows error ,

ora-25153 temporary tablespace empty.

Solution :

Add one temp file for temporary tablespace

sql>alter tablespace temp add datafile ‘D:\oracle\product\10.2.0\oradata\orcl\temp02.dbf’ size 10m;

Tablespace altered.

Now i can able to start export.

view: dba_temp_files

Advertisements
No comments yet

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

%d bloggers like this: