Answer Posted / pugal

The following examples demonstrate how imp/exp can be used:

exp scott/tiger file=emp.dmp log=emp.log
tables=emp rows=yes indexes=no

exp scott/tiger file=emp.dmp tables=(emp,dept)

imp scott/tiger file=emp.dmp full=yes
imp scott/tiger file=emp.dmp fromuser=scott
touser=scott tables=dept

exp userid=scott/tiger@orcl parfile=export.txt

... where export.txt contains:
BUFFER=100000
FILE=account.dmp
FULL=n
OWNER=scott
GRANTS=y
COMPRESS=y

NOTE: If you do not like command line utilities, you can
import and export data with the "Schema Manager" GUI that
ships with Oracle Enterprise Manager (OEM).

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2269

---

How to grant create session privilege to a user in oracle?

1050

---

What are the execution control statements?

1107

---

What is blob data type in oracle?

1205

---

How can we delete duplicate rows in a table?

1036

---

What is enter substitution variable in oracle?

1094

---

Why we use bulk collect in oracle?

1112

---

What happens to the data files if a tablespace is dropped?

1107

---

What is a schema in oracle?

1064

---

What is an oracle transaction?

1228

---

How to fetch the row which has the max value for a column?

1044

---

What is ADDM Advisor in Oracle?

1222

---

What is the difference between sharding and replication?

1132

---

How do I find my oracle client driver version?

1093

---

How to get the Installed Oracle Version Information ?

1188

---