The following statement re-creates library library_name, using an explicit path: CREATE OR REPLACE LIBRARY library_name IS '/path/directory';