| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: help dynamically adding a 'datafile' to a script
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
> -----------------------------------------------------------------
>
-- 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 - 14:05:36 CST
 |
 |