Hello World. This is my First of First Blog. Here I will try to write things related to what I learn, Since I am kinda obsessed with Technology’s lineage. I, being a Java professional, love Java profoundly and so tried to make a blog that will help you and me of course to be in touch with new happenings in the field of technology. I may soon start a discussion forum based on Java, for that we need to wait a while, after all , not always, good things are FREE….
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.
Posted by Unknown at 10:34 PM
Labels: oracle, tablespace
Posts
0 comments:
Post a Comment