OraFAQ Forum: Server Administration » import a single object

Home » RDBMS Server » Server Administration » import a single object

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

import a single object [message #156163]

Mon, 23 January 2006 04:32

venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai

Member

1.we had taken a full database export. Can we import a single object from it? if it is possible, how can we import a single object ?

2.What are views available to see the information about export?

can any one clear my doubt

[Updated on: Mon, 23 January 2006 04:33]

Report message to a moderator

Re: import a single object [message #156168 is a reply to message #156163]

Mon, 23 January 2006 05:01

Gerardo Fernandez Herrera
Messages: 58
Registered: January 2006
Location: Montevideo, Uruguay

Member

1. You have four modes of import:
- Full
- Tablespace
- Owner
- Table
The last one allows you to import specific tables and partitions.
See http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/toc.htm for full details and syntax.

2. DBA_EXP_FILES, DBA_EXP_OBJECTS, DBA_EXP_VERSION

Regards.

Report message to a moderator

Re: import a single object [message #156952 is a reply to message #156163]

Mon, 30 January 2006 06:16

nirav.ahm
Messages: 1
Registered: January 2006

Junior Member

Hi,

Can you tell me how you exported full database as I also want to export full database and then import it to another server.

Thanks
Nirav Shah

Report message to a moderator

Re: import a single object [message #156953 is a reply to message #156952]

Mon, 30 January 2006 06:21

orausern
Messages: 826
Registered: December 2005

Senior Member

To export full database, use full=y as mentioned in the docs at:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm#1004891

FULL
Default: n

Indicates that the Export is a full database mode Export (that is, it exports the entire database). Specify FULL=y to export in full database mode. You need to have the EXP_FULL_DATABASE role to export in this mode.

Report message to a moderator

Re: import a single object [message #156975 is a reply to message #156163]

Mon, 30 January 2006 08:09

princess
Messages: 4
Registered: January 2006
Location: Alexandria

Junior Member

to export full database from server
access to the cmd(command prompet) and write
c:\exp
then its will prompet to u
username:scott/tiger@db1

then press enter for any comming message appear to u
then write the path u would like to save in it yr dump file when prompet to u
export file:expdat.dmp>c:\bk.dmp then press enter
and choose from the next prompt the option of full database

amira

Report message to a moderator

Previous Topic:	How to add a new control file to oracle 10G R2 database
Next Topic:	SCN-Demo

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 16:00:08 CST 2025