발자취

select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';--만료일 검색 alter profile default limit password_life_time unlimited; --만료일 삭제 COMMIT;

Import 방법 DROP TABLESPACE HANMIPT_DATA INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS; DROP TABLESPACE HANMIPT_INDEX INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS; DROP USER hmptwms CASCADE; CREATE TABLESPACE 테이블명 LOGGING DATAFILE 'D:\oradata\orcl\디비명.DBF' SIZE 100M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED; CREATE TABLESPACE 디비명 LOGGING DATAFILE 'D:\oradata\orcl\디비명.DBF' SIZE ..

SELECT V$SESSION.SID ,V$SESSION.SERIAL# ,V$SESSION.USERNAME ,DBA_OBJECTS.OBJECT_NAME ,V$SESSION.SADDR ,V$SESSION.OSUSER ,V$SESSION.PROGRAM FROM V$LOCKED_OBJECT LEFT JOIN DBA_OBJECTS ON V$LOCKED_OBJECT.OBJECT_ID = DBA_OBJECTS.OBJECT_ID LEFT JOIN V$SESSION ON V$LOCKED_OBJECT.SESSION_ID = V$SESSION.SID ORDER BY V$SESSION.SID, DBA_OBJECTS.OBJECT_NAME

D:\app\피시명칭\product\11.2.0\dbhome_1\NETWORK\ADMIN