From the Oracle 8i SQL*Plus Guide - Example 3-12 on pages 3-22 and 3-23, last example on the page: 3-22 SQL*Plus User's Guide and Reference If you wish to append characters immediately after a substitution = variable, use a period to separate the variable from the character. For example: SQL> SELECT * FROM EMP WHERE EMPNO=3D'&X.01'; Enter value for X: 123 is interpreted as SQL> SELECT * FROM EMP WHERE EMPNO=3D'12301'; Page 3-25 - under System Variables SET CONCAT Defines the character that separates the name of a = substitution variable or parameter from characters that immediately follow the variable or parameter-by default the period (.). -----Original Message----- From: Ryan [mailto:ryan.gaffuri@xxxxxxx] Sent: Friday, February 20, 2004 5:05 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: help dynamically adding a 'datafile' to a script where in the sqlplus docs is stuff on '.' ? I scoured them and didn't = see it. ----- Original Message -----=20 From: "John Flack" <JohnF@xxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Friday, February 20, 2004 2:31 PM Subject: RE: help dynamically adding a 'datafile' to a script > Have you tried: > create tablespace myTablespace datafile '&cPath.mytablespace.dbf' size = =3D > 5m; > > The dot ends a SQL*Plus substitution variable name in places where it = =3D > isn't clear where the name of the variable ends and the next word =3D > begins. The dot is part of the name and will be gone after =3D > 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 =3D > not to use dynamic sql and write my create tablespace scripts to a =3D > second file). > > Prompt Please enter a datafile path > Accept cPath > > create tablespace myTablespace datafile '&cPath ||mytablespace.dbf' = size =3D > 5m; > > I've tried lots of methods including bind variables and appending = before =3D > the create tablespace statement. Any way to do this?=3D20 > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------