Durante a criação de uma tabela, foi reportado o seguinte erro: “ORA-01950: no privileges on tablespace ‘BKTTBS'”.
SQL> SQL> 2 3 4 CREATE TABLE SYSTECHDATA.BASKET_EXAMPLE ( * ERROR at line 1: ORA-01950: no privileges on tablespace 'BKTTBS'
Este erro acontece devido ao fato de o usuário que estar criando a tabela não ter espaço de quota suficiente de criação na tablespace onde a tabela irá residir. Para solucionar este problema, você pode conceder espaço ilimitado de criação para o usuário na tablespace, como no exemplo abaixo:
SQL> ALTER USER SYSTECHDATA quota unlimited on BKTTBS; User altered.
ou também você pode definir o espaço de quota para o usuário na tablespace, como por exemplo 10M:
SQL> ALTER USER SYSTECHDATA quota 10m on BKTTBS; User altered.
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.
Obrigado pela dica
de nada ! 😀