Home » RDBMS Server » Server Administration » export / import - how can i do an import from...
export / import - how can i do an import from... [message #54272] Fri, 08 November 2002 00:57 Go to next message
Sascha
Messages: 15
Registered: November 2002
Junior Member
an existing export?
I have an complete export from a user called CAR, and i must import the whole data from CAR into a new user called CAR_TEST.
How does it work?
Please help me.

Thanks.
Sascha (Junior-DBA :-))

Report message to a moderator

Re: export / import - how can i do an import from... [message #54275 is a reply to message #54272] Fri, 08 November 2002 03:37 Go to previous messageGo to next message
B
Messages: 327
Registered: August 1999
Senior Member
Create user CAR_TEST
grant him privileges ( connect etc... all needed )
use
imp fromuser=CAT touser=CAR_TEST FILE=UR_DUMP LOG=UR_LOG commit=y ignore=y

Report message to a moderator

Re: export / import - how can i do an import from... [message #54289 is a reply to message #54272] Fri, 08 November 2002 12:54 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
You can setup

buffer=100000 (to speed up the import process)
statistics=none (to speed up the import process. then collect the statistics later)

feedback=100 (to show one dot on the screen for every 100 records already imported)

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: need of svrmgrl.exe
Next Topic: default 0 vs. null
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 02:05:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.