| datafile full please help [message #53041] |
Mon, 26 August 2002 09:04  |
Helena
Messages: 42
Registered: February 2002
|
Member |
|
|
|
I have a datafile which is full what should I do, increase the space or clean it if to clean I don't known how to it please help ASAP
|
|
|
|
|
|
| Re: datafile full please help [message #53052 is a reply to message #53041] |
Mon, 26 August 2002 16:10  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
It depends what you are trying to do:
If you add datafile - then you will make more room for data in the tablespace and you will keep the data in the tablespace.
If you "clean" the datafile - you cannot delete datafile only, you have to drop the tablespace to which the datafile belongs. In this case you will loose the data in this tablespace an dhave free disk space.
To add dafile do:
ALTER TABLESPACE tbs_name ADD DATAFILE '/data/db02/oradata/datafile.dbf' SIZE 1024K AUTOEXTEND ON NEXT 1024K MAXSIZE 2097152K
/
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
