What do you want to save?
Add Code snippet
New code examples
-
Other 2022-01-22 19:21:34
To ignore duplicate keys during 'copy from' in postgresql
create temp table tmp_table on commit drop as select * from brand with no data; copy tmp_table (name,slug) from '/var/lib/postgresql/data/Brands.csv' DELIMITER ',' csv header; insert into brand select distinct on (slug) * from tmp_table; 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-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 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 -
SQL 2021-09-25 00:43:03
how to get data from 2 database
-- Fetch data from the other database server SELECT * INTO #myTempTable FROM OPENQUERY([DB2], 'SELECT * FROM [MyDatabaseOnDB2].[dbo].[MyOtherTable]') -- Now I can join my temp table to see the data SELECT * FROM [MyDatabaseOnDB1].[dbo].[MyTable] tab1 ... Add solution
Best helpers
Wayno
+5
IQAndreas
+5
AlecPerkey
+5
Seria Yin
+5
T-rex
+5
Wilber82
+5
Sharma Pocso
+5
TJG
+5
JSanchez
+5