Search DaniWeb - tablespace

moving data from one default tablespace to another database default tablesp 12 Years Ago by shapam …in oracle database with default tablespace say user1, if i import data from user tablespace, after that the data will…want to know how to move data from user tablespace to user1 tablespace. i checked this issue using the below query…result showing user1 segments are there is user tablespace not in user1 tablespace. please give me idea to fix this … how to create a tablespace that consist a fix number of extents? 15 Years Ago by flaskvacuum … uniform allocation of extents. And also want my tablespace to consist only let say 5 extents. It will use … one data file. here is what i know: [CODE] CREATE TABLESPACE TABLE1 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K DATAFILE 'C:\ORACLE… Oracle : Creation of Database(tablespace) in oracle. 14 Years Ago by ajotikaramrita How to create database in oracle. Is the tablespace and database same? Do we need to install …from oracle 9i? I have the code as follows Create Tablespace SCT_DATA Datafile 'sct_data.dat' size 10M online; and …i come across the error as follows Create Tablespace SCT_DATA * ERROR at line 1: ORA-01031: insufficient … Re: Oracle : Creation of Database(tablespace) in oracle. 14 Years Ago by alit2002 Hi A tablespace is contained within the database. It is the way oracle … "/ as sysdba" SQL> Then create your tablespace create tablespace my_data datafile 'c:\oradata\orcl\my_data01.dbf' size 512m autoextend… Re: Oracle : Creation of Database(tablespace) in oracle. 14 Years Ago by yash_792 You need to be logged as sysdba only then you'll have sufficient previledges to create a desired tablespace... how to remove tablespace 11 Years Ago by Fiorentino01^ … an error message that says I have to delete the tablespace before creating another table.I don't remember the name… Re: moving data from one default tablespace to another database default tablesp 12 Years Ago by HTMLperson5 why not use the "move table" command to move tables. Then recreate your indexes. Re: Oracle : Creation of Database(tablespace) in oracle. 14 Years Ago by debasisdas The error message is self explanatory. You need to try using the command from sys or system log in or from any other account having the required prevelages. Re: Oracle : Creation of Database(tablespace) in oracle. 14 Years Ago by sudhanshoo hi friends i am unable to connect the database with my servlets, can u help me? Re: how to remove tablespace 11 Years Ago by LastMitch >I don't remember the name of the table so what can I do I only have an empty db.Thanks for your help. I think it's best to start over again with your databse remove everything. What you just mention, it's really hard for anyone to help your situation. It's has nothing to do any coding, the issue you are having is more related setting up the … Re: how to remove tablespace 11 Years Ago by Fiorentino01^ Hi I did that I deleted everything and reinstalled it but no change I still got a few empty databases and keep getting same error trying to delete them.Any other idea? Re: how to remove tablespace 11 Years Ago by LastMitch >Any other idea? **@Fiorentino01^** I don't think there's any other option I can give you base on the error: ERROR 1010 (HY000): Error dropping database (can't rmdir 'argie_tamera', errno:41). I guess do you have a back up of the preivous database & table. Try to reinstalled using the preivous database & table. I think that … Re: how to remove tablespace 11 Years Ago by Fiorentino01^ Hi I don't have a backup unfortunately.But now I have another problem.While I was trying to delete the empty databases I screwed up and messed up phpMyAdmin.Now it blocks and does not work, I need to completely remove it.I searched on the web but nothing works.I don't have apache just phpMyAdmin,workbench and of course MySQL.My phpMyAdmin version … Re: how to remove tablespace 11 Years Ago by pritaeas > My phpMyAdmin version is 3.5 something, how do I remove it phpMyAdmin is just a folder in your web-root. You can just delete that folder and install a new one. You must have Apache (or IIS) otherwise phpMyAdmin couldn't have worked. Re: how to remove tablespace 11 Years Ago by Fiorentino01^ Hi, I found the folder and deleted it.After I reinstalled phpMyAdmin vers.4.0.6 but still have same problem, cannot delete empty databases.I even reinstalled MySQL but nothing.I read that I am supposed to go into config.ini file and set drop database to true.Problem is I cannot find this file, I looked everywhere,can you tell me how to get there? … Re: how to remove tablespace 11 Years Ago by pritaeas Which config file are you referring to? The MySQL one is called MY.INI, the one from phpMyAdmin should be in it's root folder. Re: how to remove tablespace 11 Years Ago by Fiorentino01^ I found the config file in phpMyAdmin is called config-sample.inc and I have configured it.I still cannot find MySQL config file I looked everywhere,anyway the problem is still there cannot delete the empty db so I'll give up for now thanks for your help I appreciate it.I'll mark solved because something has been solved, Flexcube Problem 15 Years Ago by awo … ASC ) PCTFREE 10 INITRANS 100 MAXTRANS 255 TABLESPACE retailindx STORAGE ( INITIAL 81920 MINEXTENTS 1 MAXEXTENTS…ASC ) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE flexlive STORAGE ( INITIAL 81920 MINEXTENTS 1 MAXEXTENTS… Replacing truncate with partitions rotation 16 Years Ago by gala22 …)||v_after_tomorrow|| chr(39)||','||chr(39)||'DD-MON-YYYY'||chr(39)||'))'||' tablespace DATA'; --2 drop yesterdays partition: execute immediate 'alter table PRODUCTS_LIST….status = 'UNUSABLE') loop execute immediate 'alter index '||li.index_name||' rebuild tablespace INDX'; commit; end loop; EXCEPTION WHEN OTHERS THEN v_errmsg := SQLERRM… error in creating oracle db manually in Win XP SP2 OS 15 Years Ago by happytjia …ON NEXT 10240K MAXSIZE UNLIMITED SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'C:\oracle\product\10.2.0… AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE 'C:\oracle\product… LOCAL SEGMENT SPACE MANAGEMENT AUTO; ALTER DATABASE DEFAULT TABLESPACE "USERS"; spool off[/code] dbcamin.sql… AJax not working in IE 13 Years Ago by sidd. ….objecttype .database{ background-color: #E6E0EC; } .objecttype .tablespace{ background-color: #C6D9F1; } .objecttype .diskspace{ background-…; } .objecttype .server, .objecttype .database, .objecttype .tablespace, .objecttype .diskspace, .objecttype .cpu, .objecttype .memory,… Need to print certain lines from a file 16 Years Ago by jack00423 … like example ===== RECOVER DATABASE ALTER DATABASE OPEN; ALTER TABLESPACE TEMP ADD ALTER TABLESPACE TEMP ADD STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE -- SET… LOGFILE I want to print the lines from "ALTER TABLESPACE TEMP ADD " to till "MAXINSTANCES 1" Pleas… Re: Need to print certain lines from a file 16 Years Ago by Salem [ICODE]awk '/ALTER TABLESPACE TEMP ADD/,/MAXINSTANCES 1/' file.txt[/ICODE] Or something like it. MySql implementing Multiple databases or tablespaces like Oracle for performance 14 Years Ago by i.connect … user) Ideally i would like to have 1 tablespace(oracle style) for each user. tableSpace types are given below • AdminTableSpace  Contains the… create user 12 Years Ago by pooja28 ….... CREATE USER john IDENTIFIED BY out_standing DEFAULT TABLESPACE users QUOTA UNLIMITED ON users DEFAULT TABLESPACE temp QUOTA UNLIMITED ON system; but, oracle… Re: create user 12 Years Ago by debasisdas try this CREATE USER john IDENTIFIED BY out_standing DEFAULT TABLESPACE users QUOTA UNLIMITED ON users TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON system; Run Oracle query in powershell 9 Years Ago by md.Rayad …for a25 select SUBSTR(a.tablespace_name,1,20) "TABLESPACE",act_size,free_mb, free_mb*100/act_size "%FREE"… Re: Simple: Adding information from a textbox to a string 16 Years Ago by chrisdent1986 … = "Create user " & txtUsername.text & " default tablespace users defined by password" Dim Create As New OracleCommand… = "Create user " & txtUsername.text & " default tablespace users defined by password" Dim Create As New OracleCommand… Want to make exe/jar of a java based project 17 Years Ago by arkaprava I have done a stand alone project on Java Swing and MySql where the frontend is designed by Swing and backend is designed on MySQL I wanna build an exe of the project by incorporating the MySql schema and tablespace into the archieved file(exe/jar) Plz tell me whether is it possible? If it is possible then tell me how can I do this . Re: Want to make exe/jar of a java based project 17 Years Ago by arkaprava just Tried execJ but cannot include tablespace into the exe The application is running from exe without any operation on database