OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » exp & imp

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

exp & imp [message #74714]

Mon, 07 February 2005 22:37

kolen
Messages: 12
Registered: July 2003

Junior Member

1- Can I make exp for data from date to date without Tables?
2- How to make imp for data?

Report message to a moderator

Re: exp & imp [message #74717 is a reply to message #74714]

Tue, 08 February 2005 01:30

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

i beleieve, you are looking to import only data ( and leave the table as-is, if the table is already present in target location). You can do this only if there is no constraints that are violated during the import.
take an regular export and during import say ignore=y.
this will ignore the presence of table and will apppend the data.

>>Can I make exp for data from date to date
I dont undertand.
If you are looking to export data selectively based on data, then table should already have the date field.
during export you can include a where clause to filter the data selectively.

Report message to a moderator

Re: exp & imp [message #74721 is a reply to message #74717]

Tue, 08 February 2005 04:57

kolen
Messages: 12
Registered: July 2003

Junior Member

Thanks alot Mahesh Rajendran
I mean that take data from tables from date to date
Example. Exp from 0112005 to 2512005
The table is already present in target location.

Thanks

Report message to a moderator

Re: exp & imp [message #74722 is a reply to message #74721]

Tue, 08 February 2005 05:10

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

yes.
as is said before, the source table should have datefield and your date filter should be based on that field.

bash-2.03$ query mutation mag.emp

     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
      7369 SMITH      CLERK           7902 17-DEC-80        800                    20
      7499 ALLEN      SALESMAN        7698 20-FEB-81       1600        300         30
      7521 WARD       SALESMAN        7698 22-FEB-81       1250        500         30
      7566 JONES      MANAGER         7839 02-APR-81       2975                    20
      7654 MARTIN     SALESMAN        7698 28-SEP-81       1250       1400         30
      7698 BLAKE      MANAGER         7839 01-MAY-81       2850                    30
      7782 CLARK      MANAGER         7839 09-JUN-81       2450                    10
      7788 SCOTT      ANALYST         7566 09-DEC-82       3000                    20
      7839 KING       PRESIDENT            17-NOV-81       5000                    10
      7844 TURNER     SALESMAN        7698 08-SEP-81       1500          0         30
      7876 ADAMS      CLERK           7788 12-JAN-83       1100                    20
      7900 JAMES      CLERK           7698 03-DEC-81        950                    30
      7902 FORD       ANALYST         7566 03-DEC-81       3000                    20
      7934 MILLER     CLERK           7782 23-JAN-82       1300                    10

14 rows selected.

bash-2.03$ exp mag/mag tables=(emp) QUERY="WHERE hiredate between '20-FEB-81' and '01-MAY-81' " statistics=none

Export: Release 9.2.0.4.0 - Production on Tue Feb 8 09:05:59 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                            EMP          4 rows exported
Export terminated successfully without warnings.

Report message to a moderator

Re: exp & imp [message #74726 is a reply to message #74722]

Tue, 08 February 2005 21:54

kolen
Messages: 12
Registered: July 2003

Junior Member

Thanks alot Mahesh Rajendran.

Report message to a moderator

Previous Topic:	SQL*Loader help with control file
Next Topic:	Cloning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 20:09:39 CST 2024