To change the oracle user tablespace

In case if you have assigned wrong tablespace while creating a user, you can change tablespace of that user by following command.

first connect with the system on the database where you have created this user.

alter user AHSAN_TFR default tablespace TFR_REP quota unlimited on TFR_REP;

must assign quota otherwise you cannot run any SQL statement.

---

Sphere: Related Content