OraFAQ Forum: Server Administration » how to add a data file

Home » RDBMS Server » Server Administration » how to add a data file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to add a data file [message #110992]

Fri, 11 March 2005 12:53

sajan
Messages: 16
Registered: April 2001

Junior Member

Hi all,

the disk drive were my data files r kept is out of free space.

it is giving error related to, can't extend max extend...

if i create a data file in other drive ,will it work??

what r the steps to add a new data file....

thanks in advance...

sajan

Report message to a moderator

Re: how to add a data file [message #111021 is a reply to message #110992]

Sat, 12 March 2005 03:41

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Please post the exact error message. If you get ORA-01631, you need to increase the MAXEXTENTS value for the table. Here is an example:

alter table EMP storage (maxextents 1000);

Best regards.

Frank

Report message to a moderator

Re: how to add a data file [message #111053 is a reply to message #110992]

Sat, 12 March 2005 15:29

KumarD
Messages: 8
Registered: March 2005
Location: india

Junior Member

Hi,

if the server is unable to extent the Maxtents to the table segments...then do the step which is already specified by one of our valuable member...

if you want to add a new file to the existing tablespace.

then do the following operation by logging to the database as SYSDBA

SQL> Alter Tablespace <TS NAME> add datafile 'Name &location' size n m;

please specify the complete path and location of the file

in single quotes...

Regards

Kumar

Report message to a moderator

Re: how to add a data file [message #111073 is a reply to message #110992]

Sun, 13 March 2005 08:23

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

yes adding datafile to another mountpoint should work..

-V

Report message to a moderator

Previous Topic:	URGENT PLZZZZZZ
Next Topic:	Co-Existance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 02:28:17 CDT 2024