Interested to Buy Any Domain ? << Click Here >> for more details...
can any one help me with import/export options in
oracle............
- 1 Answers
- 5715 Views
- I also Faced
- E-Mail Answers
Answer / 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).
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain the use of control file?
what r tyhe major differences between oracle 9i & 10g?
Why packages are used in oracle?
what is port in oracle? how is it related to database application.
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>
select statement does not retrieve any records. what exception is raised?
Difference between pre-select and pre-query
Name the three major set of files on disk that compose a database in Oracle?
What is Private Database Link ?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What is blob data type in oracle?
Oracle General 
