How can I create a directory on the file system?

Question

How do you create a physical directory on the OS from within PL/SQL? I looked at the `CREATE OR REPLACE DIRECTORY` command but that doesn't do it. Neither does `UTL_FILE` appear to be capable.

Accepted Answer

In the end I did find an easier solution. Use

```
select os_command.exec('mkdir /home/oracle/mydir') from dual;
```

or simply

```
x := os_command.exec('mkdir /home/oracle/mydir');
```

How can I create a directory on the file system?

Solution

Problem