Have you tried: create tablespace myTablespace datafile '&cPath.mytablespace.dbf' size = 5m; The dot ends a SQL*Plus substitution variable name in places where it = isn't clear where the name of the variable ends and the next word = begins. The dot is part of the name and will be gone after = substitution. -----Original Message----- From: ryan.gaffuri@xxxxxxx [mailto:ryan.gaffuri@xxxxxxx] Sent: Friday, February 20, 2004 12:30 PM To: oracle-l@xxxxxxxxxxxxx Subject: help dynamically adding a 'datafile' to a script I am trying to do the following and I cant get it to take(I would prefer = not to use dynamic sql and write my create tablespace scripts to a = second file). Prompt Please enter a datafile path Accept cPath create tablespace myTablespace datafile '&cPath ||mytablespace.dbf' size = 5m; I've tried lots of methods including bind variables and appending before = the create tablespace statement. Any way to do this?=20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------