OraFAQ Forum: Server Utilities » how imp new data

Home » RDBMS Server » Server Utilities » how imp new data

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

how imp new data [message #658729]

Sat, 24 December 2016 10:08

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

Report message to a moderator

Re: how imp new data [message #658731 is a reply to message #658729]

Sat, 24 December 2016 10:12

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?

Report message to a moderator

Re: how imp new data [message #658732 is a reply to message #658731]

Sat, 24 December 2016 10:23

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

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

Report message to a moderator

Re: how imp new data [message #658736 is a reply to message #658733]

Sun, 25 December 2016 00:14

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

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: how imp new data [message #658740 is a reply to message #658738]

Sun, 25 December 2016 08:27

alhakimy
Messages: 56
Registered: December 2016

Member

/forum/fa/13373/0/

Attachment: test.jpg
(Size: 105.72KB, Downloaded 3181 times)

Report message to a moderator

Re: how imp new data [message #658741 is a reply to message #658740]

Sun, 25 December 2016 08:34

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?

Report message to a moderator

Re: how imp new data [message #658742 is a reply to message #658741]

Sun, 25 December 2016 09:30

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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

alhakimy
Messages: 56
Registered: December 2016

Member

Sad

I do not know Sad

Sad

Sad

Report message to a moderator

Re: how imp new data [message #658745 is a reply to message #658744]

Sun, 25 December 2016 10:40

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you don't know how could we?

Report message to a moderator

Re: how imp new data [message #658754 is a reply to message #658745]

Mon, 26 December 2016 01:47

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

Report message to a moderator

Re: how imp new data [message #658755 is a reply to message #658754]

Mon, 26 December 2016 01:55

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: how imp new data [message #658761 is a reply to message #658755]

Mon, 26 December 2016 08:24

alhakimy
Messages: 56
Registered: December 2016

Member

OK
I will look for more information

thank you

Report message to a moderator

Re: how imp new data [message #658762 is a reply to message #658761]

Mon, 26 December 2016 08:33

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

Report message to a moderator

Re: how imp new data [message #658763 is a reply to message #658762]

Mon, 26 December 2016 08:42

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?

Report message to a moderator

Re: how imp new data [message #658764 is a reply to message #658763]

Mon, 26 December 2016 09:22

alhakimy
Messages: 56
Registered: December 2016

Member

i am not understand you

Is it possible to explain the simplest way

Report message to a moderator

Re: how imp new data [message #658765 is a reply to message #658764]

Mon, 26 December 2016 09:28

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?

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 28 16:50:42 CDT 2025