All Questions
Tagged with ctas tablespaces
1 question
-1
votes
1
answer
595
views
ORA-01536: Out of space error when doing CTAS
I have two schemas A and B. I'm trying to copy over table B.users to A. I've followed these steps:
Run in schema B:
GRANT ALL ON users TO A;
Run in schema A:
CREATE TABLE users AS (SELECT * FROM ...