Tagged Questions
1
vote
1answer
100 views
Oracle database created whats next? Create Schema or Create Tablespace?
I'm a programmer that's being thrown to the DBA/Sysadmin island all by myself with a volleyball that I named Wilson. I'm trying to survive here.
I'm supposed to create a database for an application. ...
2
votes
2answers
1k 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 ...
1
vote
1answer
132 views
Oracle delete technique for table's segment size (data compactness)
I would like to ask if there is any effect on the following deletion technique of a database to the tablespace size. The existing code for clearing the data has the following style of code before:
...
2
votes
1answer
897 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?
1
vote
1answer
338 views
Why is DBA_SEGMENTS presenting twice the amount of data than the DBA_TABLES?
I tried to compute the audit log table usage using the following steps:
Truncate all the audit log table data (i.e. AUD$)
Perform test case that inserts and update data, also delete statement but it ...
1
vote
0answers
191 views
How do I import a dump for a deleted tablespace?
I'm trying to import a database dump, however I am encountering this error:
ORA-39083: Object type TABLE:"MYSCHEMA"."MINF" failed to create with error:
ORA-00959: tablespace '_$deleted$5$0' does not ...
2
votes
1answer
586 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 ...
2
votes
1answer
66 views
Why does connecting to a database use tempspace?
Earlier today we had a problem logging into a database that had just been created automatically.
When on the actual box (Linux) sqlplus schema/pw, i.e. a local connection, was fine, though, it was ...
0
votes
2answers
2k views
In Oracle how do you move a Schema to a different Tablespace?
I noticed that a Schema has been created in the USERS Tablespace but our local rule is that it should be in a Tablespace by itself. In Oracle how do you move a Schema to a different Tablespace?
1
vote
1answer
110 views
file not found - how to remove its configuration?
I run oracle 10.2.0.5.
I have the following:
SQL> select file#, status, error, recover, tablespace_name, name
2 from v$datafile_header
3 where recover='YES'
4 or (RECOVER IS NULL AND ...
3
votes
1answer
2k views
What units used in DBA_TABLESPACE_USAGE_METRICS?
What units are used in the usage metrics (USED_SPACE and TABLESPACE_SIZE columns) described in Oracle's DBA_TABLESPACE_USAGE_METRICS static data dictionary view?
The Oracle Database Reference only ...
8
votes
2answers
516 views
Recovering logical space from a tablespace
I have a tablespace called DATA, and it is setup with auto-extend as false. This tablespace has two datafiles and is set up so it takes up 350 GB of physical space.
A week ago I queried ...
3
votes
1answer
1k 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
148 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
2k 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 ...
2
votes
1answer
167 views
Tablespace consumed by views
I was in an SQL class where the instructor said "DBAs don't like it when users create views, because they will clobber tablespace."
Obviously, I understand that any schema object will consume some ...
3
votes
2answers
796 views
What are the benefits of using a different tablespace for a new user schema?
The tables in the schema are intended to be used read only and is only updated once each three month.
My question refers to
performance
maintenance (backup/restore, export/import)
What about the ...
