em Datentyp VARCHAR2 und der Byte Längen Angabe ("data_length" in der dba_tab_columns ) von **10** erst... .TABLE_NAME
, col.COLUMN_NAME
, col.DATA_TYPE
, col.CHAR_COL_DECL_LENGTH -- Declar... length of the character type column
, col.DATA_LENGTH -- Length of the column (in byte... on (tab.TABLE_NAME = col.TABLE_NAME)
WHERE col.data_type='VARCHAR2'
</code>
Der sqlplus "describe"
===== Oracle Data Pump Schema Export und Import =====
==== Übersicht ====
siehe über Slideshare:
[s... tory.sql|directory.sql]]
Passendes Directory wie DATA_PUMP_DIR auswählen, Dateipfad prüfen, auf ausreic... de bash>
vi ~/full_export_GPIDB1.dpctl
DIRECTORY=DATA_PUMP_DIR
LOGFILE=expdp_08-08-2013_19_49_GPIDB1.l... "drop user xxxx cascade;" zu löschen und neu mit Data Pump anzulegen verzichtet.
Alle Objekte in den z
* EasySoft - https://www.easysoft.com/products/data_access/odbc_oracle_driver/index.html
* Microsof... MSSQL01_ODBC_DSN
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver spec... OTOCOL=TCP)(HOST=racdb01)(PORT=2011))
(CONNECT_DATA= (SID=MSSQL01))
(HS=OK)
)
# als user oracle... OTOCOL=TCP)(HOST=racdb01)(PORT=2011))
(CONNECT_DATA= (SID=MSSQL01))
(HS=OK)
)
</code>
==DB Link
ias
Attempting to contact
(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=SRV_PROD))
(ADDRESS=(PROTOCOL=tcp)(... lias
Attempting to contact
(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=SRV_PROD)(INSTANCE_NAME=gpi01))
(AD
Script to gives how much TIMESTAMP WITH TIME ZONE data there is in a database using stats info.
@?/rdbms/admin/utltz_countstats.sql
..
Amount of TSTZ data using num_rows stats info in DBA_TABLES.
..
--=>... to approximate how much TIMESTAMP WITH TIME ZONE data there is in a database using a COUNT(*) for each ... tltz_countstar.sql
..
Estimating amount of TSTZ data using COUNT(*).
..
SYS.XS$PRIN.START_DATE - 15
Textes?
{{ :dba:oracle_text:oracle_text_insert_data_v01.png?500 | Oracle Text - Was passiert beim ein... gespeichert und indiziert, Siehe => [[prog:python_data_loader_oracle_bfile_text_index|Mit Python Referen... .exe d:\doag\apex_connect2016.pptx d:\temp\output_data.html
</code>
Mehr Informationen dazu siehe [[dba:oracle_text_index_binary_data|Oracle Text für die Indizierung binärer Daten ver
ieren falls noch nicht vorhanden
yum install perl-Data-Dumper.x86_64
yum install perl-Digest-MD5
# Data Location anlegen
mkdir /opt/oracle/ahf
</code>
Vo... lation mit **./ahf_setup [-ahf_loc install_dir] [-data_dir data_dir]** durchführen.
Die anderen Knoten im Cluster werden dann automatisch installiert!
Defau
OCOL=TCP)(HOST=10.10.10.10.1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=gpidb)))" -upload... ROTOCOL=TCP)(HOST=10.10.10.1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=gpidb)))
orachkc... blem: MEMORYCRUNCH: Does not have enough space in data base to process collection...exiting. ===
**Ursa... ext(''MEMORYCRUNCH: Does not have enough space in data base to process collection...exiting.'',collectio