Home » SQL & PL/SQL » SQL & PL/SQL » Add Datafile....
Add Datafile.... [message #8653] Wed, 17 September 2003 04:25 Go to next message
Muzzammil
Messages: 99
Registered: February 2003
Member
Hi,

How can we add datafile to an existing tablespace.

If we add datafile is there any problem to the existing data. Do we need to do any alterations to the tablespaces.

Thanks,

Syed Muzzammil.
Re: Add Datafile.... [message #8656 is a reply to message #8653] Wed, 17 September 2003 06:38 Go to previous message
Rajarshi Dasgupta
Messages: 52
Registered: October 2001
Member
Here's the command you asked for.....

ALTER TABLESPACE TABLESPACE_NAME
ADD DATAFILE 'DataFilePath & Name'
SIZE SizeM .... other params.

There will be no problem in the existing data.
Previous Topic: EXECUTE IMMEDIATE giving error in Oracle 9i
Next Topic: Tablespace Size
Goto Forum:
  


Current Time: Thu Mar 28 12:21:07 CDT 2024