SELECT USERNAME, DEFAULT_TABLESPACE
FROM DBA_USERS
WHERE USERNAME = 'SJB';
SELECT TABLE_NAME, TABLESPACE_NAME
FROM DBA_TABLES
WHERE OWNER = 'SJB' order by TABLE_NAME;
SELECT TABLESPACE_NAME, STATUS FROM DBA_TABLESPACES;
CREATE TABLESPACE SJB DATAFILE
SIZE 10M AUTOEXTEND ON NEXT 2M MAXSIZE UNLIMITED
LOGGING
DEFAULT
NO INMEMORY
ONLINE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
ALTER TABLE ESTADO_EVENTO_CORTO MOVE TABLESPACE SJB;
ALTER USER SJB DEFAULT TABLESPACE SJB;
SELECT TABLESPACE_NAME, FILE_NAME
FROM DBA_DATA_FILES;
GRANT "CONNECT" TO "SJB";
GRANT "RESOURCE" TO "SJB";
ALTER USER SJB IDENTIFIED BY sigesa2015;
ALTER USER SJB quota unlimited on SJB;