Well, I can see why he couldn't find the manuals.... Different companies.
Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546
-----Original Message-----
From: Edwards Ed [mailto:mssqldba-ezmlmshield-x68399070.[Email address protected]
Sent: Thursday, June 28, 2007 10:00 AM
To: LazyDBA Discussion
Subject: RE: please help
Hey Joel,
Did SQL Server get the export and import utilities back in SQL Server 7.0, SQL Server 2000 or SQL Server 2005? Hehe.
Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Joel [mailto:mssqldba-ezmlmshield-x1806697.[Email address protected]
Sent: Thursday, June 28, 2007 9:58 AM
To: LazyDBA Discussion
Subject: RE: please help
Imp help=yes
File=<>.dmp
Log=<>.log
Buffer=10485760 (or 20971520)
Commit=y
Rows=y ( n for indexes)
Indexes=n
Ignore=y (cause the tables where first)
Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546
-----Original Message-----
From: DEBARBAT David [mailto:mssqldba-ezmlmshield-x64498227.[Email address protected]
Sent: Thursday, June 28, 2007 9:45 AM
To: LazyDBA Discussion
Subject: RE: please help
Thanks Joel
It's not on Windows......beurkkkk.....Solaris is better....
I'm going to increase the buffer first...and import data first following indexes....
To avoid searches on net, do you hvae the syntax on mind ?
Thanks
David
-----Message d'origine-----
De : Joel [mailto:mssqldba-ezmlmshield-x26996910.[Email address protected]
Envoyé : jeudi 28 juin 2007 14:59
À : LazyDBA Discussion
Objet : RE: please help
Hehe... besides not knowing what 4.5 Go is.... your in a Microsoft
forum. Hehe.
Commit is only good alongside the buffer parameter and will commit when
the buffer gets full instead of after each table which is the default.
You can use a big buffer to speed things up, but are probably more
likely to be successful importing the data first, and then the indexes.
The rest is more complicated, like parallizing imports by breaking up
the users or tables... This success would depend on your IO
configuration and controllers -- separate IO processes.
Try the data, then index thing first, with a big buffer... start with
10Mbs or 20Mbs.
Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546
-----Original Message-----
From: DEBARBAT David
[mailto:mssqldba-ezmlmshield-x50081030.[Email address protected]
Sent: Thursday, June 28, 2007 7:40 AM
To: LazyDBA Discussion
Subject: RE: please help
Hi,
I have an import which take about 5 hours for a database oracle 9i of
4.5 Go
imp admbackup/oracle file=$DUMP_FILE buffer=300000 ignore=Y commit=y
fromuser=blablabla touser=blablabla
Does someone know if I can make some optimizations on this import ? Does
paremeter commit=y can reduce the speed.
Thanks.
David
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page