RE: Ghost Data
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: Julio Aguilar-Chang <jachang@xxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 30 Jun 2009 16:35:36 -0700
It was application data - sales orders, customers, etc. Here is a script of
the exact steps I executed, including a small sample of the unexpected data I
found in the datafile:
SQL_test01>CREATE TABLESPACE "BATEST" DATAFILE
'/testdb/develop/test01/oradat/batest.dbf' SIZE 128K AUTOEXTEND ON NEXT 128K
MAXSIZE 1M LOGGING EXTENT MANAGEMENT LOCAL;
Tablespace created.
SQL_test01>create table batab(col1 number, col2 char(10), col3 date) tablespace
batest;
Table created.
SQL_test01>host
hp50c.test01 /testdb/develop/test01/oradat ->strings batest.dbf
Z[\]
TEST01
BATEST
hp50c.test01 /testdb/develop/test01/oradat ->exit
SQL_test01>insert into batab values (1,'BA Row 1',sysdate);
1 row created.
SQL_test01>host
hp50c.test01 /testdb/develop/test01/oradat ->strings batest.dbf
Z[\]
TEST01
BATEST
hp50c.test01 /testdb/develop/test01/oradat ->exit
SQL_test01>commit;
Commit complete.
SQL_test01>host
hp50c.test01 /testdb/develop/test01/oradat ->strings batest.dbf
Z[\]
TEST01
BATEST
hp50c.test01 /testdb/develop/test01/oradat ->exit
SQL_test01>alter system checkpoint;
System altered.
SQL_test01>exit
hp50c.test01 /testdb/develop/test01/oradat ->strings batest.dbf
Z[\]
TEST01
BATEST
14159.003 (<-- this data and all below except the last line were
never entered into any table in this tablespace!)
LABCORP337
INSTALLATION
Installation Services
DEFAULT
SERVICES
DFLT
BKIMBAL2
. . .
BA Row 1 (<-- here is the only data I actually entered)
From: Julio Aguilar-Chang [mailto:jachang@xxxxxxxx]
Please explain "it had a bunch of data from other database tables in it". Is
this other data actual "application" data, not just data dictionary data?
________________________________
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
Other related posts:
