Add Datafile.... [message #8653] |
Wed, 17 September 2003 04:25 |
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 |
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.
|
|
|