Oracle import (IMP) Export (exp) (9)

Oracle backup and recovery can be achieved through import (IMP) Export (exp:

Run exp help = y

View tablespaces
Select * from V $ tablespace

1 2 cwmlite Yes
2 3 drsys Yes
3 4 example Yes
4 5 indx Yes
5 0 system Yes
6 7 Tools Yes
7 1 undotbs Yes
8 8 users Yes
9 6 temp Yes
10 9 hhscinfo Yes

Export tablespace (hhscinfo)

Exp system/manager tablespaces = hhscinfo file = D:/expdat. dmp

Drop table infomanager. sysfunction

IMP system/manager file = D:/expdat. dmp tablespaces = hhscinfo full = y

Data imported successfully