- Create user and grant permission
alter session set "_ORACLE_SCRIPT"=true;
create user [username] identified by [password];
grant connect, create session, imp_full_database to [username];
CREATE SMALLFILE TABLESPACE [TABLESPACE_NAME] DATAFILE 'FILEDATA.dbf' SIZE 7G AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
GRANT UNLIMITED TABLESPACE TO [username]; - Create Directory
CREATE DIRECTORY BACKUP_DIR AS '/home/oracle/import';
GRANT read,write on DIRECTORY BACKUP_DIR to [username]; - Import
impdp [username]/[password] DIRECTORY=BACKUP_DIR DUMPFILE=File.dmp FULL=Y LOGFILE=import.log
Tuesday, July 21, 2020
Import DUMP file in Oracle
Subscribe to:
Posts (Atom)
Install and use xorg-server on macOS via Homebrew
The instructions to install and use xorg-server on macOS via Homebrew: Install Homebrew (if you haven't already): /bin/bash -c ...

-
Ref: https://blogs.sap.com/2016/11/25/get-to-know-camels-simple-expression-language-in-hci/ Introduction Simple is a, well, simple express...
-
WebRequest The function sends an HTTP request to a specified server. The function has two versions: 1. Sending simple requests of typ...
-
Important note about OLE automation: OLE automation interface is provided to control AmiBroker from the OUTSIDE process (such as windows ...