using comand prompt how can import table data and table space with example

using comand prompt how can import table data and table
space with example

Question Posted / kavithanedigunta

2 Answers
5626 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

using comand prompt how can import table data and table space with example..

Answer / raja

If u want to import only table data then you can opt for
sql loader and if u want to import the table sapce then you
can go for imp command

Is This Answer Correct ?

5 Yes

2 No

using comand prompt how can import table data and table space with example..

Answer / pradeep

imp command can be used for both table data and table space
import. Add one parameter for table data import (tables=
TABLE_NAME1,TABLE_NAME2).

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers Satyam,

What is pl sql package?

0 Answers

how to get second highest salary in SQL(as/4000

29 Answers iGate,

What is recursive join in sql?

0 Answers

How to know the last executed procedure?

0 Answers

What is the command used to fetch the first 5 characters of a string?

0 Answers

Can we rename a column in the output of sql query?