Before 10g default tablespace was SYSTEM which will create issues as users data will get stored in this.
To prevent this,default permanent tablespace concept came into existence in 10g.It can be set at database creation or later.
SQL>ALTER DATABASE DEFAULT TABLESPACE users;
The current settings for the default tablespaces can be viewed using the following query:
SELECT *
FROM database_properties
WHERE property_name like '%TABLESPACE';
PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
------------------------------ ------------------------------ --------------------------------------
DEFAULT_TEMP_TABLESPACE TEMP Name of default temporary tablespace
DEFAULT_PERMANENT_TABLESPACE USERS Name of default permanent tablespace
HTH:-)
1 comment:
zhengjx20160428
louis vuitton handbags
air jordan shoes
concord 11
michael kors handbags
toms
beats by dr dre
tods outlet store
nhl jerseys
oakley vault
louis vuitton outlet online
adidas originals
coach outlet
christian louboutin shoes
retro 11
ralph lauren polo
michael kors outlet
christian louboutin shoes
ladies cartier watches
coach factory outlet
louis vuitton
ralph lauren
jordan retro 13
vans sneakers
louis vuitton handbags
coach outlet
air jordan 4
air jordan shoes
ralph lauren home
louis vuitton purses
nike running shoes for men
gucci belts
coach outlet online
ray ban sunglasses outlet
nike uk
pandora jewelry
true religion jeans
louis vuitton outlet
michael kors outlet
celine bags
michael kors outlet clearance
Post a Comment