This content has been marked as final. Show 3 replies
Not in a GUI manner that I know of - SQL developer is a development tool not a database admin tool, you can obviously use it to run the SQL command to create one. If you have Enterprise Manager you can use that...alternatively learn the command line:
You can look at dba_data_files for data file names:
Edited by: PaulTill2508 on May 11, 2010 12:21 PM
select file_name from dba_data_files where tablespace_name = 'SYSTEM';
user13100082 wrote:Yes, it is possible in version 3.0
How is it possible to create a simple tablespace ucing Oracle SQL
Developer based on Oracle 11g?
Click on View/DBA - DBA navigator window will appear.
In the DBA window add a new connection, connect, then under storage option righ click on tablespaces and choose New tablespace.