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_at_cox.net 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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Feb 20 2004 - 15:39:05 CST
