Tagged Questions
1
vote
2answers
801 views
“ORA-01950: no privileges on tablespace 'SYSTEM' ” : What error is it?
Earlier I created a user :
SQL>create user suhail identified by password
SQL>User created.
SQL>Grant create session,create table to suhail;
SQL>Grant Succeeded.
but when I login as ...
2
votes
1answer
692 views
Expanding system tablespace
I need to add new data file into the system tablespace because its running out of space. Are there any precautionary measures I should consider since this is a production environment?
2
votes
1answer
540 views
Drop user did not reduce size of tablespace file
I have a development environment in which I frequently copy a certain schema.
When I'm done with the copy, I will use OracleEM to drop that user/schema.
My problem is that this does not seem to ...
1
vote
1answer
391 views
Rule of thumb: AUTOALLOCATE or UNIFORM size for tablespaces
Is there a rule of thumb for creating a tablespace with extent management AUTOALLOCATE or UNIFORM? If the latter applies, how to estimate a reasonable extent size?
Even more, what should apply for ...
3
votes
1answer
991 views
How can I delete a corrupted table space?
Problem:
On an Oracle 11.2g DB;
We have a corrupted TS that does not allow starting the database instance above mount state. The TS cannot be removed with standard methods (i.e., enterprise manager).
...
1
vote
1answer
146 views
Oracle block usage
I am wondering about a weird deadlock and after checking all other components I am considering it to be a INITRANS problem in Oracle 11.2.
Now three questions arose:
Is there some way of analyzing ...
2
votes
1answer
1k views
How do I create a database+tablespace+user in Oracle 11gR2?
Good evening,
I'm trying to figure out how to create a database+tablespace+user in Oracle 11g.
I've tried some tutorials, but nothing seems to work.
I cannot find Database Configuration Assistant ...
