Re: Creating Tablespace in sql developer (Oracle 11g)
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Mon, 8 Feb 2010 09:42:40 -0800 (PST)
Message-ID: <e8d0574f-7084-4163-b270-568ddd947b75_at_z41g2000yqz.googlegroups.com>
On Feb 8, 12:35 pm, Norbert Pürringer <thalio..._at_graffiti.net> wrote:
> Hello,
>
> how is it possible to create a simple tablespace ucing Oracle SQL
> Developer based on Oracle 11g?
>
> I don't want to execute an sql statement knowing the syntax.
>
> And how do I find out the dbf file on which a tablespace is based on?
>
> Regards,
> Norbert
Date: Mon, 8 Feb 2010 09:42:40 -0800 (PST)
Message-ID: <e8d0574f-7084-4163-b270-568ddd947b75_at_z41g2000yqz.googlegroups.com>
On Feb 8, 12:35 pm, Norbert Pürringer <thalio..._at_graffiti.net> wrote:
> Hello,
>
> how is it possible to create a simple tablespace ucing Oracle SQL
> Developer based on Oracle 11g?
>
> I don't want to execute an sql statement knowing the syntax.
>
> And how do I find out the dbf file on which a tablespace is based on?
>
> Regards,
> Norbert
I do not use SQL Developer very much but I think it is more code development orientated rather than DB management orientated.
You can see the DBA_DATA_FILES view, if authorized, to see what files are assigned to a tablespace, size, etc ...
You can use the dbms_metadata package to generate the DDL for a tablespace.
HTH -- Mark D Powell -- Received on Mon Feb 08 2010 - 11:42:40 CST