l*****n
发帖数: 12 | 1 I have a data file in ASCII text format. How to import
it inot Oracel database? |
|
d**t
发帖数: 14 | 2 Hello,
I tried to import all tables from Access97 Database to SQL Server 7.0 by DTS.
There is an error message as following:
Error Source: Jet Database Engine
Error Description: You don't have permission to read "A" table.
However, I have all permissions for that database and all tables. I am
wondering there are some problems with driver setting. But I cannot figure out
the problems, could anybody know how to do it?
Thank you very much! |
|
l*****k
发帖数: 587 | 3 if I have a database dump file (schema export file).
can I import it to an oracle database and replicate everything
on it?
thanks |
|
s***m
发帖数: 28 | 4 Hi,
I am trying to create a test oracle database from a life oracle database.
Both databases have exact same schemas and are on two machines running Linux.
Now i already have everything in the test database except the table data. I
need to import the data from the life database. I have tried the following to
export data from life database. This is my parfile.
##############expfile.par########################
userid=user/passwd@db
file=expdat1.dmp
log=exp.log
tables=table1,table2,....
####### |
|
i******e
发帖数: 32 | 5 When I import data in to the SQL server, it gives an error because the
duplicate record and stops. However, is there a way to let the work keep
going for the rest of records? |
|
e*********s
发帖数: 200 | 6
Are you using DTS to import to a new table or existing table? |
|
s******n
发帖数: 45 | 7 Sounds pretty slow to me. Are you dropping the index and rebuilding after
the import? |
|
j*****u
发帖数: 446 | 8 如果我需要往database or spreadsheet里load 大量的data,怎么才能保证data的准确性
？
这是个interview的question, 原型是
A large amount of date needs to be imported to a database/spreadsheet, how can
you efficiently verify the data?
大家讨论讨论吧，给我点idea, 回答时都傻了 |
|
G***G
发帖数: 16778 | 9 I have 28 sql files and 28 txt files with the same name as sql files.
They are seeminly exported using mysqldump.
My question is how to import them into mysql.
thank you very much.
My files look like the following.
term.sql
term.txt |
|
o******5
发帖数: 29 | 10 Bethic Software's impexp32 is the best tool I used for importing data to
Oracle. However it need to have the target table already exists.
The other easy solution is Access. You first dump data to Access and save it
to Oracle via an ODBC connection. It will create the table.
Oracle's own SQL loader or external table are also useful. However it
requires some coding. |
|
o******5
发帖数: 29 | 11 I never use sql developer to import data to Oracle. So do not know whether
it will be better than impexp32 or not. Using impexp32, it will ask for the
source file and target table and how to map fields. It will give your
options on how to load the data, either append data or delete/insert. I used
to use sqlloader and it is a pain to create the control file and determine
how to handle hard return in the field.
BTW, impexp32 is part of Golden32 which is a good SQL tool. |
|
B*****g
发帖数: 34098 | 12 1. for such a big data, you should create tables yourself.
2. text file most time are Fixed Length or Delimited. Fixed Length, you know
the length of each filed. For delimited file fields length and type of
fields(both Fixed Length and Delimited), I think all (at least most)
software will decide based on data in the first data line(ignore header).
3. if the coming data is complete unknown, import to staging table first,
then....
4. Your company does not have BA?
columns |
|
B*********L
发帖数: 700 | 13 大概也许可能找到原因了，但是不知道怎么处理。
Oracle：Character set (AL32UTF8)
SQL Server: Client character set (WE8MSWIN1252)
They are different.
现在的 SSIS import 总是随机出错。我的package里用的是defaultcodepage=1252，不
知道怎样才能选AL32UTF8。
麻烦大家指点一下，谢谢。 |
|
B*********L
发帖数: 700 | 14 Jackrun, thank you very much for the help.
1258 works, but those random errors are not caused by codepage.I'll try the
import/export text file strategy when I have time. |
|
l****u
发帖数: 84 | 15 I am going to import very large stock market data from multiple .txt files (
over 3000 files) into sql database. I was wondering which is the most
efficient way to do that?
I used bulk insert and it takes me forever time (estimated 7 days) |
|
p********l
发帖数: 279 | 16 Pretty much these things. Specifying batchsize is important.
set |
|
c*******t
发帖数: 55 | 17 1. Bulk Insert is faster than SSIS if you turn on the table lock.
2. If you can make the data in all files are sorted, you can save the time
on index rebuild.
3. No matter Simple Recovery or Bulk Mode, SQL Server will start writing
huge data to log file after the first file, the size usually be 2~3 times
the data you are importing, so I suggest you shrink the log file after each
bulk-insert each file. (MSSQL will not write too much data to the log file
if the table is empty) |
|
j*******7
发帖数: 6300 | 18 I think the most important is to load the files in parallel, other
considerations include:
set DB recovery mode to be Simple
pre-allocate database files and optimize the disk system
are you going to load to a single table? can consider a partitioned design
perhaps. |
|
m********d
发帖数: 82 | 19 still not working. same error.
error message:
Error 0xc02020a1: Data Flow Task: Data conversion failed. The data
conversion for column "MEMBER_Notes" returned status value 4 and status text
"Text was truncated or one or more characters had no match in the target
code page.".
(SQL Server Import and Export Wizard) |
|
m********d
发帖数: 82 | 20 It worked, Thanks Beijing and smallburrito for your suggestions!
I did below steps:
1.copied the row with the longest note to the first column of the excel.
2.saved the file as text file.
3. in the import/export wizard, I chose "flat file source", then in the "
advanced" option, I changed the note field from string[dt_str] to text
stream [DT_TEXT].
And it worked!
Thanks Again for your help! |
|
z******4
发帖数: 4716 | 21 你用的是import wiz，最后一步选择生成package，然后打开package 好像要安装
business studio，你就能看到了
job不是package，job包含package
你随意倒腾一下，以后可以做参数，避免每个excel都手工导入了 |
|
s*******r
发帖数: 769 | 22 It seems I need to create a table, setup the columns like in the csv file
first, and then import. Is this correct? |
|
t******r
发帖数: 183 | 23 Yeah, I did that, and generated .tlb file, and imported it, using the smart
pointer as well, but i still can't make it work. The compiling was fine, but
the program breaks at creating a COM instance. |
|
w********h
发帖数: 12367 | 24 【 以下文字转载自 ECUST 讨论区,原文如下 】
发信人: wonderlich (Je pense, je suis), 信区: ECUST
标 题: Important Message (A New Virus)
发信站: The unknown SPACE (Tue Mar 6 00:00:14 2001) WWW-POST
Please note that this virus comes appearing as a "card"
from someone. NO VIRUS PROTECTION EXISTS FOR THIS VIRUS.
Please Read
A new virus has just been discovered that has been
classified by Microsoft (www.microsoft.com) and by
McAfee(www.mcafee.com) as the most destructive ever!
This virus was discovered yesterday afternoon by |
|
k**e
发帖数: 86 | 25 there is no difference. you should define classpath correctly.
main
Java
import. |
|
f******g
发帖数: 423 | 26 详情如下:
我需要import 一个叫 cs1.Keyboard 的 class.
这个不在java standard package里,是某人自己写的.
在网上找到了它,然后把keyboard.jar copy to \j2sdk1.4\lib,
成功.(under winXP)
但当我在另外一台机器上(win98)尝试时,
同样的方法却不work.我气起来把keyboard.class
keyboard.java, keyboard.jar (解压后是keyboard.class)
到处都拷了一份,还是不行.What should I do? |
|
p***e
发帖数: 29053 | 27 偶是新手，为何import org.apache.poi.hssf.usermodel.*;这个会出错的，谢谢 |
|
k**********a
发帖数: 255 | 28 我run了一下program 没有加import 而且程序里边调用的 lang 和 io 的method 都
work 这说明eclipse自动的引入的这两个library 但是我就是无法在目录树当中找到
这两个library 大家是怎么看待这个问题的 谢谢 |
|
m******t
发帖数: 2416 | 29
The common practice in Java is to define a wrapper interface,
and implementations delegating to these packages.
You could also completely avoid importing these classes
and rely on dynamic classloading and call the methods
reflectively, but I wouldn't do that unless there are no
other choices. |
|
r*****s
发帖数: 985 | 30 if purely export/import,
maybe exporting to db scripts is good enough,
however,
validation is also needed,
so what's the general solution?
mark the entities with JAXB,
marshall/unmarshall the entities,
and dump them into xml?
sounds the right way? |
|
e*****t
发帖数: 1005 | 31 没有自带.project的话，你应该在eclipse里面建立一个新project，而不是import. |
|
k*****r
发帖数: 21039 | 32 貌似work的不错。
download openoffice pdf importer first, install it as a plug in macro.
then you can open pdf and edit it in Draw, and export as pdf again.
works well. |
|
b*s
发帖数: 82482 | 33 http://www.tested.com/videos/44220-how-pixar-almost-lost-toy-st
How Pixar Almost Lost Toy Story 2 to a Bad Backup
Pixar's Oren Jacob and Galyn Susman recount how the files for Toy Story 2
were almost lost due to an accidental Linux command and bad backup. It's
probably a little over-dramatized from what actually happened, but is a good
reminder to back up your important files! |
|
q*****g
发帖数: 1568 | 34 我知道在Python里头，global statement是一个module里头的global变量。
所以如果我有一个文件叫做module1.py, 里头有这么一个函数：
def func1():
global foo
print foo
然后在我的主程序里头用：
from module1 import func1
foo = "bar"
func1(foo)
肯定会出错。因为module1里头的func1根本看不到主程序的foo。
那么，有什么办法让module1里的函数看到主程序的变量呢？还是根本不可能？ |
|
a****h
发帖数: 400 | 35 谢回复
不是jar
就是import几个目录里面有一些.java 文件
这样 eclipse左边的src下面就多了几个目录里面有一些.java文件
但是多的文件和目录前面都有大红叉
也都运行有错误 |
|
B*****g
发帖数: 34098 | 36 from tkinter import *
top = Tk()
is |
|
G**U
发帖数: 180 | 37 比如我想用D3.js，但我的理解html里面应该不需要写大量js代码了，逻辑应该在
component里面做完，但是怎么做这个import呢？用typescript，但D3貌似都是js写的
吧？
初学angular，请教高手…… |
|
g********d
发帖数: 4174 | 38 I am using MikTex with graphics package installed using the following way:
In preamble put:
\usepackage{graphics}
To import graphic (jpg) use:
\begin{center}
\resizebox{!}{300pt} % resize the image automatic width and 100pt height
{\includegraphics{figure1}}
\end{center}
But I got the error message" File 'graphics.sty' not found". Could somebody
please help me? Thanks. |
|
e*********s
发帖数: 200 | 39 1. export/import
or
2. grab your old .PST file and add to your new outlook data file list
大 |
|
l******9
发帖数: 579 | 40 I need to export XML to XML by EXCEL 2010 in Win 7. I import XML file to
EXCEL 2010, then I need to make some changes and then export the changed XML
files.
I got the problem:
"Cannot save or export XML data. The XML maps in this workbook are not
exportable."
My question is simialr as
excel: Cannot save or export xml data. The xml map in this workbook are not
exportable
But, only the reasons for the problem are given there, no solutions. I am
new to XML.
Thanks |
|
l******9
发帖数: 579 | 41 I need to export XML to XML by EXCEL 2010 in Win 7. I import XML file to
EXCEL 2010, then I need to make some changes and then export the changed XML
files.
I got the problem:
"Cannot save or export XML data. The XML maps in this workbook are not
exportable."
My question is simialr as
excel: Cannot save or export xml data. The xml map in this workbook are not
exportable
But, only the reasons for the problem are given there, no solutions. I am
new to XML.
Thanks |
|
m********s
发帖数: 35 | 42 The 2nd most important question is that which companies are willing to
entertain the idea of petitioning PERM for you sooner?
You just can't stay on H1B forever...It's a whole world of relief when you
get that little piece of plastic... |
|
t*****3
发帖数: 878 | 43 我把sdc.xls文件已经UPLOAD到/SASTEMP1/TEMP123的目录里去了，然后在程序中我写
1. rsubmit;
Proc import data='/sastemp1/temp123/sdc.xls' output=sdc replace;
为何SAS总显示"server name is invalid or missing" ?? |
|
l*****n
发帖数: 76 | 44 regression 是这样的
R2=a+b*R1+c*V*R1+error
如何show the economic importance of the coefficient c on the interaction
term?
mean of V=0; mean of R1 =0
可以比较the difference in the values of R2 between the case where V is one
standard deviation above its mean and R1 is one standard deviation above its
mean and the benchmark case where V=0 and R1 is one standard deviation
above its mean吗 |
|
l*****n
发帖数: 76 | 45 regression 是这样的
R2=a+b*R1+c*V*R1+error
如何show the economic importance of the coefficient c on the interaction
term?
mean of V=0; mean of R1 =0
可以比较the difference in the values of R2 between the case where V is one
standard deviation above its mean and R1 is one standard deviation above its
mean and the benchmark case where V=0 and R1 is one standard deviation
above its mean吗 |
|
j*w
发帖数: 60 | 46 Thanks. Could you eleaborate how to calculate the inserting point in CAD
using pixels? Also, there are scaling issues, which possibly also affected
by pixel. One interesting thing is that I can import the images (with TFW
file) into ArcGIS without any problem. |
|
m*l
发帖数: 507 | 47 If you have Civil 3D/Map 3D, the easiest way is to use civil 3D to import
the TIF. Then open it in AutoCAD.
Otherwise, you have to do the math. Read the TWF file format in ArcGIS help
and the rest is just simple coordinate transformation. |
|
