We are using unix svr4.2 and oracle7.0 on it, now it has started giving regular error ORA-01547, i.e., a tablespace problem, we are also falling short of disk space, is there any way out other than...
http://www.experts-exchange.com/Database/Oracle/Q_10354771.html
Zones:
OracleDate Answered: 05/27/2000 Grade: B Views: 0
How can I de-fragment tablesapce? I have deleted 100k records but there is still less space available in Tablespace?
Please help
http://www.experts-exchange.com/Database/Oracle/Q_20152809.html
Zones:
OracleDate Answered: 04/17/2002 Grade: A Views: 0
When there is a DBA role or connect,resource granted to a schema, things are fine. But revoke these and grant just create session for taking export dump for smooth import into any other user with w...
http://www.experts-exchange.com/Database/Oracle/Q_20173669.html
Zones:
OracleDate Answered: 09/09/2001 Grade: A Views: 4
i'm using oracle 9i for database...but after i create tablespace and user an error occured (ORA-12911:permanent tablespace cannot be temporary tablespace)
here is the statement for create tables...
http://www.experts-exchange.com/Database/Oracle/Q_20227486.html
Zones:
OracleDate Answered: 11/08/2001 Grade: B Views: 0
When I run a report in crystal i get a database dll error if i run the same report in sql it returns that it cannot allocate 29 extents in tablespace 10.
I do not have a tablespace 10 all my table...
http://www.experts-exchange.com/Database/Oracle/Q_20385928.html
Zones:
OracleDate Answered: 08/13/2003 Grade: B Views: 0
Hello,
Finishing up my database migration project, I realise that there are extra Datafiles that were defined and some existing datafiles need to be moved to different physical locations.
I t...
http://www.experts-exchange.com/Database/Oracle/Q_21146810.html
Hi,
Oracle 9.2.0.4 and sun solaries DW Environment.
Please find the current system Tablespace details :
Tablespace Free MB Total MB Pct. Free
SYSTEM 400.67 600 66.78
Under followin...
http://www.experts-exchange.com/Database/Oracle/Q_21456860.html
Zones:
OracleDate Answered: 06/14/2005 Grade: A Views: 50
I understand from an Ask Tom article that temp tablespaces will not "show" their resources being released within the OEM but that is not to say that the database is really actively using all the st...
http://www.experts-exchange.com/Database/Oracle/Q_21522450.html
Zones:
OracleDate Answered: 08/10/2005 Grade: A Views: 0
Hi,
How do I assign a particular tablespace during a create?
I'm using a Create/Select:
Create table NOTE_BAK as Select * from MASTER_NOTE;
When I do this, I get an error: ORA-01652: U...
http://www.experts-exchange.com/Database/Oracle/Q_21649918.html
Zones:
OracleDate Answered: 12/01/2005 Grade: B Views: 0
For the default temporary tablespace:
1. Should you use autoallocate or local uniform size
2. How to determine the next and local uniform size if sort_area_size=524288; OLTP environment
3. Is it...
http://www.experts-exchange.com/Database/Oracle/Q_21911710.html
Zones:
OracleDate Answered: 09/08/2007 Grade: A Views: 0
