tablespace_开发者

Tablespaces used to create a materialized view?

I\'m trying to create a view as such: CREATE MATERIALIZED ReasonableSizedView TABLESPACE MyMediumTS AS select COUNT(something) AS allsomethings,[详细]

2023-04-05 00:35 分类：问答

How do I remove CHECK PENDING state from a DB2 Tablespace on z/OS?

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[详细]

2023-03-31 13:46 分类：问答

Sort Area Size (KB) - Invalid value for sort area size. The minimum value is: 96 KB

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[详细]

2023-03-10 08:34 分类：问答

Select Query without Tablespace reference

HI In TOAD when I write SELECT * FROM EMPLOYEES I get error \"table or view does not exist\". But when I write[详细]

2023-03-10 03:47 分类：问答

Grant Select, Insert, Update to a Tablespace

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:[详细]

2023-03-10 02:38 分类：问答

PL/SQL developer import dump

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[详细]

2023-03-08 18:32 分类：问答

How to get available space in tablespace for a user (Oracle)

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.[详细]

2023-03-05 23:45 分类：问答

How to grant user access to additional tablespaces in Oracle?

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[详细]

2023-02-24 00:47 分类：问答

Creating a tablespace in postgresql

I\'m trying to create a tablespace in postgres, but I\'m getting ownership problems. The command I\'m using is:[详细]

2023-02-15 14:31 分类：问答

How can I tell what is in a Postgresql tablespace?

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:[详细]

2023-02-10 04:05 分类：问答