Home » RDBMS Server » Server Utilities » export parameter clarificationsq (oracle 10g rel 2 sun solaris 5.9)
export parameter clarificationsq [message #322549] Sat, 24 May 2008 06:54 Go to next message
kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI
Senior Member
sir, i have some clarifications....


1)

i have generated export dump file.IN that, all constraints and indexes are there.
for one column, primary key constraint has been set. during import, if i put INDEXES=N and CONSTRAINTS=y,
then primary key constarint will be imported ? if so, corresponding primary key index also will be
imported ?

what would be the output ?

2)

during export, iam putting DIRECT=y ( so it will bypass the buffer ) ...
if i put simultaneously buffer=209715200 , what will happen ?
Here iam having doubt, will both parameter work together ? if so, kindly explain how it works ?

Thank you
kesavan


Re: export parameter clarificationsq [message #322554 is a reply to message #322549] Sat, 24 May 2008 08:25 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Here iam having doubt, will both parameter work together ?

what happened when you actually tried them both together?


>if so, kindly explain how it works ?
it works well.
Re: export parameter clarificationsq [message #322568 is a reply to message #322549] Sat, 24 May 2008 09:13 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
1) http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/ch02.htm#1005492

2) http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm#1005572

Regards
Michel
Previous Topic: problem : import partition wise -- import has been done successfully withe now rows
Next Topic: SQL LOADER
Goto Forum:
  


Current Time: Tue Dec 24 10:01:08 CST 2024