Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rastorin

    Must reduce size of temp01.dbf.... but how??

    I believe that this datafile belongs to its tablespace would temporaria, and affirmative case executes the following command: alter tablespace temp default storage(pctincrease 0);
  2. rastorin

    Find Table Structure

    Hi !!! Try this select, SELECT substr(a.COLUMN_ID, 1, 3), substr(a.TABLE_NAME, 1, 30), substr(a.COLUMN_NAME, 1, 30), substr(a.DATA_TYPE, 1, 10), LPAD(DECODE(a.DATA_PRECISION,'',TO_CHAR(a.DATA_LENGTH), TO_CHAR(a.DATA_PRECISION)||'.'||TO_CHAR(a.DATA_SCALE)), 6)...
  3. rastorin

    Optimizer hint not working properly

    HI !!! Try this: CREATE BITMAP INDEX index-name ON table (....) COMPUTE STATISTICS PARALLEL; Renato,
  4. rastorin

    sqlldr - record terminator as '¦' and not 'linefeed' or 'new line'

    HI !!! Try this commands in control file: LOAD DATA INFILE 'yuor_directory_file_reload' APPEND INTO TABLE yuor_table_name FIELDS TERMINATED BY '|' ( lg_refnum, .... ... )

Part and Inventory Search

Back
Top