Tag: table

How to Import from Excel to Oracle with SQL Developer

This question comes up about as frequently as the ‘how do I export data to XLS?’ question. It’s pretty simple once you’ve ran through the process a few times. But you may be here because you’ve never ran through the process before. This post will step you from beginning to end. You should be prepared […]

Similar Posts by Subject Areas: , ,

Oracle: Move Table to new Schema and Tablespace

A Toad user posed this question today: Is there a way to move a (marked) TABLE mytable123 from Tablespace AAA and Schema BBB to another Tablespace USERS and Schema MYSCH? Let’s tackle the 2nd and easiest part first! Moving a table or partition to a new tablespace is pretty straightforward: ALTER TABLE table_name MOVE TABLESPACE […]

Similar Posts by Subject Areas: ,

He Ain’t Heavy, He’s My Table

Many of our Toad users need to work with really wide tables. By ‘wide’ I mean a table with many, many columns. Oracle currently supports a maximum of 1,000 columns for a table or view. If that includes you, then we can help you. Ok, maybe you don’t have a 1,000 columns, but I’m guessing […]

Similar Posts by Subject Areas: , ,

Foreign Keys, a Foreign Concept?

Relational databases are powerful for many reasons, but you cannot deny the ‘relational’ part is pretty compelling. Rows or ‘tuples’ in a table are comprised of related data. So for one row in an Employee table, you can assume that each value or column pertains to that particular Employee. Of course you can’t – or […]

Similar Posts by Subject Areas: , ,

Partitioning and DBMS_REDEFINITION

Unscientific research and Twitter gossip reveals that fewer than 15% of folks out there take advantage of Oracle’s partitioning (Oracle Docs) support for tables and indexes. Folks that build their own solutions in-house are more likely to discover and use partitioning. If you use a packaged 3rd-party database solution and it uses partitioning, then I […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , , , ,