Timeline for oracle tablespaces
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 6, 2014 at 2:21 | comment | added | Yasir Arsanukayev |
Did you try to set quota to 0 on USER tablespace before importing data? For example, alter user YOURUSERNAME quota 0 on tablespace users. If the user doesn't have the necessary quota on the tablespace where the data should be imported from the dump file, then the data is imported in default tablespace set for the user, e. g. alter user YOURUSERNAME default tablespace newtbs. Check this out docs.oracle.com/cd/E11882_01/server.112/e22490/…
|
|
| Sep 3, 2014 at 13:48 | comment | added | user2722863 | My user on server is related to correct tablespace "DATTATAB" but tables for that user are related to USER tablespace....tables contain indexes and constraints.....How can I now change for tables to go to DATATAB tablespace??? | |
| Aug 21, 2014 at 2:45 | history | answered | Yasir Arsanukayev | CC BY-SA 3.0 |