| problem resizing a datafile [message #61940] |
Fri, 11 June 2004 02:52  |
seka
Messages: 11
Registered: November 2001
|
Junior Member |
|
|
I have run the command :
ALTER DATABASE DATAFILE ‘/data/oradata/test.dbf’ RESIZE 5000M;
Then whe I checked in v$datafile and in the actual file in the system(operating system) in the machine, I found that indeed the space was added but still my table space still shows that there is still a shortage of space. I had connect using telnet, but I lost the connection before the command complete, Could this be the reason.
Before I resize the datafile the below sql was giving me the output below:
select file#,bytes,create_bytes,status,name from v$datafile
Before I resize the datafile the below sql was giving me the output below:
FILE# BYTES CREATE_BYTES STATUS NAME
9 5242880000 5242880000 ONLINE /data/oradata/test/p02prt.dbf
After I resize the datafile the below the sql is giving me the output below:
9 1.0486E+10 5242880000 ONLINE /data/oradata/test/p02prt.dbf
Someone help me.
Thank you in advance.
|
|
|
|
| Re: problem resizing a datafile [message #61944 is a reply to message #61940] |
Fri, 11 June 2004 05:30  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Looks like it went through successfully. To confirm, check your ALERT.LOG file.
BYTES - Current size in bytes; 0 if inaccessible
CREATE_BYTES - Size when created, in bytes
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
