T4
发帖数: 273 | 1 RMAN> run {
2> set until time "to_date('12-24-2011 12:05:00','mm-dd-yyyy hh24:mi:ss')";
3> restore database;
4> recover database;
5> }
Error:
creating datafile fno=1 name=/data/oradata/myhost/datafile/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/28/2011 23:39:20
ORA-0118... 阅读全帖 |
|
T4
发帖数: 273 | 2 RMAN> run {
2> set until time "to_date('12-24-2011 12:05:00','mm-dd-yyyy hh24:mi:ss')";
3> restore database;
4> recover database;
5> }
Error:
creating datafile fno=1 name=/data/oradata/myhost/datafile/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/28/2011 23:39:20
ORA-0118... 阅读全帖 |
|
|
n******s
发帖数: 7 | 4
character(len=80)::buf
character(len=8)::fmtstr="(??f4.2)"
integer::n,i
integer::datafile
open(unit=datafile,file="...",...)
read(unit=datafile,fmt="(a80)")buf ! read entire record into buf
n=len_trim(buf)/4 ! how many numbers? (4 chars per number)
write(unit=fmtstr(2:3),fmt='(i2)')n ! dynamically change format
read(unit=buf,fmt=fmtstr)(x(i),i=1,n,1) ! internal file read, like sscanf()
close(unit=datafile)
Also take a look at the : edit descriptor in a good Fortran book.
If you read 1234 using |
|
f********t
发帖数: 74 | 5 I don't think you understand tablespace correctly. tablespaces are used to
organize the datafiles. One datafile can belong to only one tablespace,
while a tablespace can have many datafiles. It is one of the logic structure of the database. A tablespace is not a database and it is not eual to schema either.
You can make a tablespace read only by using ALTER TABLESPACE command.
If you have not created myjunktable, it does not exist for sure.
CREATE USER command should work fine. |
|
b*****o
发帖数: 284 | 6 Use a package called "DataFile"
The following is a sample
// Creating a reader for CSV file using ISO-8859-1
DataFile read = DataFile.createReader("8859_1");
read.setDataFormat(new CSVFormat());
try {
read.open(new File("/data/test.csv"));
for (DataRow row = read.next(); row != null; row = read.next()) {
String text = row.getString(0);
int number1 = row.getInt(1, 0);
double number2 = row.getDouble(2);
// use the retrieved data ...
}
}
finally { |
|
p********a
发帖数: 5352 | 7 options obs=max;
proc import datafile="C:\SAS Projects\Stock analysis\NYSE_symbols.xls" out=
NYSE dbms=excel2000 replace;
getnames=Yes;
run;
proc import datafile="C:\SAS Projects\Stock analysis\AMEX_symbols.xls" out=
AMEX dbms=excel2000 replace ;
getnames=Yes;
/*guessingrows=20;*/
run;
proc import datafile="C:\SAS Projects\Stock analysis\NASQ_symbols.xls" out=
NASQ dbms=excel2000 replace;
getnames=Yes;
run;
data TICK;
set NASQ(in=a) NYSE(in=b) AMEX(in=c);
if a then Srce="NASQ";
else if b then Sr |
|
x***1
发帖数: 22 | 8 ３１：
Item 31 of 70 Mark item for review
Given the following raw data records in DATAFILE.TXT:
----|----10---|----20---|----30
Kim,Basketball,Golf,Tennis
Bill,Football
Tracy,Soccer,Track
The following program is submitted:
data WORK.SPORTS_INFO;
length Fname Sport1-Sport3 $ 10;
infile 'DATAFILE.TXT' dlm=',';
input Fname $ Sport1 $ Sport2 $ Sport3 $;
run;
proc print data=WORK.SPORTS_INFO;
run;
答案： C.
Obs Fname Sport1 Sport2 Sport3
1 Kim B... 阅读全帖 |
|
|
|
h***n
发帖数: 83 | 11 http://fangzhouzi.baijia.baidu.com/article/11677
美国人以转基因玉米为主食的铁证
方舟子04月14日 10:00 分享到： 转基因 玉米 分类 : 热点
摘要 : 说来可笑，这个证据还是由美国一家反对转基因食品的快餐连锁店提供的。
美国种植的玉米中转基因品种所占的比例逐年增加，到2013年美国玉米的90%是转基因
的品种。反转控没法否定这个事实，就狡辩说，转基因玉米在美国是当饲料和工业用的
，不是供人吃的。此前我已写了两篇文章驳斥这个说法：《“美国人不吃转基因玉米”
的谣言可休矣》、《再说说美国人吃不吃转基因玉米》（附后）。最近又发现了直接的
证据，证明美国人不仅吃转基因玉米，而且还以转基因玉米为主食。
说来可笑，这个证据还是由美国一家反对转基因食品的快餐连锁店提供的。这家快餐连
锁店叫Chipotle，经营墨西哥餐，在美国有1000多家分店。墨西哥餐以玉米面为主食，
主要有两种，一种叫taco，用脆或软的玉米面薄饼半裹着馅吃，一种叫burrito，用玉
米面薄饼卷着馅吃，不过现在大型连锁店卖的burrito通常改用小麦面粉薄饼。此外，
... 阅读全帖 |
|
f******u
发帖数: 250 | 12 (导入数据)
proc import out=aapl
datafile="C:\Users\aapl.xlsx"
dbms=xlsx replace;
sheet="sheet1";
getnames=yes;
run;
proc import out=spy
datafile="C:\Users \spy.xlsx"
dbms=xlsx replace;
sheet="sheet1";
getnames=yes;
run;
(筛选数据)
data aapl;
set aapl(keep=date adj_close);
label adj_close="Aclose";
rename adj_close=Aclose;
run;
data spy;
set spy(keep=date adj_close);
label adj_close="Sclose";
rename adj_close=Sclose;
run;
(整理数据)
proc sort data=spy;by descending date;run;
proc sort data=aapl;by descendin... 阅读全帖 |
|
L******k
发帖数: 33825 | 13 PROC IMPORT DATAFILE='C:\Users\best\Desktop\SAS 2\DrugAB.xls' OUT=DrugAB
DBMS=EXCEL REPLACE;
RUN;
PROC IMPORT DATAFILE='C:\Users\best\Desktop\SAS 2\DRUGABinfo.xls' OUT=
DRUGABinfo DBMS=EXCEL REPLACE;
RUN; |
|
c******n
发帖数: 4965 | 14 【 以下文字转载自 Linux 讨论区 】
【 原文由 creation 所发表 】
input trash.mp
beginfig(1)
draw begingrf(5in,4in);
rdata("datafile",1);
rdata("datafile",2);
rdata("data2",1);
rdata("data2",2);
matplot("0 1 cg ddash t*");
matplot("2 3 cr ddot tx");
ylabel("blahblah");
xlabel("red is sqrt(x)*1000, green is sqr(x)");
finishgrf; endfig;
end |
|
m******g
发帖数: 91 | 15 thx... just follow their tips (#54) to build Oracle8.1.7 on Mandrake8.1,
but still have this error even I've unset LANG:
[oracle@yw216 Disk1]$ unset LANG
[oracle@yw216 Disk1]$ ./runInstaller
[oracle@yw216 Disk1]$ Initializing Java Virtual Machine from ../stage
/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/bin/jre.
Please wait...
/home/oracle/Disk1/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded
/linux/bin/linux/native_threads/jre: error while loading shared libraries:
li |
|
s***m
发帖数: 28 | 16 I am trying to export a production oracle database schema of a tablespace to a
test system. However, I have limited space on test system. On production
system, many data files are created for different indexes and tables. These
datafile is created using large disk spaces. How can I export the production
tablespace schema but with smaller datafile size definition?
Thanks |
|
s***m
发帖数: 28 | 17 Yes, I want to import full database schema from production system to test
system. However, I don't want to import any of the data. I just need the
tablespace definition, trigger, storedproc, functions and constraints. Owing
to the production system's size, at which many datafiles has been created for
userspace and index space, my export captures the size of the those index
datafiles. If you have a documention on how to do this, it will be very
helpful.
Thanks
test
before
to
These
production |
|
s***m
发帖数: 28 | 18 I knew about rows parameter in exp command. The issue is different. I set to
export only table definition, however, all table definitions live on large
datafile. I don't want to export definition of large datafile. How can I do
that?
Owing
the
production |
|
z******4
发帖数: 4716 | 19 数据库结构
加入同学们，上面都熟悉了，简单SQL会写了，那么下面要稍微深入数据库学习了，这
段，我们来学习数据库结构，记住，同学们都要熟悉背住这些名词，面试必备啊，不会
的话，肯定完蛋
前面，我们用Excel创建了一个简单初级数据库，哪实际的数据库哪，当然不会那么简单
我们来看这个图
一步步来，先看最底下一层
Data files
好了，我前面指出一个excel文件就像一个tablespace，什么是tablespace哪，就是这
些表都在这个tablespace里面
哪我又十几个excel文件，是不是会有十几个tablespace，是的，一般一个tablespace
会建在一个datafile里面
，哪一般oracle数据库在创建时会有几个data file哪
system
user
temp
redo
好了，你发现，你的头脑开始糊涂了吧，这些datafile 妈的和excel到底有什么关系
举例，user data file 里面可以创建user1 tablespace，user2 tablespace,每个
tablespace就相当于一个excel文件
简化的意思，这些data... 阅读全帖 |
|
a****l
发帖数: 120 | 20 最近公司打算把数据从windows single instance 迁移到linux RAC，我以前用过expdp
/impdp是可行的，但是比较麻烦，需要在target database，建立tablespace，
datafile，role，user等。
但是我觉得rman更可靠，所以我想用duplicate rman backup；不过问题是每次都出错
。。。
因为问题在于
windows single instance -> linux RAC
要考虑转码，datafile文件存储位置不同，如ASM
请问，各位有过经验吗？我暂时只想到
如果非要rman duplicate，那么可以
windows single instance -> linux single instance -> linux RAC
我实在不知道怎么直接从windows single instance -> linux RAC；还希望各位老师，
多多帮忙，如果有link或者经验，就更好了。
非常感谢。 |
|
b*****r
发帖数: 239 | 21 You can convert to linux rac directly if you already have GI installed and
have shared storage available.
In step 1, you got the converted datafiles from windows, copied to shared
storage in you RAC environment.(you need step2 if you want to use ASM).
Since you got all datafiles, you can adjust the script generated during rman
convert to create control file for RAC. Also change the original spfile to
make it RAC ready. |
|
d******i
发帖数: 7160 | 22 输入重定向(getline)
getline 函数用来从标准输入，例如管道或者文件来读入数据，而不是
从正被处理的当前文件。getline 取得输入的下一行，并更新NF、NR
和FNR等内置变量的值。如果getline找到记录则返回1，达到EOF（文
件结束）则返回0。如果有错误则返回-1。
—
举例1：
$ nawk 'BEGIN{"date"|getline d;print d}' datafile
2005年05月06日 星期五 15时05分41秒 CST
解释：执行date命令，然后把输出从管道送到getline，并赋给自
定义变量d，然后打印d。
— 举例2：
$nawk 'BEGIN{while("ls"|getline) print}'
awk.sc2
datafile
datafile2
employees
employees2
lab5.data
names
passwd
解释：将把ls的输出送到getline。对于每次循环，getline都从
ls读取一个以上输出，然后打印到屏幕上
好像getline不认得，运行不了。 |
|
W***o
发帖数: 6519 | 23 我有一个csv文件，里面有多行多栏的数据，我想把这些数据通过3D surface plot表述
出来(x轴坐标就用第一列每行的cell 内容,比如Log1, Log2...; y轴就用第一行的cell
content (Sample1, Sample2 ...)，z就用下面表格里的数据。我想到用matplotlib，
但是又不太会用，想请教一下。
Measure＃ Sample1 Sample2 Sample3 Sample4 Sample5
Log1 2.3 3.3 4.5 5.6 6.7
Log2 3.5 6.7 10.0 22.1 30
Log3 4.2 4.5 6.7 8.9 9.1
Log4 4.5 8.9 10.2 11.8 14.7
import csv
from matplotlib import pyplot as plt
import pylab
import numpy as np
from mpl_toolkits.mplot3d import Axes3D
csv_file_path='/path/to/my/C... 阅读全帖 |
|
s*********e
发帖数: 97 | 24 use gnuplot (it is free software):
if the your matrix is in a datafile
plot "datafile" using 1:2 w l
or U can use octave (free and compatiable with matlab)
a=[1,2;3,4;5,6];# your 2 column matrix
plot (a(1:end,1),a(1:end,2)) |
|
a*****n
发帖数: 40 | 25 请大家帮忙看看我的程序哪里出了错，run不出来了。文件名叫project。
log里一堆看不懂的东西。多谢了。
proc import datafile="C:\project.xls"
out =project1 dbms=excel;
sheet= "project1";
run;
Proc means data = project1;
by name;
var GP margin;
run;
proc print;
run;
1845 proc import datafile="C:\project.xls"
1846 out =project1 dbms=excel;
1847 sheet= "project1";
1848 run;
ERROR: File _IMEX_.'project1$'n.DATA does not exist.
ERROR: Import unsuccessful. See SAS Log for details.
NOTE: The SAS System stopped processing this step because of |
|
s*******f
发帖数: 148 | 26
~~~~~~~~~当中多了个空格，datafile
顺便，log里已经告诉你错在哪里，也提示你应该是datafile。
以后run不出来可以先看看log怎么报错。 |
|
l**********s
发帖数: 255 | 27 我可以用如下的code分别打开三个excel文件 ，但是如何同时打开它们呢？实际上我有
上百个excel文件需要打开，是否可以用同一个简短的code同时打开它们呢？多谢！
PROC IMPORT OUT= WORK.a1
DATAFILE= "h:\a1.xls"
DBMS=EXCEL REPLACE;
SHEET="sheet1";
GETNAMES=YES;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;
PROC IMPORT OUT= WORK.a2
DATAFILE= "h:\a2.xls"
DBMS=EXCEL REPLACE;
SHEET="sheet1";
GETNAMES=YES;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN; |
|
EA
发帖数: 3965 | 28 proc import datafile='c:\tab1.xls' out=tab1;
run;
proc import datafile='c:\tab2.xls' out=tab2;
run;
data all;
set tab1 tab2;
run; |
|
x*******u
发帖数: 500 | 29 谢谢大家的帮助， 最后是SAS Technical Support 解决了问题。
It looks like you may have a Unicode file that has a hex '00' between each
character. Are you using PROC IMPORT to read the file? Use a FILENAME
statement to create a fileref for the file you want to read. On the
FILENAME statement add the ENCODING=UNICODE option. Then in the PROC IMPORT
, use DATAFILE=.
For example,
filename temp 'c:\temp\qualityinfo.csv' encoding="unicode" lrecl=32767;
proc import datafile=temp out=quality dbms=csv ... 阅读全帖 |
|
W*****r
发帖数: 193 | 30 用各个csv的id合并起来
简单的的我知道怎么做
比如
proc import datafile="D:file1.csv"
out=new1 dbms=csv replace; getnames=yes;
run;
proc print data=new1;
run;
proc import datafile="D:file2.csv"
out=new2 dbms=csv replace; getnames=yes;
run;
proc print data=new2;
run;
data dn;
merge new1 new2;
by id;
run;
文件“dn”含new1 和 new2的所有variables, 使用公用的id
问题是，如果csv files很多怎么办？比如100+？
可不可以用proc sql + Macro做出来？
怎么做？
多谢。 |
|
t****n
发帖数: 10724 | 31 要木你的机子快.
下载datafile就２－３个小时，
下载WINZIP，安装
下载SQL server， 安装。
恢复。
除非你什么都有了，直接恢复数据库。
不要吹牛，你完全不懂数据你，一个小时你连皮毛也搞不定 |
|
|
w*********r
发帖数: 42116 | 33 http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/margin.html
这个有研究。按行业分，Gross Margin最高的是Bank (Money Center) 100.00%，其次
是Banks (Regional) 99.77%。接下来是
Financial Svcs. (Non-bank & Insurance) 81.50%
Drugs (Biotechnology) 72.99%
Drugs (Pharmaceutical) 70.96%
Investments & Asset Management 69.81%
Software (Entertainment) 66.18%
Software (Internet) 66.93%
Software (System & Application) 66.61%
R.E.I.T. 61.96%
Cable TV 60.80% |
|
|
|
|
|
N******s
发帖数: 10555 | 38 ☆─────────────────────────────────────☆
hotmail99 (Nancy) 于 (Wed Jun 8 01:50:56 2016, 美东) 提到:
今天虽然创了新低，但是却收在了上次最低点的上方，而且量还不小。看来最坏的已经
过去了，花街早就料到，开始扫货了，继续下跌的可能不大。就算按照他们修正后的
EPS guidance $7来算，医药界平均的P/E ratio也是32左右（VRX应该是业界的领先者
了,用平均值来算应该已经很保守了），所以理论上VRX“应该”是200以上的股票的，可
是现在P/E ratio才4都不到，严重低估了10倍呀，这就是Ackman坚信自己投资的原因。
除非是VRX有fraud（现在看来已经排除这种可能）, 要不就是花街的那套价值理论出了
问题，否则，VRX怎么看都不应该是只20多块钱的股票。退一万步来看，让我们忘记VRX
是一只200的股票（可能一两年内回不去了），但一只$30以下的股票with EPS $7,你认
为合理吗？如果这个比例合理的话，花街上绝大多数的上市公司可以关门大吉了，股票
也就失去了... 阅读全帖 |
|
|
s*******t
发帖数: 1 | 40 Get a bounch of data in HTML and PDF.
How can I change it into text file? |
|
o**n
发帖数: 14 | 41 the associated datafile was deleted accidentally, |
|
o**n
发帖数: 14 | 42 because the datafile was deleted, can't drop it that way. |
|
m****a
发帖数: 2 | 43 try this:
select tablespace_name,file_name,status from dba_data_files;
if the datafiles you deleted still shows "AVILABLE"
you need to do this for each of those files:
alter database data file 'filename' offline;
then you can do
drop tablespace tablespacename. |
|
l***r
发帖数: 459 | 44 I check our current database. All datafile is around 1.5GB but each archive
file is around 100MB. I wonder if archive file contains all data information?
I am new to oracle backup/recovery.
Thanks in advance! |
|
y********o
发帖数: 2565 | 45 Thanks and yes, I don't know what exactly tablespace is.
Also, I am only interested in creating users who have read only permissions
on all tables. I am not interested in creating read-only tables/datafiles/
tablespaces per se.
Can you share some of your wisdom please? |
|
y********o
发帖数: 2565 | 46 没有inventory目录，但是在
C:\Documents and Settings\Owner\Local Settings\Temp\OraInstall2008-02-17_01-
14-49PM
下面有这个log 文件：
installActions2008-02-17_01-14-49PM.log
内容如下：
Using paramFile: D:\software\win32_11gR1_database\database\install\oraparam.
ini
Checking monitor: must be configured to display at least 256 colors. Actu
al 4294967296 Passed
The commandline for unzip:
D:\software\win32_11gR1_database\database\install\unzip -qqqo ..\stage\Compo
nents\oracle.jdk\1.5.0.1.1\1\DataFiles/"*.jar" -d "C |
|
w*******e
发帖数: 1622 | 47 首先, 俺是Oracle新手哈...问啥stupid的问题表笑.....
在Oracle中, whole database backup里, 都有什么被backup了?
我在backup folder里看到: 文件名乱七八糟的两files.
看了看Oracle说明, 好象有datafiles, redo log, spfile and control files. (是不
是应该有四个backup的file呢?)
问这个问题是因为更大的一问题:
比如我现在有那个whole database backup files(两个), 如果这时我的机器坏了, 我
怎么来restore from those two files呢? 就是在我install了OS和Oracle software后
, 怎么做? 能不能详细点?? 谢谢....(看website好象只有recover单个tablespace和
table什么的) |
|
B*****g
发帖数: 34098 | 48 虽然我没试过，不过copy datafile应该行。
当然, expdp肯定行, 没有上面快。 |
|
a*****o
发帖数: 136 | 49 what's your oracle version? 9i/10g/11g?
Use RMAN's duplicate database command,
Here is an example,
http://www.mcs.csueastbay.edu/support/oracle/doc/10.2/backup.102/b14191/rcmdupdb005.htm#i1009381
Example 13-3 Duplicating When Datafiles Use Inconsistent Paths
CONNECT TARGET /;
CONNECT CATALOG rman/cat@catdb;
CONNECT AUXILIARY SYS/oracle@dupdb;
# note that a RUN command is necessary because you can only execute SET
NEWNAME
# within a RUN command
RUN
{
# The DUPLICATE command uses an automatic s |
|
m***b
发帖数: 265 | 50 mysql innodb ： 目前 datafiles 是在一个文件里（ ibdata1） ，如何将目
前的表转换为 one file per table 的文件格式 ？ |
|
