Prev: How to determine the Oracle session's constraint state?
Next: Simple update statement (or is it?)
From: Norbert Pürringer on 8 Feb 2010 12:35
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
From: Mark D Powell on 8 Feb 2010 12:42
On Feb 8, 12:35 pm, Norbert Pürringer <thalio...(a)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 --
 | 
Pages: 1
Prev: How to determine the Oracle session's constraint state?
Next: Simple update statement (or is it?)