Alessandro Guimarães – Oracle Blog

September 3, 2009

Create Database | TS SYSTEM como DMT

Filed under: Uncategorized — Tags: — agleite @ 8:39 pm

A partir do Oracle 10g posso criar um banco apenas com :

SQL> create database;

Database created.

Agora, como fica o gerenciamento das tablespaces : Local ou Dictionary ?

SQL> select name, decode(bitmapped, 0, ‘DMT’, ‘LMT’)
2 from ts$
3 order by name;

NAME                         DEC
—————             —————
SYSAUX                    LMT
SYSTEM                 DMT


Como podes ver o comando “create database” cria a system como DMT por default

Fácil também poderia significar melhores práticas

Pra surpresa a versao é :

SQL> select * from v$version;

Oracle Database 11g Enterprise Edition Release – Production
PL/SQL Release – Production
CORE Production
TNS for 32-bit Windows: Version – Production
NLSRTL Version – Production


Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at

%d bloggers like this: