Create tablespace xxx datafile 'filename.dbf' size <b/k/m/g> ... ;

Alter tablespace xxx add datafile 'filename.dbf' size <b/k/m/g> <autoextend...>;


-----Original Message-----
From: Philpott Mark (US SSA) [mailto:oracledba-ezmlmshield-x65124721.[Email address protected]
Sent: Wednesday, June 28, 2006 12:41 PM
To: LazyDBA Discussion
Subject: create new data file

Can someone provide me with an example on creating a new data file? My Jedi skills are feeble and I could use the help.

Thanks

Mark Philpott



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree to these terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page