Toad World® Forums

number of columns limit in nav 6.7


From the “yes this is pretty crazy to expect department”

Oracle’s hard limit of # of columns is 1000 columns. Oracle let me add them, didn’t hit bug in SSDEV but table is empty so that may be why it did not corrupt. SQLNAV cannot handle a select * at least not on my machine, I can still see the data but have to explicitly select a subset of the columns. **** SCRIPT STARTED Session: (1) 18-Apr-2013 17:02:33 select * from gpadmin.stage_split==>line 2: Out of memory-------------------------------------------------------------------------------- SCRIPT ENDED 18-Apr-2013 17:02:33 ****^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

**** SCRIPT STARTED Session: 18-Apr-2013 17:03:46 ****
SELECT a.file_id, a.record_number, a.data_type, a.c001, a.c002, a.c003, a.c004, a.c005, a.c006, a.c007, a.c008, a.c009, a.c010, a.c011, a.c012, a.c013, a.c014, a.c015, a.c016, a.c017, a.c018, a.c019, a.c020, a.c021, a.c022, a.c023, a.c024, a.c025, a.c026, a.c027, a.c028, a.c029, a.c030, a.c031, a.c032, a.c033, a.c034, a.c035, a.c036, a.c037, a.c038, a.c039, a.c040, a.c041, a.c042, a.c043, a.c044, a.c045, a.c046, a.c047, a.c048, a.c049, a.c050, a.c051, a.c052, a.c053, a.c054, a.c055, a.c056, a.c057, a.c058, a.c059, a.c060, a.c061, a.c062, a.c063, a.c064, a.c065, a.c066, a.c067, a.c068, a.c069, a.c070, a.c071, a.c072, a.c073, a.c074, a.c075, a.c076, a.c077, a.c078, a.c079, a.c080, a.c081, a.c082, a.c083, a.c084, a.c085, a.c086, a.c087, a.c088, a.c089, a.c090, a.c091, a.c092, a.c093, a.c094, a.c095, a.c096, a.c097, a.c098, a.c099, a.c100, a.c101, a.c102, a.c103, a.c104, a.c105, a.c106, a.c107, a.c108, a.c109, a.c110, a.c111, a.c112, a.c113, a.c114, a.c115, a.c116, a.c117, a.c118, a.c119, a.c120, a.c121, a.c122, a.c123, a.c124, a.c125, a.c126, a.c127, a.c128, a.c129, a.c130, a.c131, a.c132, a.c133, a.c134, a.c135, a.c136, a.c137, a.c138, a.c139, a.c140, a.c141, a.c142, a.c143, a.c144, a.c145, a.c146, a.c147, a.c148, a.c149, a.c150, a.c151, a.c152, a.c153, a.c154, a.c155, a.c156, a.c157, a.c158, a.c159, a.c160, a.c161, a.c162, a.c163, a.c164, a.c165, a.c166, a.c167, a.c168, a.c169, a.c170, a.c171, a.c172, a.c173, a.c174, a.c175, a.c176, a.c177, a.c178, a.c179, a.c180, a.c181, a.c182, a.c183, a.c184, a.c185, a.c186, a.c187, a.c188, a.c189, a.c190, a.c191, a.c192, a.c193, a.c194, a.c195, a.c196, a.c197, a.c198, a.c199, a.c200, a.c201, a.c202, a.c203, a.c204, a.c205, a.c206, a.c207, a.c208, a.c209, a.c210, a.c211, a.c212, a.c213, a.c214, a.c215, a.c216, a.c217, a.c218, a.c219, a.c220, a.c221, a.c222, a.c223, a.c224, a.c225, a.c226, a.c227, a.c228, a.c229, a.c230, a.c231, a.c232, a.c233, a.c234, a.c235, a.c236, a.c237, a.c238, a.c239, a.c240, a.c241, a.c242, a.c243, a.c244, a.c245, a.c246, a.c247, a.c248, a.c249, a.c250, a.c251, a.c252, a.c253, a.c254, a.c255, a.c256, a.c257, a.c258, a.c259, a.c260, a.c261, a.c262, a.c263, a.c264, a.c265, a.c266, a.c267, a.c268, a.c269, a.c270, a.c271, a.c272, a.c273, a.c274, a.c275, a.c276, a.c277, a.c278, a.c279, a.c280, a.c281, a.c282, a.c283, a.c284, a.c285, a.c286, a.c287, a.c288, a.c289, a.c290, a.c291, a.c292, a.c293, a.c294, a.c295, a.c296, a.c297, a.c298, a.c299, a.c300, a.c301, a.c302, a.c303, a.c304, a.c305, a.c306, a.c307, a.c308, a.c309, a.c310, a.c311, a.c312, a.c313, a.c314, a.c315, a.c316, a.c317, a.c318, a.c319, a.c320, a.c321, a.c322, a.c323, a.c324, a.c325, a.c326, a.c327, a.c328, a.c329, a.c330, a.c331, a.c332, a.c333, a.c334, a.c335, a.c336, a.c337, a.c338, a.c339, a.c340, a.c341, a.c342, a.c343, a.c344, a.c345, a.c346, a.c347, a.c348, a.c349, a.c350, a.c351, a.c352, a.c353, a.c354, a.c355, a.c356, a.c357, a.c358, a.c359, a.c360, a.c361, a.c362, a.c363, a.c364, a.c365, a.c366, a.c367, a.c368, a.c369, a.c370 FROM gpadmin.stage_split a==>line 1: Out of memory--------------------------------------------------------------------------------**** SCRIPT ENDED 18-Apr-2013 17:03:46 ****^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^