oracle-dbops/create_dirs.sh at main · billthan/oracle-dbops · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
#!/bin/bash

# List of directories to be created
directories=(
  "/aux/dbops/tables"
  "/aux/dbops/views"
  "/aux/dbops/packages"
  "/aux/dbops/procedures"
  "/aux/dbops/triggers"
  "/aux/dbops/sequences"
  "/aux/dbops/indexes"
  "/aux/dbops/synonyms"
  "/aux/dbops/mviews"
  "/aux/dbops/types"
  "/aux/dbops/dblinks"
  "/aux/dbops/functions"
  "/aux/dbops/libraries"
  "/aux/dbops/users"
  "/aux/dbops/roles"
  "/aux/dbops/profiles"
  "/aux/dbops/privileges"
  "/aux/dbops/contexts"
  "/aux/dbops/jobs"
  "/aux/dbops/grants"
  "/aux/dbops/roles"
  "/exp1/ddl_dir2"
)

# Loop through the directory list
for dir in "${directories[@]}"; do
  if [ ! -d "$dir" ]; then
    echo "Creating directory: $dir"
    mkdir -p "$dir"
  else
    echo "Directory already exists: $dir"
  fi
done

echo "All directories checked and created if necessary."