Export-Import

[cpiyush]

Hi.

I have created a .dmp file from a db 'Sample'.

Then I created another db & imported that .dmp file to that new database.
But this is not showing the contents of that Sample db in my new db.

Can you please tell me how to take tables from onw db to another one??

I have one more problem that I have some *.sql files, now I want to create a Database from these file, how can I do this???...will import work???..if yes then how??

Regards,
Piyush.

[contactsanjaykumar]

For this u will have to create the database with the same name SAMPLE then
u create the .dmp file from your own database with the option "U" .After that u
import the .dmp file into your new 'SAMPLE' database. You will get your desire
output..

If u have another name of the database then u will have to import the whole database with some specific option.......(O ption Later on)...

Regards,
contactsanjayku mar@rediffmail. com

[sudiptomukherjee]

hi piyush,
first off all create a database using the sql script by connecting to sys superuser then create a user with granting him appropriate priveledge for import on which you have to import data,then import the data by import utility.just check out that the data has been not imported to system user,if u r using from user touser option...

Hi.

I have created a .dmp file from a db 'Sample'.

Then I created another db & imported that .dmp file to that new database.
But this is not showing the contents of that Sample db in my new db.

Can you please tell me how to take tables from onw db to another one??

I have one more problem that I have some *.sql files, now I want to create a Database from these file, how can I do this???...will import work???..if yes then how??

Regards,
Piyush.

[cpiyush]

Well...my problem is solved now.
Thanks a lot...