What do you want to save?
Add Code snippet
New code examples
-
Python 2021-10-24 08:43:05
django db_table example
# All Django Class Meta Attributes abstract app_label base_manager_name db_table Table names db_tablespace default_manager_name default_related_name get_latest_by managed order_with_respect_to ordering permissions default_permissions proxy required_db_fea... Add solution -
SQL 2021-10-11 01:26:08
oracle sql create user
-- Oracle - User / schema creation CREATE USER MY_USER IDENTIFIED BY "MyPassword" DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; GRANT CONNECT TO MY_USER; -- To connect to DB GRANT RESOURCE TO MY_USE... Add solution -
SQL 2021-10-10 02:34:09
oracle create index
CREATE INDEX my_index_name ON my_table (colName) TABLESPACE my_tablespace; -- Default tablespace is USER CREATE INDEX my_index_name ON my_table (trunc(myDateCol)); -- With parallelism CREATE INDEX my_index_name ON my_table (colName) PARALLEL 8; Add solution -
SQL 2021-10-06 18:21:03
oracle find unusable indexes
-- Indexes: SELECT OWNER, INDEX_NAME, TABLESPACE_NAME FROM DBA_INDEXES WHERE STATUS = 'UNUSABLE'; -- Index partitions: SELECT INDEX_OWNER, INDEX_NAME, PARTITION_NAME, TABLESPACE_NAME FROM DBA_IND_PARTITIONS WHERE STATUS = 'UNUSABLE'; -- Index subpartition... Add solution -
SQL 2021-10-04 17:21:04
oracle add datafile to tablespace
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-10-03 14:46:02
ORA-01950
ALTER USER <user> QUOTA UNLIMITED ON <tablespace name>; Add solution -
SQL 2021-10-03 09:50:03
oracle datafile max size 32gb
SELECT * FROM DBA_DATA_FILES; 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.dbf' SIZE 10G AUTOEXTEND ON NEXT 1G MAXSIZE 32G; ... Add solution -
SQL 2021-09-29 18:37:02
alter tablespace add datafile autoextend
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
Best helpers
Ranking is empty