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
SYS_UNDOTS         LMT

SQL>

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;

BANNER
——————————————————————————–
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
PL/SQL Release 11.1.0.6.0 – Production
CORE 11.1.0.6.0 Production
TNS for 32-bit Windows: Version 11.1.0.6.0 – Production
NLSRTL Version 11.1.0.6.0 – 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:

WordPress.com Logo

You are commenting using your WordPress.com 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

Blog at WordPress.com.

%d bloggers like this: