Home » RDBMS Server » Server Utilities » how imp new data
how imp new data [message #658729] Sat, 24 December 2016 10:08 Go to next message
alhakimy
Messages: 56
Registered: December 2016
Member
hello
I do not speak English, but I will try to understand you

I am new in this forum
I have a question
I use oracle9i with dev6i

I have three Computers working in the same program separately
and I have a main computer works the same program separately

How do I export database for new inputs only from three Computers
Or how do I import new inputs only to main computer
To update my main computer from others

thank you
Re: how imp new data [message #658731 is a reply to message #658729] Sat, 24 December 2016 10:12 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

How do you differentiate new data from old data?
Re: how imp new data [message #658732 is a reply to message #658731] Sat, 24 December 2016 10:23 Go to previous messageGo to next message
alhakimy
Messages: 56
Registered: December 2016
Member
the main computer contains old data
I want to take a DMP file from three computers
And import it from main computer

I want to update daily

If there is a way to do that

[Updated on: Sat, 24 December 2016 10:30]

Report message to a moderator

Re: how imp new data [message #658733 is a reply to message #658732] Sat, 24 December 2016 10:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
https://docs.oracle.com/database/121/SUTIL/toc.htm

you can export from 3 computers & then import into main computer
Re: how imp new data [message #658736 is a reply to message #658733] Sun, 25 December 2016 00:14 Go to previous messageGo to next message
alhakimy
Messages: 56
Registered: December 2016
Member
but i not want normal import and export
i want import only new data or daily data
in which with me three computers data in main computer

All this on oracle9i

[Updated on: Sun, 25 December 2016 00:25]

Report message to a moderator

Re: how imp new data [message #658738 is a reply to message #658736] Sun, 25 December 2016 02:53 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Check the QUERY parameter; it allows you to specify a WHERE clause which might help you extract only the most recent data, such as
where date_column >= trunc(sysdate)
There are certain restrictions which apply to this parameter so - read the documentation, see if it helps.
Re: how imp new data [message #658740 is a reply to message #658738] Sun, 25 December 2016 08:27 Go to previous messageGo to next message
alhakimy
Messages: 56
Registered: December 2016
Member
/forum/fa/13373/0/
  • Attachment: test.jpg
    (Size: 105.72KB, Downloaded 2172 times)
Re: how imp new data [message #658741 is a reply to message #658740] Sun, 25 December 2016 08:34 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
pretty picture
Words have meanings!
only the EXPORT utility knows how to produce "DMP file".
EXPORT utility requires to connect to online Oracle database.
Does Oracle database now reside on PC1, PC2, & PC3?
Re: how imp new data [message #658742 is a reply to message #658741] Sun, 25 December 2016 09:30 Go to previous messageGo to next message
alhakimy
Messages: 56
Registered: December 2016
Member
thank you

But I not have a Internet or network between this computers

Can I not do this idea?

[Updated on: Sun, 25 December 2016 09:30]

Report message to a moderator

Re: how imp new data [message #658743 is a reply to message #658740] Sun, 25 December 2016 10:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You are on the wrong track using exp/imp or Data Pump for this task.
Just spool in a csv file new data in each PC and load these files in Excel on the main PC to print them as you want.

Your only question now is: "how to determinate new data in each PC?" and this only depends on your data model which will also determine the csv files you will generate.

[Updated on: Sun, 25 December 2016 10:27]

Report message to a moderator

Re: how imp new data [message #658744 is a reply to message #658743] Sun, 25 December 2016 10:35 Go to previous messageGo to next message
alhakimy
Messages: 56
Registered: December 2016
Member
Sad I do not know Sad Sad
Re: how imp new data [message #658745 is a reply to message #658744] Sun, 25 December 2016 10:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If you don't know how could we?

Re: how imp new data [message #658754 is a reply to message #658745] Mon, 26 December 2016 01:47 Go to previous messageGo to next message
alhakimy
Messages: 56
Registered: December 2016
Member
I saw this thing I think in Toad or other program
But I do not know how to work
Re: how imp new data [message #658755 is a reply to message #658754] Mon, 26 December 2016 01:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Your only question now is: "how to determinate new data in each PC?" and this only depends on your data model which will also determine the csv files you will generate.
If you don't or can't answer this question, it is useless to investigate more.
If you want more help from us, you have to post your data model (all tables with their constraints). TOAD can help you to do this.

Re: how imp new data [message #658761 is a reply to message #658755] Mon, 26 December 2016 08:24 Go to previous messageGo to next message
alhakimy
Messages: 56
Registered: December 2016
Member
OK
I will look for more information

thank you
Re: how imp new data [message #658762 is a reply to message #658761] Mon, 26 December 2016 08:33 Go to previous messageGo to next message
alhakimy
Messages: 56
Registered: December 2016
Member
what abut this code
IMP USERNAME/PASSWORD FILE=C:\DATA.DMP LOG=C:\DATA.LOG FULL=Y IGNORE=Y
Re: how imp new data [message #658763 is a reply to message #658762] Mon, 26 December 2016 08:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
alhakimy wrote on Mon, 26 December 2016 06:33
what abut this code
IMP USERNAME/PASSWORD FILE=C:\DATA.DMP LOG=C:\DATA.LOG FULL=Y IGNORE=Y
results depend directly upon the actual content of C:\DATA.DMP

Does an Oracle database reside on each PC1, PC2, & PC3?
Re: how imp new data [message #658764 is a reply to message #658763] Mon, 26 December 2016 09:22 Go to previous messageGo to next message
alhakimy
Messages: 56
Registered: December 2016
Member
i am not understand you

Is it possible to explain the simplest way
Re: how imp new data [message #658765 is a reply to message #658764] Mon, 26 December 2016 09:28 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
IMP can only retrieve what data that resides in DATA.DMP file;
which may be anything from FULL database (every schema & every table) to only metadata from single object.
We can not know what IMP USERNAME/PASSWORD FILE=C:\DATA.DMP LOG=C:\DATA.LOG FULL=Y IGNORE=Y produces without know exactly how DATA.DMP was created.


Does an Oracle database reside on each PC1, PC2, & PC3?
Previous Topic: SQL loader problem when using sequence
Next Topic: SQL Loader double quotes in clob data (3 threads from 2 sub-forums merged by bb)
Goto Forum:
  


Current Time: Thu Mar 28 07:58:09 CDT 2024