What do you want to save?
Add Code snippet
New code examples
-
Other 2022-03-17 00:45:17
password authentication failed for user postgres pgadmin
happened with me as well, when I started pgadmin3 for the first time, i was expecting it to ask for the password which I provided during but it didnt ask and then didnt display any servers. anyways, you can create a server yourself, if your server is on t... Add solution -
SQL 2022-02-26 07:00:02
query to find table size in oracle 12c
SELECT e.OWNER, e.SEGMENT_NAME, e.TABLESPACE_NAME, sum(e.bytes) / 1048576 AS Megs FROM dba_extents e WHERE e.OWNER = 'SCHEME_NAME' AND e.TABLESPACE_NAME = 'TBS_NAME' AND e.SEGMENT_NAME IN ('TABLE_NAME') GROUP BY e.OWNER, e.SEGMENT_NAME, e.TABLESPACE... Add solution -
SQL 2022-02-01 08:55:44
Tablespace ORACLE
SELECT e.OWNER, e.SEGMENT_NAME, e.TABLESPACE_NAME, sum(e.bytes) / 1048576 AS Megs FROM dba_extents e WHERE e.OWNER = 'MY_USER' AND e.TABLESPACE_NAME = 'MY_TABLESPACE' GROUP BY e.OWNER, e.SEGMENT_NAME, e.TABLESPACE_NAME ORDER BY e.TABLESPACE_NAME, e.SE... Add solution -
SQL 2021-11-12 18:09:15
oracle alter tablespace add datafile autoextend max size
SELECT * FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'my_tbs' ORDER BY FILE_NAME; ALTER TABLESPACE my_tbs ADD DATAFILE '/path/to/my_file.dbf' SIZE 100M AUTOEXTEND OFF; -- Autoextend with max size: ALTER TABLESPACE my_tbs ADD DATAFILE '/path/to/my_file.... Add solution -
SQL 2021-11-05 22:49:09
rebuild index oracle
-- Indexes: SELECT 'alter index ' || OWNER || '.' || INDEX_NAME || ' rebuild tablespace ' || TABLESPACE_NAME || ';' SQL_TO_REBUILD_INDEX FROM DBA_INDEXES WHERE STATUS = 'UNUSABLE'; -- For unusable indexes -- Indexes partitions: SELECT 'alter index ' ... Add solution
Best helpers
Ranking is empty