Link

 https://cloudinary.com/console

apex
http://qaiumer.blogspot.com/2018/05/download-text-file-with-unlimited.html

https://qaiumer.blogspot.com


https://welcometooracle.wordpress.com/2012/10/18/hierarchical/

How do I find the last row inserted?

  select

  *

from

  EMP_LEAVE

where

  rowid =(

    select

       max(rowid)

    from

       EMP_LEAVE);

Backup from Linux oracle database .bat

 cls

@echo off

REM Export Full database with auto filename for dump and log

REM This batch file will create the dump and log files in the same directory as of batch

REM File name syntax --> <SCHEMANAME>_<DD>_<MM>_<YYYY>

REM Auther: Deepu Mohan P, www.deepumohan.com

REM Created:  07-Sep-2009

REM Modified: 30-Sep-2009, 01-Oct-2009

REM Get user credentials

REM set /p schema=ipihr: 

REM set /p pwd=i: 

REM set /p sid=Xpharma: 

set  schema=%ipihr

set  pwd=%i 

set  sid=%Xpharma

ECHO.

ECHO =======================================================

ECHO Starting Oracle Database Backup

ECHO =======================================================

REM Following block is for getting the year, month and day

REM ======================================================

   FOR /f "tokens=2-4 skip=1 delims=(-)" %%G IN ('echo.^|date') DO (

      FOR /f "tokens=2 delims= " %%A IN ('date /t') DO (

         SET v_first=%%G

         SET v_second=%%H

         SET v_third=%%I

         SET v_all=%%A

      )

   )

      SET %v_first%=%v_all:~0,2%

      SET %v_second%=%v_all:~3,2%

      SET %v_third%=%v_all:~6,4%

REM =====================================================

REM exp %schema%/%pwd%@%sid% FILE=E:\JNP_%user%_%dd%_%mm%_%yy%.dmp log=%user%_%dd%_%mm%_%yy%.log

REM compress=N rows=Y grants=Y buffer=500000 FULL=Y statistics=NONE

E:\app\Administrator\product\12.2.0\dbhome_1\bin\exp ipihr/i@pharma FILE=E:\HR_Backup\IPIHR_%user%_%dd%_%mm%_%yy%.dmp log=E:\HR_Backup\IPIHR%user%_%dd%_%mm%_%yy%.log

compress=N rows=Y grants=Y buffer=500000 FULL=Y statistics=NONE

ECHO =======================================================

ECHO Completed Database Backup

ECHO =======================================================

--pause

Start Lsnrctl & weblogic in CentOS Linux

Database :

1. conn sys as sysdba

when idl instance

startup --database

2. -- New terminal

su -l oracle

lsnrctl

start

3. Again Connect Sys 

alter system register;

 4. --start weblogic

root 

cd /u01/app/oracle/config/domains/lr/bin/

./startNodeManager.sh

./startWebLogic.sh

Find oracle locked objects in oracle database

 select object_name obj

 ,oracle_username||' ('||s.status||')' oruser

 ,os_user_name osuser

 ,l.process unix

 ,''''||s.sid||','||s.serial#||'''' ss

 ,r.name rs

 ,to_char(s.logon_time,'yyyy/mm/dd hh24:mi:ss') time

 from v$locked_object l

 ,dba_objects o

 ,v$session s

 ,v$transaction t

 ,v$rollname r

 where l.object_id = o.object_id

 and s.sid=l.session_id

 and s.taddr=t.addr

 and t.xidusn=r.usn

 order by ss, obj,osuser,  obj

alter system  kill session  '6,1509'