| import problem [message #357904] |
Fri, 07 November 2008 02:46  |
dr.s.raghunathan
Messages: 540
Registered: February 2008
|
Senior Member |
|
|
hi,
i am new to this thread (server utilities ). I have one problem on exporting and importing tables of the same user workspace same password.
For example.
In home and office in both places i am using one userid and same password.
In home i create 4 tables populated with 20 rows on each.
using imp/exp i import the same dmp at office and add another 10 rows for each table
now i take dump and take it to home.
in house if i use imp add rows are not updating in my house tables. I need to drop all the tables and then importing gets accommadating all the 30 rows.
This is one problem.
Another problem if add another table add some rows to existing table imports make me to add another table with full rows where as add rows in existing tables are getting imported.
Everytime I have to drop all the tables and importing. What sort of the mistake i am doing? The same question i have raised in some other fourm and did not get reply. Hence I am refining my request with examples to this forum.
can any one help me
yours
dr.s.raghuathan
|
|
|
|
|
|
| Re: import problem [message #357916 is a reply to message #357912] |
Fri, 07 November 2008 03:46  |
dr.s.raghunathan
Messages: 540
Registered: February 2008
|
Senior Member |
|
|
@littlefoot,
thank you very much. i have to check at home and i am adding few more rows to existing table and taken new dmp for export. is it possible to import one or two tables and one or two procedures alone. if so how.
since when i modify some of the procedure through object browser is not reflecting after import. hence i use to create another procedure by suffixing numerals for existing one and doing export and import work.
once again thank you very much for the guidance
yours
dr.s.raghunathan
|
|
|
|
| Re: import problem [message #357920 is a reply to message #357916] |
Fri, 07 November 2008 04:18 |
 |
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
| Quote: | is it possible to import one or two tables
|
Yes, using the TABLES option.
| Quote: | is it possible to import one or two procedures
|
No, as far as I can tell (at least, not in 10g or lower versions). If you have a couple of procedures, perhaps you'd easier simply recreate them in target database (just as you'd move DMP file on a USB stick, you'd move SQL files). Or, you could import with ROWS=N and use LOG option, open log file and extract CREATE PROCEDURE statements and run them separately through SQL*Plus (or TOAD or SQL Developer or ...).
10g's Original Export and Import documentation is available at OTN (as usually).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
