Unlock user account
ALTER USER abcd IDENTIFIED BY abcd1234 ACCOUNT UNLOCK;...
Tablespace – Adicionar espaço
ALTER TABLESPACE USERS ADD DATAFILE 'C:\APP\ORADATA\ORCL\USERS02.DBF' SIZE 1024K AUTOEXTEND ON NEXT 1024K MAXSIZE UNLIMITED;...
Listar Arquivos Tablespace
select name from v$controlfileunion allselect name from v$tempfileunion allselect name from v$dbfileunion allselect member from v$logfile...
Banco de Dados (restaurando / restoring)
RESTORE DATABASE [database_name] WITH RECOVERY Referencia: https://www.mssqltips.com/sqlservertip/5460/sql-server-database-stuck-in-restoring-state/...
Android – Manter teclado virtual ao conectar leitor de código de barras
...
Android – Teclado com código de barras
App de teclado para Android com recurso de leitura de código de barras....
Mover tabelas e índices para outra tablespace
Índices select ‘alter index ‘|| owner ||’.’||segment_name||’ rebuild tablespace USERS;’from dba_segmentswhere 0=0and owner = ‘xxxx’and tablespace_name<>’USERS’and segment_type=’INDEX’; Tabelas select ‘alter table ‘||owner ||’.’||segment_name||’ move tablespace USERS;’from dba_segmentswhere owner=’xxxxx’and tablespace_name<>’USERS’and segment_type=’TABLE’;...
IMP/EXP
Backupexp user/pass@server file=’c:\folder\file.dmp’ owner=XXXX Restoreimp user/pass@server file=’c:\folder\file.dmp’ fromuser=XXXX touser=YYYY...
SQLServer liberar memoria/cache
DBCC DROPCLEANBUFFERSDBCC FREEPROCCACHE...
lock
SELECT session_id, wait_duration_ms, wait_type, blocking_session_id FROM sys.dm_os_waiting_tasks WHERE blocking_session_id <> 0...