Heres the copy of the writeup i did to install the latest 11g oracle. Run post database import scripts to configure oracle application express apex. Exporting and importing data between oracle database xe 11. The tools instant client package is available on platforms that support the oci instant client. Now i am using it again with the following environment. This chapter describes how to use the original export and import utilities, invoked with the exp and imp command, respectively. Oracle s imp utility like sdstuber said is an operating system utility, so it must be run from a command prompt, not inside of oracle s sql command line utility which is called sqlplus on all versions of oracle other than oracle xe. Import a oracle dmp file into a fresh install of oracle database. Just create one yourself using the following command first login to oracle using sqlplus as sysdba.
In sqlplus, im connected to an oracle 11g database. To download the full oracle client, follow these steps. And download basicwin32 and sqlpluswin32 files to your pc for. Thanks for the very fast response, i will test exp,imp from windows. Dell server tutorials oracle database vmware tutorials. Why is it necessary to type host before the imp command. First of all, download the installer from oracle website.
How to install oracles exp imp binaries server fault. I have oracle 10g xe on my development machine and i want to use expdpimpdp to copy the tables i am interested in into my machine. Standard edition, standard edition one, and enterprise edition. Imp command not found if this is your first visit, be sure to check out the faq by clicking the link above. Setting up a local oracle xe database and importing dmp file. The tools package contains several command line utilities, including sqlloader, data pump export, data pump import, original classic export, and original classic import. How do i import data into a new installation of oracle 11g r2 using a. Installing oracle instantclient basic and instantclient sqlplus on win32. All the guides ive seen online for importing say to just type imp, without the host part. In the start menu all programs, a new folder oracle database 11g express.
1312 205 328 1357 1319 789 729 1348 640 452 423 1188 1257 406 1606 1384 1599 1576 1504 776 1651 489 132 1430 1466 923 660 352 1576 508 1237 693 931 225 812 959 1012 350