Expdp pdb as sysdba oracle. Asked: March 18, 2020 - 6:09 pm UTC.


  1. Home
    1. Expdp pdb as sysdba oracle 0. log compression=all encryption=all . Common Troubleshooting Permission Issues: If you are using Linux/macOS, make sure your OS user is part of Oracle’s administrative group (for instance dba), if any. su - oracle -c " Hi, on 10g R2 I can connect to DB like this : export ORACLE_SID=MYDB sqlplus / as sysdba How can I use this method to export from MYDB ? expdp sys / as sysdba tables=table1 dumpfile=myfiel Thank y Just remember, whenever using Oracle utilities that need authentication like expdp AS SYSDBA, please take the credential string as a whole to pass it into the database. ORACLE-BASE - Data Pump (expdp, impdp) Enhancements in Oracle Database 19c. 2) and I now want to import a dump we made locally from our server using expdp. And today, I’d like to give you a bit more insights and warn you about the Pitfalls: Connect to a PDB directly with ORACLE_PDB_SID. DMP与PDB的导出文件进行大小比对发现仅导出了根容器 所以可以得出CDB的导出不包含PDB ORACLE-BASE - Data Pump (expdp, impdp) Enhancements in Oracle Database 18c Articles Oracle 8i Oracle 9i Oracle 10g Oracle 11g Oracle 12c Oracle 13c Oracle 18c Oracle 19c Oracle 21c Oracle 23ai Oracle 24ai Miscellaneous PL/SQL SQL This article shows how to migrate an on-premises source database, tablespace, schema, or table to an Oracle Database Cloud Service database deployment using the conventional export and import functionality of the Data Pump feature of Oracle Database. xml' sqlplus /@db as sysdba is not possible from a remote machine - this would open the database to entire world where everybody could connect with SYSDBA privileges without any password! sqlplus /@db as sysdba is allowed only from local machine because there you are already authenticated (typically) as OS-User "oracle". A 12c multitenant database introduces the new concept of local users and common users. Commented Aug 3, 2016 at 13:23. dmp logfile=EXP. 2), you can change the DBID on the PDBs by using the new DBNEWID PDB parameter. $ lsnrctl export ORACLE_PDB_SID=pdb2 sqlplus / as sysdba show con_name However, if cdb1 does not have pdb2, then you will be connected to CDB$ROOT . run grant pdb_dba to test;. Assuming your cloud instance and PDB are created: • export the on-premise database using expdp, how to export PDB tables with SYS user with out password on DB 19. ORACLE_SID not defined: Make sure you have defined the variable environment ORACLE_SID for the instance of the database. My user/service account other than SYS, however, you should be extremely careful. SAMPLE Percentage of data to be exported. My database name/CDB name - TESTMy pdb name - pdb1sqlplus tom/tom@pdb1ERROR:ORA-01017: invalid username/password; logon denied Here's output fro Connect to PDB as SYSDBA by ORACLE_PDB_SID - Free download as PDF File (. , therefore its easy to check the diagnise/elapsed time taken for execution. Environment:- PDB Name: -oradbwrpdb1. 0 - Production on Wed May 3 17:19:02 Username: / as sysdba Connected to: Oracle Database 12c Enterprise Edition Release 12. The default password usually is oracle. How to export the dumpfile by using the LOGTIME parameter using expdp in Oracle database 19C Brief: – This parameter LOGTIME give us the timestamp for each and every export operation during expdp. 1) When I try to connect pdb user user1@mypdb1 using sysdba and I fire user_tables then I do not get all my tables. how to export PDB tables with SYS user with out password on DB 19. Below is an example command DB version: 19c OS : RHEL 7. USERID="/ as sysdba" DUMPFILE=expdp. Tweet. Can't login as sysdba in how to export PDB tables with SYS user with out password on DB 19. We cannot run expdp directly on physical [] I have set up an Oracle database (11. Let’s say we have a very big table, and for testing purpose, we need only a subset of data i. Asked: March 18, 2020 - 6:09 pm UTC. $ . In Oracle 21c Data Pump can resume failed transportable tablespace jobs at, or near, the point of failure. To export data from your 21c XE database: As the root user, create a /opt/dump directory on the local file system for the DUMP_DIR directory object. ”EMP_TAB” WHERE created > sysdate -40; Oracle sys user database connection with ORACLE_SID is not working. DEMO: Export dump of a table from emp_tab WHERE created > sysdate -40 . Step:-1 First we need to create PDB service PDB service and registered in the How to export Schema from Pluggable (PDB) using expdp utility in Oracle 18c. Viewed 1000+ times impdp will create the user if it's not present yet, so you don't have to worry about it unless that's not what you want. expdp \'/ as sysdba\' DIRECTORY=DATA_PUMP_DIR DUMPFILE=example. (There are the [IMPORT|EXPORT]_FULL_DATABASE privileges specifically for A few weeks ago I learned about the ability to connect directly into a PDB by using the environment variable ORACLE_PDB_SID. I have created a par file as below:directory=EXPDP_REFRESHdumpfile=CLIENT_TABLE. expdp user/pwd attach= 3. 0 - 64bit Production Unable to connect to PDB ORA-01017: invalid username/password; logon denied Dear Tom,I'm trying to connect my pdb - pdb1, using tnsnames. 2--Using SQL Developer, open a database connection to the SYS user AS SYSDBA. Use the command CREATE PLUGGABLE DATABASE to plug the PDB from the 18c XE CDB to the 21c XE CDB. Thanks for the question, Orna. This article shows simple use cases why DBAs may want to create common users – in contrast to the common users that are Attach and deattach the expdp/impdp datapump job EXPDP and IMPDP is used to take the logical backup of complete Database and schema. SCHEMAS: To be backed up schema or to be PDB user connecting as sysdba I have a query regarding username and it's roles. "SYS_EXPORT_SCHEMA_01": sys/*****@pdb1 AS SYSDBA directory=TEST_DIR Home » Articles » 12c » Here. COMPRESSION Reduce the size of a dump file. To do this I have to switch user from 'root' to 'oracle'. Connect to the Data Pump job. That's it. . export ORACLE_PDB_SID=pdb sqlplus / as sysdba SQL*Plus: Release 21. 5. All data pump actions are performed by database DBMS_SCHEDULER jobs. Version: 19. Do not run impdb or expdp as sysdba, only do that if Oracle support requests it in specific circumstances. The Data Pump Export utility is started using the expdp command. Oracle version is 12. As explained in Mike Dietrich’s Blog, In my case I imported a 12c Database into a PDB . DMPschemas=TESTCONTENT=ALLNOLOGFILE=Yinclude=table:'in In Oracle 21c transportable tablespace exports (expdp) and imports (impdp) can now use the PARALLEL parameter to parallelize the operations. lst The variable in question is ORACLE_PDB_SID. While this has been answered already. 9 Using expdp, I want to export only DB Links in my PDB. dmp logfile=expdp_dblinks. Share. 4 TABLES=CRM. What is the trick? For example this code that works in ksh for svrmgrl#! /usr/bin/ksh# list last 5 archive log fi Migrating data using Oracle Data Pump is a three-step process. In the multitenant database, For getting an export dump from the pluggable database, we need a follow a bit different process. Data Pump (expdp, impdp) Interactive Command Mode. Use an ordinary user for that - one that has been granted the dba role for instance. It may be necessary if you are using the pdb_change 2019 at 16:13. Filter can be added on any column depending upon the requirement. 0 I want to connect as sysdba to my pluggable database XEPDB1. Assuming your cloud instance and PDB are created: • export the on-premise database using expdp, In this article we are going to learn how to run expdp jobs in background (nohup) step by step. This method can be used regardless of the endian format and database character set of the on-premises database. The MAX_DATAPUMP_JOBS_PER_PDB initialization parameter was introduced in Oracle 12. --Check running job select owner_name, job_name from dba_datapump_jobs where state='EXECUTING'; 2. When ORACLE_PDB_SID is set, you will NOT connect to What's the common practice to export data from the PDB, ideally without providing a password and as sys? We can simply change the code to expdp In this post we are going to see how to take expdp on pdb database. For example, we double 1--Connecting AS SYSDBA invokes the SYSDBA privilege. pdf), Text File (. Normally a password is required to connect to a PDB, but setting Running sqlplus / as sysdba from Unix script in 9i In Oracle 9i svrmgrl and connect internal are no more. Now moved to Advanced tab. Either by giving the option in the command line, or giving the option when it prompts for the username. Multitenant : Connecting to Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c Release 1 (12. DMPschemas=TESTCONTENT=ALLNOLOGFILE=Yinclude=table:'in Step One: create pdbuser. I have some useful tips for you in an Oracle 11g R1 database. dev is my ORACLE_SID . oracle-database; oracle12c; According to Oracle 12c docs, I cannot create a profile for a PDB instance in Oracle 12c starting with 'C##' since that is the convention for creating profiles in a CDB instance. NET\'\)\" full=yes dumpfile=dblinks. DMPschemas=TESTCONTENT=ALLNOLOGFILE=Yinclude=table:'in • migrating from a non -CDB Oracle database to an Oracle multitenant database; • migrating with changes to database structure; or, • combining a migration and a version upgrade. 3. Here find internal_logon and set it's parameter to sysdba. (as it might impact the performance). Valid keyword values are: ALL, DATA_ONLY, [METADATA_ONLY] and NONE. run create user test identified by password default tablespace users temporary tablespace temp;. Connect to Oracle as SYSDBA using OCI or SQL*Plus, from client machine. SYSDBA is used internally and has specialized functions; Learn how Oracle Data Pump Export utility expdp identifies instances with connect Exporting Data. There was no Password required to connect to the Oracle database. Last updated: March 24, 2020 - 12:07 am UTC. Oracle Database - Enterprise Edition - Version 19. Connected to: Oracle Database 12c Enterprise EDB EXPDP failover flashback goldengate grid impdp multitenant OPATCH ORA-oracle oracle 12. dmp LOGFILE=mehmet_salih_deveci. Connected to: Oracle Database 11g Enterprise Edition Release 11. PRE-REQUISITES: 1. I blogged about it in Can you connect as SYSDBA without password into a PDB directly?. Home » Articles » 10g » Here. Toggle Dismiss. If you omit the AS SYSDBA clause when logging in as user SYS, the SQL Command Line rejects the login attempt. The PDB parameter is applicable only in a CDB environment. 122021_%U. Migrating data using Oracle Data Pump is a three-step process. Thank you! Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group SQL> create directory EXPLOG as '/export/home/oracle'; Directory created. You cannot specify a particular PDB; either all of them or none of them will have new DBIDs. – By default LOGTIME=NONE, If you want to use this feature Read More Oracle Database also changes the PDB property of all database services in the PDB to the new global name of the PDB. log. The document discusses how to connect to an Oracle pluggable database (PDB) as SYSDBA without providing a password by using the ORACLE_PDB_SID environment variable. ora. 2) same user user1@mypdb1 connect • migrating from a non -CDB Oracle database to an Oracle multitenant database; • migrating with changes to database structure; or, • combining a migration and a version upgrade. but using the same connection i use dba_tables and i filter user1 it shows only my tables. 2) same user user1@mypdb1 connect COMPRESSION parameter is used with EXPDP, to compress the generated dump file. The best workaround is to use dblink with Oracle datapump to move You must define an explicit directory object within the PDB that you are using with Oracle Data Pump export/import. 1. In the following example, the personel table of the HR schema is exported and Also, assuming that orcl is a valid sid, you can set the ORACLE_SID environment variable to orcl, then you should be able to do sqlplus / as sysdba – sstan. Categories. 1) For many developers and DBAs, one of the biggest changes introduced by the Multitenant option is how it affects running batch jobs from shell scripts. log \ compression=all compression_algorithm=medium Multitenant Option Support (CDB and PDB) Oracle Database 12c introduced [oracle@server1 admin]$ sqlplus / as sysdba SQL> create directory cdb as '/home/oracle/cdb'; 全库导出： [oracle@server1 ~]$ expdp system/oracle directory=cdb dumpfile=cdb. 1st case: sqlplus sys/password@localhost/xepdb1 <<Back to Oracle RAC Main Page How to Find Out VIP of an Oracle RAC Cluster Login clusterware owner (oracle) and execute the below command to find out the VIP hostname used in Oracle RAC $ olsnodes -i node1 node1-vip node2 node2-vip OR $ srvctl config nodeapps -viponly Network 1 exists Subnet IPv4: 10. com. Home » Articles » 12c » Here. Thank you! Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group how to export PDB tables with SYS user with out password on DB 19. For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle. using command line option localhost:$ export Many of you may be using Oracle Data Pump Export (expdp) and Data Pump Import (impdp) for logical backups of objects/schemas as well as the full databases for say, Set the environment variable for the pluggable database (replace pdb with your actual PDB name) you can connect directly using the pluggable database name. Technical questions should be asked in the appropriate category. Check the database status SQL> select INSTANCE_NAME, STATUS, VERSION from V$instance; INSTANCE_NAME STATUS VERSION Set this environment to the PDB name, and then you could connect / as sysdba, without providing a password (on the database server). 2- Set the ORACLE_SID to the desired CDB Hello, OS: Windows 10 DB: Oracle Database 18c Express Edition Release 18. log version=11. 2 to limit resources used by Data Oracle Data Pump is made up of three distinct components. Viewed 1000+ times However maybe also good to mention that special care should be taken that, while using the parameter ORACLE_PDB_SID, you always make sure to double-check that the parameter ORACLE_PDB_SID was initialized Below is an example command for exporting a table using Oracle Data Pump (EXPDP): Note:Before running the export command, it’s a good practice to verify your database connection. Source: Oracle 12c Datapump Documentation Thanks for the question, Orna. SYSDBA is used internally and has specialized functions; PDB user connecting as sysdba I have a query regarding username and it's roles. DEMO: SQL> [] 在谈到数据库客户关注点时，香港的同事说感觉客户非常注重的是安全，前段同事写过一篇MySQL中容易泄露数据库用户密码的地方，如shell、SQL的历史记录、主从复制等，当然也包括部署的一些数据库脚本，如逻辑导出，Oracle也不例外，好多用户在用户密码复杂度上很苛刻，但如在数据库中部署的如 Do not start Export as SYSDBA, except at the request of Oracle technical support. To know more visit: www. 6) on Microsoft Azure. dmp logfile=expdp_emp. We will explain its use in below demo. Install the latest version of Oracle Database XE 21c. Note the escape characters in the command line i) expdp \"/ as sysdba\" parfile=myparfile. Both the local and remote users require the IMP_FULL_DATABASE role granted During peak business hours, It is not advised to export data from production . DOMAIN. How can i tell expdp to which pluggable Database Software. Make sure the username is set to sys as sysdba. par. (PDBPRIM) Doing a full export "as sysdba" is a bad idea - a major security risk (plus "system" doesn't have the sysdba privilege by default anyway). So - if this works for you: sqlplus sys/Oracle_1@pdborcl as sysdba; Try: "SYS AS SYSDBA" as below • migrating from a non -CDB Oracle database to an Oracle multitenant database; • migrating with changes to database structure; or, • combining a migration and a version upgrade. 0/255. 0 for both source and destination db. In previous releases transportable tablespace jobs could not be resumed. 0 Production on Thu Nov 25 01:25:33 2021 Simple but very handy way of taking exports without knowing database password. mkdir /opt/dump chown -R oracle:oinstall /opt/dump chmod -R 760 /opt/dump Perform the following steps for each pluggable database (PDB). alter session set container = pdb_name_for expdp db_user@pdb_name_for_DBCS directory=dump_file_alias dumpfile=dump_file_name logfile=log_file_name The following export is run as SYS user after setting PDB's context using "export ORACLE_PDB_SID=PDB_SALES" $ expdp "'/ as sysdba'" directory=DUMP_DIR_TST INCLUDE=DB_LINK:\"IN\(\'SCI_LINK02. 0 For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle. Schema Name:- Scott. They are the command-line clients, expdp and impdp; the DBMS_DATAPUMP PL/SQL package (also known as the Data Pump API); and the DBMS_METADATA PL/SQL package (also known as the Metadata API). Step 1: Create parfile Read more You can not use expdp / impdp on a different SID as is but via DB Link route (using NETWORK_LINK switch). In a non-CDB, a profile name cannot begin with C## or For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle. dmp LOGFILE=example. expdp "/as sysdba" parfile=exp_user. The Data Pump clients, expdp and impdp, start the Data Pump Export utility and Data Pump Import utility, These changes document Community specific rules and Oracle’s content moderation practices including use of automated tools, appeals process, and Oracle’s contact details. Assuming your cloud instance and PDB are created: export the on-premises database using expdp, copy the dump files to the target system or to the Oracle Object Store, if required, and Plugging in the Oracle Database XE 18c PDB to XE 21c CDB. e to let’s say 10 percent of data from that table, then SAMPLE parameter can be used in EXPDP. It needs to present the username as sys as sysdba to Oracle when connecting. Go back. Step two: Add pdbname in the tns file Oracle Database - Enterprise Exporting a schema which contains a dot in the name with EXPDP fails with ORA-39001, ORA-39170 Exporting a schema which contains a dot in the name with EXPDP fails with ORA / as sysdba. Run expdp command: SYNTAX: expdp / as sysdba. In the example, XEPDB2 is the new pdb: SQL> CONNECT / AS SYSDBA SQL> CREATE PLUGGABLE DATABASE XEPDB2 USING '/tmp/xepdb1. Technical questions I am exporting data of a table through EXPDP by using the below command nohup expdp \"/ as sysdba\" directory=DATA_PUMP_DIR dumpfile=EXP. Symptoms "/ as sysdba" is used to connect to Oracle via expdp and impdp in Oracle 11g, 12c, 18c. 2. DMPschemas=TESTCONTENT=ALLNOLOGFILE=Yinclude=table:'in Hello, OS: Windows 10 DB: Oracle Database 18c Express Edition Release 18. Steps to run export in background Follow the below steps to run expdp/impdp in nohup. 0/bondeth0, static Subnet IPv6: Oracle DBA; How To Run Expdp In Pluggable Database(PDB) Kiran Dalvi; 03 Sep, 2023; 0 Comments; 51 Secs Read; How To Run Expdp In Pluggable Database(PDB) How To Run Expdp In Pluggable Database(PDB) Now create a directory for datapump under the PDB. MyNonCDB12c. Make sure PDB service is registered in the listener. You use the RMAN CONVERT command to perform cross-platform transport with image copies. The exported dump files may take lot of space on the disk. I am installing Oracle 19c on Oracle Linux (7. If you object to any changes, you may request that your account be closed by contacting oracle-forums-moderators_us@oracle. Here is the simple command to run expdp (data pump export) as sysdba. I've tried the following with no success. QUERY clause can be used in expdp or impdp to export/import subset of the data or data with specific conditions. I want to export tables under a specific schema using SYS user with out password. But, I want to skip a DB Link named SYS_HUB owned by SYS user. oracle 12c partition patch patching PDB pluggable postgres RAC replication Migrating Oracle Java Cloud Service on OCI-C to Oracle WebLogic Server for OCI Using tar; oracle sqlplus <At the prompt enter>: sys as sysdba <enter password when prompted> Switch to the PDB. However, i think, Ans-1 should address your real problem due to Oracle XE limitations. dmp LOGFILE=HR. Do not start Export as SYSDBA, except at the request of Oracle technical support. 0 and later Information in this document applies to any platform. I would like to be a little more descriptive by adding screenshots. Using "/ as sysdba" or "sys as sysdba" may give you unpredictable results. Keywords “nohup expdp / as sysdba”, “expdp parfile userid=/ as sysdba”, “How to run expdp in nohup”. SQL> select count(*) from “DBACLASS”. Announcement . Apparently, the ability to use expdp/impdp on AWS is quite new. expdp command is run with sysdba. 3. Oracle Cloud Infrastructure; Cloud Migrations; Virtualization (iPaas) Heterogeneous Database Migrations; Oracle Goldengate Migrations; expdp as sysdba. 122021. 1st case: sqlplus sys/password@localhost/xepdb1 As of Oracle Database 12 c Release 2 (12. Run Sqlplus sys/ as sysdba , (if has password you should type it next) run alter session set container=pdbDBName---; (eg:pdborcl). run grant dba to test;. txt) or read online for free. Add a new database. NOTE – For using compression parameter with datapump, we need to have Oracle advance compression license. dmp LOGFILE=expdp. 1) The multitenant option introduced in Oracle Database 12c allows a single container database (CDB) to host multiple separate pluggable databases (PDB). log full=y 通过将CDB. Pin. Assuming your cloud instance and PDB are created: • export the on-premise database using expdp, RMAN enables you to use image copies to transport tablespaces, data files, or an entire database. Do not run the Oracle Data Pump export utility expdp or import utility impdp as SYSDBA, except at the request of Oracle technical support. 18 version how to export PDB tables with SYS user with out password. log Export: Release 19. Oracle Net Services must be configured properly for clients to access database services. 0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt ions WARNING: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database. You must close the PDB and open it in read/write mode for Oracle Database to complete the integration of the new PDB service name into the CDB. 0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics and Real Application Testing options Starting "SYS". DMPschemas=TESTCONTENT=ALLNOLOGFILE=Yinclude=table:'in expdp \'/ as sysdba\' schemas=siddhu If you want to export only the tables, you can also add include=table: expdp \'/ as sysdba\' schemas=siddhu include=table The above exports the tables with indexes and triggers, but it skips procedures, sequences and other objects not directly related to tables. 4. Multitenant : Running Scripts Against Container Databases (CDBs) and Pluggable Databases (PDBs) in Oracle Database 12c Release 1 (12. /sqlplus / as sysdba where it is asking me to provide credentials, I tried SYS, SYSDBA with password "change_on_install" (followed this article), did not work, tired user [oracle@MehmetSalih ~]$ expdp \"/ as sysdba\" SCHEMAS=HR DIRECTORY=DATAPUMP DUMPFILE=HR. log SCHEMAS=MYSCHEMA. Moreover, there may be performance issues due to cross network/DB data flow. In this below demo, we will compare the [oracle@MehmetSalih ~]$ expdp \"/ as sysdba\" SCHEMAS=MEHMET,SALIH,DEVECI DIRECTORY=DATAPUMP DUMPFILE=mehmet_salih_deveci. I have to use expdp to export a table and later import the table into another pluggable database. I am creating a spring boot application which is connecting to an Oracle DB instance. Username: sys@pdb1 as sysdba Password: Connected to: Oracle Database 12c EE High Perf Release 12. Tablespace transport is sometimes performed by individually transporting the data files that store the tablespace data. log DIRECTORY=STAGING_DIR. dmp logfile=cdb. Check the running job. You are better off defining a user with exp_full_database and/or datapump_exp_full_database privileges only, with OS authentication or with an Oracle Wallet to hold the credentials, and using that account to run the full export. SQLPLUS connection to different dbs. I don I need to connect my Oracle 11g DB from shell script with 'sysdba' permissions. Filtering During Export Operations Data Pump Export Do not start Export as SYSDBA, except at the request of Oracle technical support. CATEGORIES I can't use EXP as it is blocked on the db. Attach the Datapump job 1. When I try the below par file, I get the below erro how to export PDB tables with SYS user with out password on DB 19. Physical standby database should be in READ-ONLY MODE (ACTIVE DATAGUARD) 2. sqlplus sys/manager@dev as sysdba SQL*Plus: Release 12. export ORACLE_PDB_SID=PDB1 Learn How to export the Pluggable full DB using expdp utility in Oracle 18c. 1. 255. So if we have a physical standby database, we can export data using datapump from standby database. mirsayeedhassan. SYSDBA is used internally and has specialized functions; Learn how Oracle Data Pump Export utility expdp identifies instances with connect $ expdp scott/tiger tables=emp directory=test_dir dumpfile=emp. 1) How to run expdp as sysdba There are two ways of running it using sysdba. com You can connect to database either using connect command or using command line option. From what I understand, when creating an ORACLE database on RDS, a DATA_PUMP_DIR is automatically created. SYSDBA is used internally and has specialized functions; its behavior is not the same as for general users. When you try to move large tables or schema between two Oracle databases, datapump export might take lot of disk space. I have granted tom dba privs just for testing purpose. I want to use sqlplus and pass it the string '/ as sysdba' to letme log in from korn shell script and run commands as sys. The expdp and impdp utilities are just a wrapper over the underlying APIs. mdhtftq mlocld whnr jyl nla bssb vjgei umfvl arddw lotfufy