Using imp or exp as a SYSDBA

Posted on
Oracle SQL

One of the things that I regularly forget is the syntax for running imp or exp for Oracle and specifying a SYSDBA user. As a quick hint, here's the syntax:

imp '"sys/pass@TNS as sysdba"' FILE=file.exp

An easy thing to forget!