The concatenation character for SQL*Plus is the period. SQL> accept path C:\ SQL> create tablespace x datafile '&path.my_data_file.dbf' size 1M ; ancien 1 : create tablespace x datafile '&path.my_data_file.dbf' size 1M nouveau 1 : create tablespace x datafile 'C:\my_data_file.dbf' size 1M Espace de tables (TABLESPACE) créé. The concatenation character can be changed with the SQL*Plus command SET CONCAT > -----Original Message----- > Mladen Gogala > > create tablespace &&myTablespace datafile > '''&cPath'||'/&&mytablespace.dbf''' size 5m; > > With all due respect, automated creation of tablespaces is a > very bad idea. Very > bad idea indeed. There should be a guy, with a job title > like "DBA" who creates > tablespaces as they're needed. They usually have targets > painted on their backs, so > they're easy to recognize. Ask him to create tablespace, and > if you need so many > tablespaces that it makes sense to automate the creation, > then there is something > rotten in the state of Denmark and it ain't BARF. > > > On 02/20/2004 12:30:08 PM, ryan.gaffuri@xxxxxxx wrote: > > 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? ---------------------------------------------------------------- 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 -----------------------------------------------------------------