Oracle DBA Lite: an introduction to Oracle administration, part 2
for regular access. A simple alter database command does the trick, which I can follow with “alter database open” to make the database accessible ...
alter database resize tablespace - Recover - Data BasyX
Resize Undo Tablespace « Middleware Forum
Recreate the original one using the original name ( optional and size according to your needs ). CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE ‘E:\ORACLE\PRODUCT\10. alter system set undo_tablespace = UNDOTBS2.
alter database resize tablespace - Bookshelf
|
679 pages |
Pro Oracle Database 11g Administration This example resizes the datafile to 5GB: SQL> alter database datafile '/ora01/ oradata/INVREP/reg_data01.dbf' resize 5g; Ifyou don't have space on an ... |
|
524 pages |
OCP Oracle9i database, fundamentals I exam guide To do so, issue the following statement: SQL> ALTER DATABASE DATAFILE 2 'G:\ oradata\0racle\data03.dat' 3 RESIZE 1088M; A third way to expand the size of ... |
|
1344 pages |
Expert Oracle Database 11g Administration Note that you need to use the ALTER DATABASE command, not the ALTER TABLESPACE command, to resize a datafile. SQL> ALTER DATABASE DATAFILE ... |
|
980 pages |
Oracle9i DBA handbook Shrinking Datafiles You can use the alter database command to reclaim unused space from datafiles. You cannot resize a datafile if the space you are trying ... |
|
598 pages |
Portable DBA, Oracle ALTER DATABASE DATAFILE 4 OFFLINE; ALTER DATABASE DATAFILE ' /opt/oracle/dataf ... alter database: Alter a Tempfile ALTER DATABASE TEMPFILE 4 RESIZE 100M; ... |