I\'m trying to create a view as such: CREATE MATERIALIZED ReasonableSizedView TABLESPACE MyMediumTS AS select COUNT(something) AS allsomethings,
maybe one of you can help me with this DB2 z/OS thingy. I edited foreign key on a table that was already populated. Due to integrity reasons (I guess) the tablespace was placed in CHECK PENDING and I
When I try to reorganize a tablespace with OEM 10g, I get an error in the 3rd step (option开发者_如何转开发s) saying : Invalid value for sort area size. The minimum value is 96 KB. My SGA management i
HI In TOAD when I write SELECT * FROM EMPLOYEES I get error \"table or view does not exist\". But when I write
I\'ve got a lot of tables in a tablespace, nearly 100. I have to grant Select, Insert, Update privileges on all those tables to a user. Is it possible? When I write:
I have a dump file which includes two tables. Now I need to import t开发者_高级运维his dump file. I was instructed to create two tablespaces beforehands.Now how do I import this dump file to these tab
I\'m working on a web application where I need to warn the user that they\'re running out of space in the given db user\'s tablespace.
I want to know How to grant user access to additional tablespaces in Oracle? , because I have 开发者_如何学编程created two additional tablespaces, one for data and the other for indexes, like this dis
I\'m trying to create a tablespace in postgres, but I\'m getting ownership problems. The command I\'m using is:
I\'ve created a new tablespace called indexes, and I\'m trying to remove the old tablespace indexes_old, which used to contain some tables and indexes.When I try to drop the tablespace, I get: