Re: Oracle new tablespace

Yannick Effinger wrote:
> Hello,
>
> I'd like to create a new tablespace and to access it through a certain
> host and port. I know that tnsnames.ora and listener.ora are the lists of
> all the "tablespaces" available with a different port for each of them.
> But I don't know how to assign a specific port to my tablespace. All I was
> able to do was to define the path of the data files.
> Can anybody guide me or drop a link to a website with some info
> (preferably in DBA studio)?

As gazzag says ... you are confusing tablespaces with databases. I'd suggest you go to http://tahiti.oracle.com and read the concept docs.

Assuming you were late and it was tired ... just edit the port number in the .ora files you named.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)