OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » IMPORT

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

IMPORT [message #169270]

Wed, 26 April 2006 00:21

anandhi
Messages: 31
Registered: April 2006
Location: Chennai

Member

Hi

I want to import a specific partition from partition table. Can anyone guide me with syntax also?

Thanks
Anandhi

Report message to a moderator

Re: IMPORT [message #169279 is a reply to message #169270]

Wed, 26 April 2006 01:36

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Do you have an export dump?

I think you want to export a specified partition in a partitioned table. is it correct?

[Updated on: Wed, 26 April 2006 01:37]

Report message to a moderator

Re: IMPORT [message #169281 is a reply to message #169279]

Wed, 26 April 2006 01:44

anandhi
Messages: 31
Registered: April 2006
Location: Chennai

Member

I have the export dump....but it contains all the partitions for example p1, p2, p3....i want to import only p3 from export dump.

Thanks
anandhi

Report message to a moderator

Re: IMPORT [message #169283 is a reply to message #169281]

Wed, 26 April 2006 01:48

kmsalih
Messages: 197
Registered: March 2006

Senior Member

if you are using 10g it is possible using impdp utility.

in that there is a parameter QUERY.

in that give the select statement to select only the partition you want.

Report message to a moderator

Re: IMPORT [message #169332 is a reply to message #169283]

Wed, 26 April 2006 05:30

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

Senior Member
Account Moderator

Did you ever read the documentation?

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch02.htm#1006658
quoting documenation

> exp scott/tiger TABLES=emp FILE=exmpexp.dat ROWS=y

Import Messages

Export: Release 9.2.0.1.0 - Production on Wed Feb 27 17:22:55 2002

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


Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in WE8DEC character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table                            EMP
. . exporting partition                             P1          7 rows exported
. . exporting partition                             P2         12 rows exported
. . exporting partition                             P3          3 rows exported
Export terminated successfully without warnings.

In a partition-level import you can specify the specific partitions of an exported table that you want to import. In this example, these are p1 and p3 of table emp:

> imp scott/tiger TABLES=(emp:p1,emp:p3) FILE=exmpexp.dat ROWS=y 

Import Messages

Import: Release 9.2.0.1.0 - Production on Wed Feb 27 17:22:57 2002

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


Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8DEC character set and AL16UTF16 NCHAR character set
. importing SCOTT's objects into SCOTT
. . importing partition                     "EMP":"P1"          7 rows imported
. . importing partition                     "EMP":"P3"          3 rows imported
Import terminated successfully without warnings.

Report message to a moderator

Re: IMPORT [message #169335 is a reply to message #169332]

Wed, 26 April 2006 05:43

kmsalih
Messages: 197
Registered: March 2006

Senior Member

THanks Mahesh
I tested the purpose of query.
It's for getting a subset of a table.

Salih Km

[Updated on: Wed, 26 April 2006 06:03]

Report message to a moderator

Previous Topic:	import
Next Topic:	RMAN 'Duplicate'

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 10:27:34 CST 2024