usebbed(BBED-00200:invalidkeyword(file))-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

usebbed(BBED-00200:invalidkeyword(file))

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:06 PM

[oracle@ogg1 lib]$ cat filelist.txt 4 /opt/oracle/oradata/orcl11g/users01.dbf
3 /opt/oracle/oradata/orcl11g/undotbs01.dbf
2 /opt/oracle/oradata/orcl11g/sysaux01.dbf
1 /opt/oracle/oradata/orcl11g/system01.dbf
5 /opt/oracle/oradata/orcl11g/zbdba.dbf
6 /opt/oracle/oradata/orcl11g/zbdba01.dbf
7 /opt/oracle/oradata/orcl11g/test.dbf
[oracle@ogg1 lib]$ cat par.txt
blocksize=8192
listfile=filelist.txt
mode=edit

SYS@orcl11g>select rowid,dbms_rowid.rowid_object(rowid) robject,
2 dbms_rowid.rowid_relative_fno(rowid) fno,
3 dbms_rowid.rowid_block_number(rowid) bno,
4 dbms_rowid.rowid_row_number(rowid) rno from scott.emp where rownum=1;

ROWID ROBJECT FNO BNO RNO
------------------ ---------- ---------- ---------- ----------
AAAR3xAAEAAAACXAAB 73201 4 151 1

SYS@orcl11g>SYS@orcl11g>select * from scott.emp
2 ;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- -------------------- ------------------ ---------- ------------ ---------- ---------- ----------
7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30
7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30
7566 JONES MANAGER 7839 02-APR-81 2975 20
7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30
7698 BLAKE MANAGER 7839 01-MAY-81 2850 30
7782 CLARK MANAGER 7839 09-JUN-81 2450 10
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7839 KING PRESIDENT 17-NOV-81 5000 10
7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30
7876 ADAMS CLERK 7788 23-MAY-87 1100 20
7900 JAMES CLERK 7698 03-DEC-81 950 30
7902 FORD ANALYST 7566 03-DEC-81 3000 20
7934 MILLER CLERK 7782 23-JAN-82 1300 10

[oracle@ogg1 lib]$ bbed parfile=par.txt
Password:

BBED: Release 2.0.0.0.0 - Limited Production on Wed Oct 22 07:46:19 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

************* !!! For Oracle Internal Use only !!! ***************
BBED>
BBED> set file 4 block 151
FILE# 4
BLOCK# 151

BBED> map
File: /opt/oracle/oradata/orcl11g/users01.dbf (4)
Block: 151 Dba:0x01000097
------------------------------------------------------------
KTB Data Block (Table/Cluster)

struct kcbh, 20 bytes @0

struct ktbbh, 72 bytes @20

struct kdbh, 14 bytes @100

struct kdbt[1], 4 bytes @114

sb2 kdbr[14] @118

ub1 freespace[7475] @146

ub1 rowdata[567] @7621

ub4 tailchk @8188
BBED>
BBED>
BBED> p *kdbr[0]
rowdata[529]
------------
ub1 rowdata[529] @8150 0x3c

BBED> x /rn
rowdata[529] @8150
------------
flag@8150: 0x3c (KDRHFL, KDRHFF, KDRHFD, KDRHFH)
lock@8151: 0x02
cols@8152: 0
BBED> p *kdbr[1]
rowdata[486]
------------
ub1 rowdata[486] @8107 0x2c

BBED> x /rn
rowdata[486] @8107
------------
flag@8107: 0x2c (KDRHFL, KDRHFF, KDRHFH)
lock@8108: 0x00
cols@8109: 8

col 0[3] @8110: 7499
col 1[5] @8114: #########################################
col 2[8] @8120: #########################################
col 3[3] @8129: 7698
col 4[7] @8133: #########################################
col 5[2] @8141: 1600
col 6[2] @8144: 300
col 7[2] @8147: 30

BBED> p *kdbr[2]
rowdata[443]
------------
ub1 rowdata[443] @8064 0x2c

BBED> x /rn
rowdata[443] @8064
------------
flag@8064: 0x2c (KDRHFL, KDRHFF, KDRHFH)
lock@8065: 0x00
cols@8066: 8

col 0[3] @8067: 7521
col 1[4] @8071: #########################################
col 2[8] @8076: #########################################
col 3[3] @8085: 7698
col 4[7] @8089: #########################################
col 5[3] @8097: 1250
col 6[2] @8101: 500
col 7[2] @8104: 30

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Adding Users to MySQL: The Complete TutorialMay 12, 2025 am 12:14 AM

Mastering the method of adding MySQL users is crucial for database administrators and developers because it ensures the security and access control of the database. 1) Create a new user using the CREATEUSER command, 2) Assign permissions through the GRANT command, 3) Use FLUSHPRIVILEGES to ensure permissions take effect, 4) Regularly audit and clean user accounts to maintain performance and security.

Mastering MySQL String Data Types: VARCHAR vs. TEXT vs. CHARMay 12, 2025 am 12:12 AM

ChooseCHARforfixed-lengthdata,VARCHARforvariable-lengthdata,andTEXTforlargetextfields.1)CHARisefficientforconsistent-lengthdatalikecodes.2)VARCHARsuitsvariable-lengthdatalikenames,balancingflexibilityandperformance.3)TEXTisidealforlargetextslikeartic

MySQL: String Data Types and Indexing: Best PracticesMay 12, 2025 am 12:11 AM

Best practices for handling string data types and indexes in MySQL include: 1) Selecting the appropriate string type, such as CHAR for fixed length, VARCHAR for variable length, and TEXT for large text; 2) Be cautious in indexing, avoid over-indexing, and create indexes for common queries; 3) Use prefix indexes and full-text indexes to optimize long string searches; 4) Regularly monitor and optimize indexes to keep indexes small and efficient. Through these methods, we can balance read and write performance and improve database efficiency.

MySQL: How to Add a User RemotelyMay 12, 2025 am 12:10 AM

ToaddauserremotelytoMySQL,followthesesteps:1)ConnecttoMySQLasroot,2)Createanewuserwithremoteaccess,3)Grantnecessaryprivileges,and4)Flushprivileges.BecautiousofsecurityrisksbylimitingprivilegesandaccesstospecificIPs,ensuringstrongpasswords,andmonitori

The Ultimate Guide to MySQL String Data Types: Efficient Data StorageMay 12, 2025 am 12:05 AM

TostorestringsefficientlyinMySQL,choosetherightdatatypebasedonyourneeds:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseTEXTforlong-formtextcontent.4)UseBLOBforbinarydatalikeimages.Considerstorageov

MySQL BLOB vs. TEXT: Choosing the Right Data Type for Large ObjectsMay 11, 2025 am 12:13 AM

When selecting MySQL's BLOB and TEXT data types, BLOB is suitable for storing binary data, and TEXT is suitable for storing text data. 1) BLOB is suitable for binary data such as pictures and audio, 2) TEXT is suitable for text data such as articles and comments. When choosing, data properties and performance optimization must be considered.

MySQL: Should I use root user for my product?May 11, 2025 am 12:11 AM

No,youshouldnotusetherootuserinMySQLforyourproduct.Instead,createspecificuserswithlimitedprivilegestoenhancesecurityandperformance:1)Createanewuserwithastrongpassword,2)Grantonlynecessarypermissionstothisuser,3)Regularlyreviewandupdateuserpermissions

MySQL String Data Types Explained: Choosing the Right Type for Your DataMay 11, 2025 am 12:10 AM

MySQLstringdatatypesshouldbechosenbasedondatacharacteristicsandusecases:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseBINARYorVARBINARYforbinarydatalikecryptographickeys.4)UseBLOBorTEXTforlargeuns

See all articles