Oracle TIPS のバックアップ(No.6)

バックアップ一覧
差分を表示
現在との差分を表示
ソースを表示
Oracle TIPS へ行く。
- 1 (2007-08-18 (土) 01:18:10)
- 2 (2008-07-08 (火) 02:48:30)
- 3 (2017-03-23 (木) 16:11:02)
- 4 (2017-03-24 (金) 11:28:40)
- 5 (2017-04-10 (月) 18:43:07)
- 6 (2017-04-11 (火) 08:59:03)
- 7 (2017-05-15 (月) 11:40:22)
- 8 (2017-07-11 (火) 09:12:00)

ORA-28009: connection to sys should be as sysdba or sysoper

sqlplus /nolog

connect sys as sysdba

sqlplus "sys/hogepass@hogetns as sysdba"

↑

SQL> select sid,serial#,status,osuser,username,machine from v$session
  2     where username='hoge';
SID             SERIAL#
---------- ----------
9                  87

↑

select * from v$license;

↑

select * from v$open_cursor;

↑

CREATE OR REPLACE TRIGGER LOG_LOGON
AFTER LOGON ON DATABASE
BEGIN
INSERT INTO TBL_TEST VALUES(1,1);
END;

↑

select * from dba_data_files;

↑

alter tablespace testspace OFFLINE;



alter tablespace testspace ONLINE;

↑

C:\oracle\ora81\sqlplus\admin\glogin.sql

--orignal
set lines 160;
set pages  60;

--set heading off;
select * from v$version;

select * from global_name;
select host_name,instance_name from v$instance;
set time on;
--set heading on;
--set pause on;

↑

oraadim -DELETE -SID sid

OracleServicesid?

oracle_home\oradata\sid
oracle_home\admin\sid

OracleDatabaseConfiguration?

↑

PLAN_TABLE

Oracle9i

\oracle\ora92\rdbms\admin\utlxplan.sql

Oracle10g

\oracle\product\10.1.0\Db_1\RDBMS\ADMIN\utlxplan.sql

↑

SELECT  TO_CHAR(SES.LOGON_TIME, 'HH24:MI:SS') AS LOGON_TIME, 
       SES.USERNAME                          AS LOGON_USER, 
       SES.SID                               AS SID, 
       SES.SERIAL#                           AS SERIAL, 
       SES.STATUS                            AS STATUS, 
       SQL.SQL_TEXT                          AS SQL_TEXT 
FROM    V$SESSION SES, 
       V$SQLAREA SQL 
WHERE   SES.SQL_ADDRESS    = SQL.ADDRESS(+) 
   AND SES.SQL_HASH_VALUE = SQL.HASH_VALUE 
   AND SES.TYPE           = 'USER' 
ORDER BY SES.LOGON_TIME;

↑

update test1 a1
set (a1.c,a1.d) = (
select ba.c,ba.d
from test2 ba
where a1.a=ba.a
and  a1.b=ba.b
)
where exists(
select * 
from test2 ba
where a1.a=ba.a
and  a1.b=ba.b
)

↑

Enterprise Manager

http://localhost:1158/em

↑

select * from user_recyclebin;

flashback table tablename to before drop;

PURGE RECYCLEBIN

PURGE TABLE tablename

↑

Caused by: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column

http://www.atmarkit.co.jp/bbs/phpBB/viewtopic.php?topic=31968&forum=12&6

↑

DECLARE
debug BINARY_INTEGER;
BEGIN
DBMS_MVIEW.REFRESH_ALL_MVIEWS(debug,'?','',FALSE,FALSE);
END;
/

↑

http://mattari-oboe.blogspot.jp/2014/10/oracle-listenerlog4gb.html

↑

alter tablespace HOGE OFFLINE;

cd /u01/app/oracle/oradata/orcl12/pdborcl
cp -pi HOGE.DBF /home/oracle/oracle/
rm -i HOGE.DBF

alter tablespace HOGE rename datafile '/u01/app/oracle/oradata/orcl12/pdborcl/HOGE.DBF' to '/home/oracle/oracle/HOGE.DBF';
alter tablespace HOGE ONLINE;

http://qiita.com/nishimry/items/3d57e681c8f8dbdd6caa

↑

#comment