My question regards the situation were tablespace used for primary key index differs from tablespace used for the table itself. Will Orac开发者_C百科le use this index or it becomes unusable?
I am practicing SQL, and suddenly I have so many tables. What开发者_开发知识库 is a good way to organize them? Is there a way to put them into different directories?
I tried to delete the data from tablespace using the command DROP USER xyz CASCADE; I found that user was dropped but size of my tablespace did not decreased.
I have a table X in tablespace T1 and a table Y in tabelspace T2.(Oracle DB) 开发者_StackOverflow I have to create a trigger in tablespace T1 that will,
I am using the below script for generating a DDL to create tablespaces in the database. select \'create tablespace \' || df.tablespace_name || chr(10)
I\'m looking for a way to quickly \"clone\" a database from 1 pos开发者_Go百科tgresql server to another.
I have a partitioned table that belongs to tablespace report. I want to move it to tablespace record instead.
I\'m importing a database dump from one Oracle 10g installation into another. The source has a layout with several tablespaces. The target has one default tablespace for the user I\'m importing the du