Re: Tablespace storage directory

Hello,

It appears to be, you are using DBCA to create the database. When i use DBCA i create a template first. Almost at the end of creation of a template (its a screen where you can see control files, data files and redo log files.. remember ??), you have an option to change the location of the data file. W/ this you can create the new template. By the way This template can be located under $ORACLE_HOME/ass*/dbca/templates as a ".dbt" file. This file can be edited through VI editor as well, if you wanted to change the file locations manually.

So next time when you create a database using your own template (which was created previously), you can select "USE DATABASE FILE LOCATIONS FROM TEMPLATE". Hope this helps !!
Madhu

mixint wrote:
> Hi,
> I created a database on Oracle 10.2.0 with Configuration Assistant and
> pointed to my directory to store there db files. (In the section
> "Specify locations for the Database files to be created" I chose "Use
> Common Location for All Database Files").
> Assistant created there some basic dbf (tablespace) files. However,
> when I create a new tablespace from external client the corresponding
> dbf file is stored in an ORACLE_HOME subdirectory, not in the directory
> I entered earlier.
> So my question is how to make Oracle create tablespace files in my
> directory?
>
> greetings, Pawel
Received on Tue Sep 05 2006 - 11:34:09 CDT