OraFAQ Forum: Server Utilities » how I import table and view into my current database aamir from mfa database

Home » RDBMS Server » Server Utilities » how I import table and view into my current database aamir from mfa database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how I import table and view into my current database aamir from mfa database [message #182116]

Thu, 13 July 2006 03:09

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

Hi master

Sir I use this command form creating the dblink and give me result right

And aamir is my current using database name

SQL> create database link mfa connect to scott identified by tiger using 'mfa';

Database link created.

SQL> select * from cat@mfa;

Sir want import all table and view in aamir database use sql because import and exprt command in window run section are not give me result

Please give me idea now I import table and view into my current database aamir from mfa database

By using sql command

Thanks

aamir

Report message to a moderator

Re: how I import table and view into my current database aamir from mfa database [message #182122 is a reply to message #182116]

Thu, 13 July 2006 03:48

asherisfine
Messages: 63
Registered: June 2006
Location: India

Member

hi

Then i think you will have to create script for all the tables and views and also insert script for each table

Report message to a moderator

Re: how I import table and view into my current database aamir from mfa database [message #182125 is a reply to message #182116]

Thu, 13 July 2006 04:04

vin_odks
Messages: 153
Registered: July 2006
Location: -

Senior Member

mfa786 wrote on Thu, 13 July 2006 13:39

because import and exprt command in window run section are not give me result

Export and Import is the better way in your scenario.

Have you tried understanding why it failed??

vinod

Report message to a moderator

Re: how I import table and view into my current database aamir from mfa database [message #182126 is a reply to message #182122]

Thu, 13 July 2006 04:05

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

thank for your reply

sir the edp database is not in my computer i create db_link with edp database is
physically exists in other computer some boy said me you can not import and
export use on external computer

please give me idea how i transfer table in edp database
thank
aamir

Report message to a moderator

Re: how I import table and view into my current database aamir from mfa database [message #182129 is a reply to message #182116]

Thu, 13 July 2006 04:10

vin_odks
Messages: 153
Registered: July 2006
Location: -

Senior Member

Hi,

1)Export the tables from mfa into a dmp file (EDP system).

2) Transfer the dmp file to your current System

3) Import the dmp file into you current database (AAMIR)

Hope it solves your problem

Regards
Vinod

Report message to a moderator

Re: how I import table and view into my current database aamir from mfa database [message #182139 is a reply to message #182129]

Thu, 13 July 2006 04:38

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

sir i use import command then system stop hear what i give in this section

Enter table<T> or partition <T:P> names. Null list means all table for user
Enter table<T> or partition <T:P> name or id done : t
Enter table<T> or partition <T:P> name or id done : p
Enter table<T> or partition <T:P> name or id done : yes
Enter table<T> or partition <T:P> name or id done : mfa

please give me idea

Report message to a moderator

Re: how I import table and view into my current database aamir from mfa database [message #182148 is a reply to message #182139]

Thu, 13 July 2006 05:04

asherisfine
Messages: 63
Registered: June 2006
Location: India

Member

Hi

I have never done Import without using parameter file

But i think you have done import without parameter file

sir i use import command then system stop hear what i give in this section

Enter table<T> or partition <T:P> names. Null list means all table for user 
Enter table<T> or partition <T:P> name or id done : t
Enter table<T> or partition <T:P> name or id done : p
Enter table<T> or partition <T:P> name or id done : yes
Enter table<T> or partition <T:P> name or id done : mfa

please give me idea

instead of that when

Enter table<T> or partition <T:P> names. Null list means all table for user 
Enter table<T> or partition <T:P> name or id done :

comes don't type any thing just press enter

see what i got

Import entire export file (yes/no): no >
Username: newscott

Enter table(T) or partition(T:P) names. Null list means all tables for user
Enter table(T) or partition(T:P) name or . if done: yes

Enter table(T) or partition(T:P) name or . if done: mfa

Enter table(T) or partition(T:P) name or . if done:
--i just pressed enter on 3rd prompt and i got everything correct
. importing NEWSCOTT's objects into NEWSCOTT
IMP-00033: Warning: Table "YES" not found in export file
IMP-00033: Warning: Table "MFA" not found in export file
Import terminated successfully with warnings.

Report message to a moderator

Previous Topic:	unable to load data using SQLLDR
Next Topic:	how to connect sqlldr

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 20:06:55 CDT 2024