logs archiveIRC Archive / Freenode / #oracle / 2015 / August / 10 / 1
sigdk
I am trying to install oracle templates for RAC-11. It hangs during deployment. Does anyone have experience with the process ?
mator
is it possible for an oracle user to use different tablespace ? like user has been created with "users" default tablespace, and there's "example" tablespace. So is it possible for user to use "example" tablespace?
hello
dbfuse
yes
alter user <username> default tablespace example;
mator
dbfuse, but is it possible to use 2 tablespace in the same time? like keep "users" tbs default and try somehow to use "example" one?
thanks anyway
dbfuse
mator, sure
mator, alter user <username> quota unlimited on example;
mator, create table user.table (blah) tablespace example;
mator
ahh thanks
thats it
dbfuse
nuances on oracle :-)
mator
i just completely forgot something i never knew ;)
dbfuse
Many other db's dont even have tablespaces concept. put whatever where ever you want.
such as postgresql, mysql,mongo,cassandra etc.
12c takes that concept a little further
create table <pluggabledb>.<user>.<table>
         

mator
just installed 12c
installed without plug-able db, since i new to it, and don't know what is it
probably not this time with pdb, but thanks anyway
dbfuse
12c you will have to go with pdb , should not put tables in cdb
you are wise did not choose cdb :-)
MatheusOl
PostgreSQL does have tablespaces
But way simpler
dbfuse
Agreed thanks, tablespaces are dependent on the space of the OS itself.
next »